Configuring connections

JDBC connections contain parameters to manage connections to the database so that the connector uses to provide services.

Microsoft SQL Server

Select Truststore Alias from the list. If the option is not available in the list, then upload your certificate by selecting the + icon next to the Truststore Alias list.
Set the Other Properties to
```
loginTimeout=60;encrypt=true 
```

Oracle

Select Truststore Alias from the list. If this option is not available in the list, then upload your certificate by selecting the + icon next to the Truststore Alias list.
Set Network Protocol to tcps. The default value of tcps port is 2484.

PostgreSQL

Select Truststore Alias from the list. If this option is not available in the list, then upload your certificate by selecting the + icon next to the Truststore Alias list.
Set Network Protocol field is not mandatory for PostgreSQL account.

MySQL

Select Truststore Alias from the list. If this option is not available in the list, then upload your certificate by selecting the + icon next to the Truststore Alias list.

Tibero

Select Truststore Alias from the list. If the option is not available in the list, then upload your certificate by selecting the + icon next to the Truststore Alias list.

SAP HANA

Select Truststore Alias from the list. If the option is not available in the list, then upload your certificate by selecting the + icon next to the Truststore Alias list.

Set the Other Properties to

loginTimeout=60;encrypt=true;hostNameInCertificate=<host name>

Amazon Redshift

Select Truststore Alias from the list. If the option is not available in the list, then upload your certificate by selecting the + icon next to the Truststore Alias list.
Set the Other Properties to
```
loginTimeout=60;SSL=true;SSLMode=
```

Snowflake

Snowflake connections use SSL by default.
The Database Connector supports key-based authentication just for Snowflake database.
Select the Keystore Alias from the list. If this option is not available in the list, then upload your certificate by selecting the + icon next to the Keystore Alias list.
Set the properties in the Snowflake account keyPairAuthN=true and warehouse = COMPUTE_WH.

Vertica

Select Truststore Alias from the list. If the option is not available in the list, then upload your certificate by selecting the + icon next to the Truststore Alias list.

Databricks

On the Configure Connection Type form, set the following values in the Connection Properties section.

Set Other Properties as String url = "jdbc:databricks://<your-databricks-host>:443;transportMode=http;ssl=1;httpPath=<http-path>;AuthMech=3;UID=token;
Set the User as token.

Synapse

Transaction Type. Azure Synapse SQL does not support XA transactions. These transactions rely on a two-phase commit protocol for distributed transaction management, which requires full support from both the database and JDBC driver.
Azure Synapse lacks support for XA-compliant distributed transactions and full two-phase commit protocols.
Database Name is required, but if it is not provided, the connection defaults to the master database. However, SQL queries cannot be executed in the master database.
Other Properties are optional.