Analytics Database

What is Analytics Database ?

Analytics Database is the database which contains the data to be analysed and on which we want to build charts.

Following databases can be added as analytics database.

  1. MySQL
  2. PostgreSQL

If you require support for specific database please raise an issue on github at this link

How to connect to an Analytics DB ?

Step 1 Open DingoQL's admin and go to "Data Sources" tab.

Step 2 Click on "Connect New DB".

Step 3 Pick a datasource name. This name should be unique.

Step 4 Provide rest of the database details - JDBC url, username and password.

Step 5 Click create button.

Short video : How to connect to an Analytics DB ?