- Getting Started
- Managing Tenants and Spaces
- Using Development Mode
- Using Datasources
- Connecting Databases
- MySQL
- Postgres
- Amazon RedShift
- Microsoft SQL Server
- BigQuery
- Snowflake
- MongoDB
- ClickHouse
- Hive
- ETable
- Impala
- Oracle
- Teradata
- Google Sheets
- Google Analytics
- Public Dataset
- Using Projects
- Using Datasets and Reports
- Using Visualizations
- Using Dashboards
Connecting Databases
CONTENTS
Home
- Overview
- Getting Started
- Managing Tenants and Spaces
- Using Development Mode
- Using Datasources
- Connecting Databases
- MySQL
- Postgres
- Amazon RedShift
- Microsoft SQL Server
- BigQuery
- Snowflake
- MongoDB
- ClickHouse
- Hive
- ETable
- Impala
- Oracle
- Teradata
- Google Sheets
- Google Analytics
- Public Dataset
- Using Projects
- Using Datasets and Reports
- Using Visualizations
- Using Dashboards
Datasources are essentially the connected databases where the model gets the data. Projects and models can connect to multiple data sources. Each database has a specific dialect and requires different information to make a successful connection.
Note You must be in Development Mode to connect a database.
Here are the databases bipp supports:
- MySQL 5.7+
- Postgres 9.x+
- RedShift
- SQL Server 2017+
- BigQuery
- Snowflake 3.27+
- MongoDB 3.2+
- ClickHouse
- Hive 2.x.x+
- ETable
- Impala 5.x+ - Requires bipp Enterprise Edition
- Oracle 12c+ - Requires bipp Enterprise Edition
- Teradata 15.x+ - Requires bipp Enterprise Edition
- GoogleSheets
- GoogleAnalytics
- Public Datasets
Email bipp if you find problems or have updates for the database connection information. Your help is appreciated!
IN THIS PAGE
Sign up for a forever free account!
Connect to leading SQL databases
Build visual data models without learning a new language
Create two dashboards and ten reports for free