Connecting Databases
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:
- BigQuery
- ClickHouse
- ETable
- GoogleSheets
- Hive 2.x.x+
- Impala 5.x+ - Requires bipp Enterprise Edition
- MongoDB 3.2+
- MySQL 5.7+
- Oracle 12c+ - Requires bipp Enterprise Edition
- Postgres 9.x+
- Public Datasets
- RedShift
- Snowflake 3.27+
- SQL Server 2017+
- Teradata 15.x+ - Requires bipp Enterprise Edition
Email bipp if you find problems or have updates for the database connection information. Your help is appreciated!
Sign up now for a forever free BI tool!
Connect two data sources and access two dashboards
Unlimited usage of the bippLang data modeling language
Enterprise-grade, cloud, in-database business intelligence platform