Set up a Connection

Once you have your organization ready you need to continue establishing a connection with a database to start pulling data.

The supported data sources at the moment are

  • MySQL
  • PostgreSQL
  • SQLServer
  • Oracle
  • Firebird
  • Any source compatible with ODBC

The Database server must be visible via internet from our servers, a Server into a Private Network can’t be used in Data Providers.

Be sure that your server is listening in a public network interface and that accepts incomming connections for the IPs.

  • 198.50.171.252

If your server supports it, enable the TLS support, to have the communication encrypted from end to end.

You will also need a user credentials with permissions to read in the target database. Please, be sure that the user have read only access to the tables that you need to query, keep your permissions as low as possible, only required stuff. Do not allow access to sensitive data for your customers.

For example, for MySQL, you can use a sentence like this to give into my_database read-only access to the dpro user for our given IP address

GRANT SELECT ON my_database.* TO dpro@'198.50.171.252' 
   IDENTIFIED BY 'someC0mpl3xp4ssw0rd';

NOTE: We apply in our end several security measures to be as much secure as we can be, however following that simple recommendation you can be more confident that you won’t have any security concern.

Once you have all set in your end,

  • Go to connections
  • Add new connection
  • Complete the connection form
  • Test if the connection works, if it works, save it, if not, check the form or your setup.
  • Done!

Go to connections

Connections list, no connections available

Clicking in the plus sign on right you can add one connection.

Complete the form with the connection data, use the button “Test Connection” to validate if the connection is working, if something goes wrong you’ll see an alert on the top of the form.

Error on the connection parameters

Once the connection works, click on submit to save it. Now you’ll see in the list of connections the new connection.

Connection List

The status column will show an indicator that checks if the connection is working.

Resume

You are connected to the data sources now.

You can add more connections if you need it.

Don’t forget to setup TLS for your server if you haven’t.

Remember to keep the privileges, of the user used in the connection, as low as possible. Do not allow us access to sensitive data if you don’t need it.

Now that you are connected you can retrieve data writing queries, Go to queries.