You can connect your database to Chartio in two ways. Both methods enable your server to communicate with Chartio by creating a read-only user on your reporting database.
We recommend the tunnel connection method because your database doesn't need to be accessible to the internet to connect to Chartio. In this method you connect to Chartio via an encrypted reverse SSH tunnel by running an easy installer from the command line. Along the way a read-only user is connected.
Through this method, the read-only user is granted access only from your localhost. This means that even the access credentials of the read-only user require the SSH tunnel to be running.
If at any point you would like Chartio to no longer have access, simply take down the tunnel and Chartio will no longer be able to communicate with your database, and any of its access information will be irrelevant.
In the direct connection method you create a read-only user, bound to a given Chartio IP address for limited access to your database. The user can be permissioned to access all or a limited number of tables and columns in your database. Your database must also be accessible on a port that is open to that given Chartio IP address. Finally, in the Chartio UI, you'll enter the host address, port, database name and the read-only user credentials.
For databases that support SSL encrypted connections, Chartio will also accept an SSL certificate.
Databases hosted by cloud database providers such as Heroku, Amazon RDS and Rackspace Cloud Databases connect to Chartio with different versions of those data sources' common cloud authentication processes, which are roughly analogous to the direct connection method.
Data sources from third-party service providers connect to Chartio in different ways. Google Analytics and Salesforce connect via those services' provided authentication processes; the same way they connect to any other third-party service. In all cases we use service-provider-recommended, industry standard connection methods to give you access to your data.
Because we believe that your data should stay with you on your servers as much as possible Chartio does no warehousing of your database data. For more information continue reading our security documentation on why we work directly with the database and how chartio accesses your data.
Request a Demo
Tell Us About Your Company