ChartIO is a cloud based data exploration and visualization tool that can be connected to your deltaDNA data to power additional dashboards and reports.

1) Create an account at ChartIO then navigate to the Data Sources page on your account and Add a Data Source
2) Select the PostgreSQL Database as your New Data Source

3) You will now be required to populate your Direct Access connection details.

PostgreSQL Connection Settings

Hostname or IP:

Database Port : leave this at the default value of 5432

Connect using SSL : Check this box

 It is recommended that you connect from ChartIO using SSL as from March of 2018 we will no longer be accepting unencrypted connections to Direct Access.

Database Username : This is the username you use to login to the deltaDNA platform

Database Password : This is the password you use to login to the deltaDNA platform

Database Name : the name of your account and the name of your game separated by a dot – this can be found on your Game Details page under Direct SQL Access

Schema Name : Leave this blank

Data Source Alias : Give this a friendly name that you will recognize on your connection list.

Finally press the Connect button and you ChartIO should connect to your data


You can use the Debug page to help identify and resolve any issues.


4) You can now add the schema to ChartIO by selecting the Schema page and clicking the button to add a custom table

chartIO add schema

5) You can now add a schema for each of the tables that you want to access.
You can add each table to the connection and give it a friendly name. You will need to enter the SQL to return a row containing the columns you are interested in.

Please Note : You should never normally be entering a select * SQL query with no conditions or limits on it, as it will try unsuccessfully to download the entire database. However, on this occasion it is OK as ChartIO is only doing this to retrieve schema details and is adding its own limit.

The column names in the schema should now be visible on the schema page if you open the connection


6) You can now run SQL queries against these tables and building reports and dashboards.


chartIO dashboard