How to connect to your Database

Advanced Analytics enables you to connect to various databases and use them as data sources.

Note
Be aware that once added, Database integration becomes available for all the users of the Company. Since that, any user can build Data sources based on these integrations’ data. These data sources are visible only for their creators, but may be shared manually if needed.

To create an integration with your database, head over to the Data sources page and click the +Data source button at the top of the page. Select Create New Integration from the submenu:

Another way to do that is to head over the Integrations page and then press the +App or database button at the top:

After that, you should choose the desired database and fill in the following gaps in the integration setting window. The window consists of three tabs: General, Security, and Data Refresh.

In the General tab, you should enter your connection details such as:

  • Host
  • Database name
  • Username
  • Password

Note
For certain databases, the connection settings may vary.

In the Security tab, you can set your security preferences.

In order to protect your data and ensure that all data remains private and integral, we recommend selecting the Use SSL option (if it’s supported by your DB server).

Advanced Analytics connects to your database in a read-only mode. This provides an additional layer of security against malicious queries. Nevertheless, we recommend using a read-only user for connecting to your database. Create a new read-only user, if you haven’t yet, and grant the user privileges. Please refer to your DB documentation to learn how to create a read-only user.

In the Data Refresh tab, you can set the frequency of automated updates of your data. Select the desired update rate, update time, and time zone of cache flushing.

When ready, click the Check Connection button. If the connection is successful, you will see the corresponding message:

Next, press the Create button in the bottom right corner. Created integration will appear in the Integrations menu. After the integration is added, you can start building data sources based on it. To know more about creating data sources, please follow the link.

Was this article helpful?
Thank you!
Is there anything we can improve? Message
We’re sorry to hear that
Please explain why this article wasn’t helpful to you. Message
Thank you for your feedback!
We’ll review your message and use it to help us improve your experience.
Rate this page
Rate this page
Is there anything we can improve?

Don’t want to answer

Thank you for your feedback!
Last updated: July 14, 2021

Found a typo or other text error? Select the text and press Ctrl+Enter.

Report a problem
We always review our content. Your feedback helps us improve it.
Provide an email so we can follow up
Thank you for your feedback!