Connect to an Integration

1. Click on the Integrations menu in the left minibar.
2. From the list, click on the integration you want to connect to
3. 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.

1. Connection Name: Name for this connection for display on Tavolo UI
2. 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. :::
3. Connection parameters: required if any, can be added as Key-Value pairs
4. 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
5. Test Database Connection: Click to verify the connection
6. Create Connection: Click to save the data source