Support ODBC/JDBC Drivers

[sherif-fanous]

Is it possible to add support for ODBC or JDBC drivers and allow users to manually configure the connection string and driver properties?

This would allow users to use this extension with almost any DB while the extension team is adding more database engines to the list of supported engines.

I know I'd love this feature to be able to work with our Trino DB that uses OAuth2 for authentication and therefore requires very specific driver property configuration

Thanks

[mikeburgh]

The challenge with the JDBC/ODBC path is you still need to know the databases underneath to properly introspection it (information_schema was a great idea, but a lot of databases are not consistent with it).

Trino is coming up, it's been asked for a lot, and I am tracking it in.. #172 if the native driver support the OAuth2 model then I should be able to pick it up.

[sherif-fanous]

The native JDBC driver supports OAuth2 using the externalAuthentication and externalAuthenticationTokenCache driver properties

[mikeburgh]

Yeah looks like it’s been done, just needs some paperwork and tests in the official JS driver.

trinodb/trino-js-client#755

Is http/s the only protocol or does JDBC use aoemthing else? Eg is http/s fine for access (I am not familiar with Trino, so just getting up to speed)

[sherif-fanous]

Is http/s the only protocol or does JDBC use aoemthing else? Eg is http/s fine for access (I am not familiar with Trino, so just getting up to speed)

Yep, http/s is the protocol

[mikeburgh]

I just pushed a preview release of Trino.. Tracking it in #279 , still need to pick up the OAuth and some other stuff, but moving in the right direction