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.
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
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
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.
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.
