Data Sources

Our data source documentation contains information regarding the available data source features and settings, as well as instructions for connecting a new data source.

To view information about a specific data source, select Direct connection from the side navigation and choose your data source type from the Data Sources menu.

Public vs Private Data Sources

Chartio provides two methods of connecting to your database: Direct Connection and Tunnel Connection.

Direct Connection is the easiest method as it simply requires you to whitelist Chartio’s IP address (52.6.1.1) and enter your connection details on the connection page.

If your database is on a private network and you do not wish to modify any firewall rules, you instead can use an SSH tunnel to make an outbound encrypted request from your network to ours.

Local Database

Chartio cannot connect directly to databases on local machines. You will need to connect your local database using an SSH tunnel connection if you wish to connect this type of database.

An SSH tunnel connection to a local database is not recommended as a long-term solution, but it may be suitable for test or trial environments.

SSL Encryption

Chartio offers SSL encryption for database connections, but we do not validate SSL certificates at this time.

If you would like an additional level of security for your connection, we recommend using an SSH tunnel connection instead. This will give you full control over the connection.

Additional Data Sources

If your data is held in a cloud application, you can find more information about bringing in this type of data into Chartio in our cloud application data integration documentation.

You can also create Data Stores to be used as data sources within Chartio. Data Stores allow you to save queries that will run against your database(s) at specified intervals and the stored results will then be available as a Data Source to be used like any other in Chartio.

Another option to further customize how your data is displayed and queried when using Chartio’s Interactive Mode is to utilize our Custom Schema options. You can create custom columns and tables in both standard databases and in our Data Stores.