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 at least one of your gateways or relays. 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 gateways or 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 database types - in this case, PostgreSQL

  7. Enter the hostname. It’s imperative that the entry you choose for Hostname is one that at least one gateway or relay can connect to. To verify this, hop on the gateway or relay, and from a command prompt, type: $ ping <YOUR_HOSTNAME> If the gateway/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 datasource type, 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. The Port Override field provides an organization-wide standard port for users to connect to this datasource via their client. In most organizations this field will automatically populate; you can overwrite it with your own preferred port.

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

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

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

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

  14. 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.

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

  16. Eventually, you should see the icon turn gray, then green: "Datasource ready"

  17. If it does not turn green, check the Diagnostics tab for errors.

If you have multiple datasources to create, follow the above steps for each datasource.

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