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

For non-SQL data sources: we support MongoDB, Google Sheets, CSV/Excel. However, you need to have a SQL database, and use Holistics to load data from these sources into your SQL database.

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.