Adding a Datasource

A datasource is a combination of a specific database and the credentials to access it.

Adding a datasource is a relatively simple process, assuming that you’ve met all of the relevant prerequistes.

  1. Before beginning, you must ensure that the datasource you’re attempting to add is accessible from either your strongDM relay or the strongDM-hosted relay pool (IP whitelisted deployments only). For more information on relays, see this guide. Additionally, you must have a properly configured account (username, password) on the datasource you’ll be adding.

  2. Login to the Admin UI at https://app.strongdm.com and select Datasources on the left hand navigation.

  3. In the upper right hand section of the screen, click the ‘add datasource’ button. You’ll be presented with a dialog like this: "Add datasource dialog"

  4. In this dialog, you’ll configure how your relay (or strongDM-hosted relays) will connect to the datasource.

  5. Type in a Display Name - this is how the datasource will show up in the Admin UI and local clients - in this case, ‘testdb-01’

  6. Select the type of datasource from the available list of DBMS - in this case, PostgreSQL

  7. Enter the hostname. It’s imperative that the entry you choose for Hostname is one that the relay server can connect to. To verify this, hop on the relay server, and from a command prompt, type: $ ping <YOUR_HOSTNAME> If your relay can connect to this hostname, you’ll be able to proceed. In this case, ‘testdb-01.fancy.org’

    EXCEPTION: If you are connecting to a Mongo Replica Set, enter the hostnames and ports of the members of the replica set here in the format host1:port1,host2:port2,...,hostX:portX. Fill in the name of the replica set in the Replica Set field below.

  8. When you select the type of DBMS in Step 6, it will automatically fill in the Port field with that database’s default port for connectivity - in this case, 5432. If you know that your database is set to connect on a different port, enter that port here now.

  9. Type in the name of the database you’ll be connecting to with this datasource; in this case, ‘booktown’

  10. Type in the Username that the relay be connecting to the database with; in this case, ‘testdbuser’

  11. Type in the Password of the username entered in Step 10.

  12. If the user has a particular schema they should use upon logging in, enter that here.

  13. By default, for PostgreSQL and its derivative DBMS (e.g. Greenplum), strongDM will limit all connections to the configured database. If you would like to change that, uncheck this option.

  14. Click the ‘create’ button. Once this is done, the Admin UI will update and show your new datasource in a yellowed state while it runs initial health checks. "Datasource not ready"

  15. Eventually, you should see that datasource in the list goes into a gray, then green mode: "Datasource ready"

    If you have multiple datasrouces to create, follows steps 1 - 15 for each datasource.

    If any errors occur, please copy them into an email and send to support@strongdm.com.