Zing Data has tested and verified connections with trusted partners.
Set up multiple data sources to seamlessly view tables and questions from across all your database sources all in one screen.
PostgreSQL
Postgres is one of the most commonly used databases in the world, is open source, and has around for 30+ years. Zing Data connects to any PostgreSQL database and has been tested with thousands of tables and for long-running queries. Zing also supports multiple schema within a Postgres database.
MySQL
MySQL is one of the world’s most popular databases, now owned by Oracle. Zing Data connects to any MySQL database, tested to thousands of tables and for long-running queries.
Google BigQuery
Google BigQuery is a powerful, cloud-hosted database that scales to huge data volumes easily. Available with a free-to-try version, BigQuery is an easy way to get up data in the cloud without having to deal with hosting, database maintenance, or database optimization. Zing is a trusted Google Cloud Partner, verified by the team at Google to work with Google BigQuery.
Snowflake
Snowflake is a cloud-based data warehouse that is popular for ingesting, transforming, and querying data from many sources. Available with a free-to-try version, Snowflake is an easy way to get up data in the cloud without having to deal with hosting, database maintenance, or database optimization.
Google Sheets, Microsoft Excel, and CSV files
Google Sheets and Microsoft Excel are commonly used spreadsheets. Other common data analysis tools and spreadsheet programs allow saving files as comma separated values. Zing can connect to data from these sources via the Google Sheets Integration.
Zing also supports two modes for Google Sheets:
- Live connection mode, where Zing always pulls from the latest version of the sheet
- Snapshot mode which ‘freezes’ the gSheet at the point you make the connection, so subsequent changes to the sheet won’t be reflected in Zing.
Trino, Presto, And Starburst
Trino is a fast, distributed query engine that can support large queries and heavy analytics workloads. It is free and open source, and is a successor to the open source Presto query engine.
A hosted and well-supported version of Trino is available from Starburst.io. Zing has been tested to work with all three variants. Find out more about how Zing and Starburst can work together here!
Databricks
Databricks is a cloud data warehouse and lakehouse that runs on Amazon Web Services, Google Cloud Platform, and Microsoft Azure.
Created by the people behind Apache Spark, Databricks is able to support large-scale workloads and the SQL Warehouse functionality provided allows you to set scaling and timeouts to optimize cloud spend.
Zing is an official Databricks partner. Learn more here!
Mozart Data
Mozart Data is a full-service modern data platform for centralizing, organizing, data across multiple sources. Get set up in an hour and start working with support from Mozart’s data analysts. Mozart lets you pull data from more than 200 data sources and join across them including Salesforce, Google Analytics, Adobe Analytics, Amazon S3, Hubspot, Facebook Ads, Square, Stripe, and SAP Concur.
Microsoft SQL Server
Microsoft SQL Server is one of the most widely used databases for enterprise deployments, developed by Microsoft. MS SQL is scalable and includes ETL (Extract, Transform and Load) tools and reporting services. It is evolving rapidly in the cloud and on hybrid platforms. You can get Zing connected to your MS SQL database with our set-up guide here
Clickhouse
Clickhouse is an open-source database management system (DBMS) for online analytical processing (OLAP). It uses a column-based structure. Clickhouse was designed to be fast and highly-scalable. Clickhouse stands out for high performance because it gives attention to low level details when performing queries. Get connected to your Clickhouse database with our set-up guide here
Portable
Portable’s self-service ELT product makes it simple to replicate data from 250+ business applications to your data warehouse with no-code.
Cube JS
Cube is a cloud infrastructure layer that lets you connect to MongoDB, Postgres, Athena, Bigquery, mySQL, Hive, Snowflake, and other databases to transform underlying data sources into more easily queryable and visualizable data. They have a free tier, and are a great way to get started with Zing for data sources that Zing doesn’t yet natively support, or where data transformation is needed. This video walks you through how to use Cube’s SQL API with Zing.
Hydra
Hydra is an open source cloud data warehouse built on Postgres that offers high uptime and scales to large datasets easily. Zing can connect to Hydra as a Postgres data source to enable easy analytics on even large warehouse datasets. Follow the Postgres setup instructions here to get set up.
Agile Data
Agile Data is a data automation tool which provides data to Zing so you can easily take action. Agile Data supports business analyst and data analyst teams to translate business questions into repeatable data.