- 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
Create the Datasource
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
The Datasource is the database from which bipp fetches the data.
- Select
Datasources.
- Click New Datasource
- Enter a Name. For example, TennisData.
- Select the Dialect for the SQL used for your database. bipp creates and enforces the rules for the selected dialect. For this example, select MySQL.
- Enter the connection details and the credentials. The details are different for each dialect. For this example, enter the information as shown. The password is Bippdoc$
Name TennisData Dialect MySQL Host sample-data.bipp.io Port 63306 Username bippdoc Password Bippdoc$ Database Players Connection Direct Connection UseTLS no - Click Create to add TennisData to your Datasources.
- Click
to the right of TennisData and select Ping to test the database connection.
If Ping succeeds, your Datasource is ready to go. If you have an error, select
Edit and fix the connection or credentials problem.
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