Connect Database

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.

Connection Methods

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

Supported Databases

Holistics currently support the following SQL databases:

  • PostgreSQL
  • MySQL
  • Microsoft SQL Server
  • Google BigQuery
  • Amazon Redshift
  • Snowflake
  • Presto
  • Clickhouse
  • Amazon Athena

FAQs

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.