Holistics currently support the following SQL databases:
- Microsoft SQL Server
- Azure DB via Microsoft SQL Server
- Google BigQuery
- Amazon Redshift
- Amazon Athena
Since each database has their own unique features, not all functionalities in Holistics are supported across all databases. Below is the matrix table of what we support for each database.
Support for spreadsheets sources
Besides the SQL connectors, Holistics also support a few non-SQL data sources: CSV/Excel files, Google Spreadsheets.
To work with these sources, please use our Import Model concept to load them into your SQL database.
Support for other sources
For NoSQL sources (MongoDB, CouchDB, etc) and application sources (Salesforce, Hubspot, Facebook Ads), we recommend you use a dedicated ETL/EL tool, load the data into your data warehouse, and use Holistics to visualize them.