The first thing to do is to connect Holistics to your SQL database (usually data warehouse). In Holistics we call this Data Source.
If you don't use a SQL database, please refer to this page for more information.
There are 2 methods to connect SQL database to Holistics:
- Direct Connection: this is the easiest method as it simply requires you to whitelist Holistics IPs.
- Reverse SSH Tunnel: If your database is behind a firewall/closed network you don't want to modify any firewall rules, you can consider setting up a reverse SSH tunnel.
Creating DB User: Whether you choose direct or tunnel connection method, it's standard security practice that you should create a separate, usually read-only database user to connect to Holistics. Learn more
Holistics currently support the following SQL databases:
- Microsoft SQL Server
- Google BigQuery
- Amazon Redshift
- Amazon Athena
(For list of features we supported for each database, click here)
I'm concerned about data security.
You can check out our Data Security policy for more information. But in short:
- We don't store your raw data, we just store metadata/connection to your database.
- We encrypt the database credentials you provided
- The connection between Holistics and your database are secure
Can I connect to a local SQL database (for testing purpose)?
Since Holistics is a cloud-based appplication, you will either need a public accessible IP or use a SSH reverse tunnel to connect your localhost to Holistics app.
Or you can consider using something like ngrok for testing purpose.