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
chartiodatasources
2) Select the PostgreSQL Database as your New Data Source

chartio_databasetype

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

chartIOconnection

Hostname or IP:  data.deltadna.net

Database Port : leave this at the default value of 5432

Connect using SSL : Leave this unchecked

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: This is the name of the account and game that you want to connect to as shown in the URL in your browser address bar whilst logged in to deltaDNA.
NB: Please note the full stop between the Account Name and the Game Name 
demo-account.demo-game



 

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

chartIOconnection

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

chgartiodebug

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

chartioschema

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

ChartIOInteractive

chartIO dashboard