Use a properties file to customize a JDBC connection

[BentsiLeviav]

Use case

As of today, several tools rely on the JDBC client under the hood, including DataGrip, Tableau, DBeaver, and others. For Tableau, due to vendor limitations, it’s not possible to pass JDBC configurations through the connection string. Instead, configurations must be provided via a properties file.

This approach can also benefit other JDBC-based tools like DataGrip and DBeaver, or scenarios where customers prefer to manage configurations based on the environment rather than being tied to a specific application.

Describe the solution you'd like

The client should look for the properties file in some default location, in the class path, or in a configurable path.

Additional context

For Tableau's requirement, you can find details here