Source

Data sources, connectors & refresh — found from sitemap — Holistics

Checked for Holistics on 1 Nov 2026

Technical details

type: page
http status: 200
content hash: sha256:1dd97532992d798b05903747a58f8e9a218853dc52585a1cbb7836b4ded355d2
permission: robots_ok
screenshot: Screenshot on file (internal exhibit, not published)

Cited by

Connection methods Report an error

“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/VPN you don't want to modify any firewall rules, you can consider setting up a reverse SSH tunnel.”
Supported databases Report an error

“Amazon Athena Amazon Redshift Clickhouse Databricks Google BigQuery Microsoft SQL Server MotherDuck MySQL PostgreSQL Presto Snowflake”
Non sql sources Report an error

“We support Google Sheets and CSV/Excel. However, you need to have a SQL database, and use Holistics to load data from these sources into your SQL database.”
Recommended dedicated user Report an error

“It's a standard security practice that you should create a separate, usually read-only database user for 3rd-party services After you have set up this dedicated user, you can connect it to Holistics.”
Data storage Report an error

“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”
Cloud based Report an error

“Since Holistics is a cloud-based application, you will either need a public accessible IP or use a SSH reverse tunnel to connect your localhost to Holistics app.”