ODBC connector or bridge for DB2

[ibm]

ODBC connector or bridge for DB2

[amitsadaphule]

Thanks for the quick and detailed response @shawnzhu! I'll discuss the options with my team.

[shawnzhu]

To be precise, this connector for Prestosql does depend on JDBC type 4 driver of Db2. see https://github.com/IBM/presto-db2/blob/acc92bfe7f408255c61d448503c316069b4085e9/pom.xml#L17-L21

So it's not based on ODBC connection (JDBC type 1, can be bridged to JDBC) nor any other native compiled code (JDBC type 2).

I was wondering if there is something that can maybe act as a bridge for ODBC using this connector

This is possible since you can try to hack the method getConnectionFactory() via JDBC type 1 driver (uses ODBC interface).

https://github.com/IBM/presto-db2/blob/acc92bfe7f408255c61d448503c316069b4085e9/src/main/java/io/prestosql/plugin/db2/DB2ClientModule.java#L55-L70

Following☝️approach, it will need more work including installing/redistributing Db2's ODBC drivers/dependencies for specific Db2 release/installation. Which might not be done via this project under Apache License v2.0.

Out of the context of prestosql, Db2 client driver for Python/Node.js/Golang depend on ODBC driver and all of them works out of box. E.g., https://github.com/ibmdb/python-ibmdb

[amitsadaphule]

@gerrith3 @seth-priya FYI