Connect to an Integration

Learn how to create a new connection in Tavolo.
- Click on the
Integrations
menu in the left minibar. - From the list, click on the integration you want to connect to
- In the subsequent modal, provide required details. Please refer to the integration-specific documentation for more details.
- PostgreSQL
- MySQL
Connection to an integration thus created will be listed in the Connections
tab under the Integrations
menu.
Database Integrations
PostgreSQL
This section covers the details required to create a new PostgreSQL connection in Tavolo.
- Connection Name: Name for this connection for display on Tavolo UI
- Key in following database connection configuration details
- Host Address: Hostname of the PostgreSQL server
- Port Number: Port number of the PostgreSQL server, default is 5432
- Username: Username to connect to the PostgreSQL server, default is "postgres"
- Password: Password to connect to the PostgreSQL server
- [Optional] Database: Name of the PostgreSQL database to connect to
- [Optional] Schema Name: Name of the schema to connect to :::info Note, Database name & Schema name are optional fields when creating a connection. If provided, these details will be filled in by default when creating a new data source using this connection. :::
- Connection parameters: required if any, can be added as Key-Value pairs
- SSL Mode: This step is required if the connection required is TLS/MTLS for MITM protection. Toggle to enable SSL for the connection & select the SSL mode
- Client Certificate: Upload the client certificate file
- Client Key: Upload the client key file
- Root CA: Upload the Root CA file
- Test Database Connection: Click to verify the connection
- Create Connection: Click to save the data source
MySQL
This section covers the details required to create a new MySQL connection in Tavolo.
- Connection Name: Name for this connection for display on Tavolo UI
- Key in following database connection configuration details
- Host Address: Hostname of the MySQL server
- Port Number: Port number of the MySQL server, default is 3306
- Username: Username to connect to the MySQL server, default is "root"
- Password: Password to connect to the MySQL server
- [Optional] Database: Name of the MySQL database to connect to
Note, Database name is optional when creating a connection. If provided, it will be filled in by default when creating a new data source using this connection.
- Connection parameters: required if any, can be added as Key-Value pairs
- SSL Mode: This step is required if the connection required is TLS/MTLS for MITM protection. Toggle to enable SSL for the connection & select the SSL mode
- Client Certificate: Upload the client certificate file
- Client Key: Upload the client key file
- Root CA: Upload the Root CA file
- Test Database Connection: Click to verify the connection
- Create Connection: Click to save the data source
The connection thus created will be listed in the Connections
tab under the Integrations
menu.