search

apache / hop

Hop Orchestration Platform
https://hop.apache.org/
Apache License 2.0
980 stars 351 forks source link

[Feature Request]: generic ODBC/JDBC connectors #3549

Open simonaubertbd opened 10 months ago

simonaubertbd commented 10 months ago

What would you like to happen?

Hello, There are more than 100 databases on the market and it's perfectly understandable than HOP won't have a connector for all. However we can imagine to leverage connections standards such as JDBC and ODBC to connect to any database (maybe not as well than with a dedicated connector but it's better than nothing).

Best regards,

Simon

Issue Priority

Priority: 3

Issue Component

Component: Database

hansva commented 10 months ago

Not sure what the question or remark is. You can create a generic connection as described in the documentation to connect with a jdbc driver where we don't have a type for. https://hop.apache.org//manual/latest/database/databases.html#_generic_connection

simonaubertbd commented 10 months ago

Hello @hansva In order to not break the "design flow", wouldn't it be interesting to add a link between the "input" category and the generic jdbc configuration? image

By the way, any chance to have generic ODBC ? :)

Best regards,

Simon

hansva commented 10 months ago

Every transform that uses a database connection has buttons next to the connection line to create a new connection.

For ODBC we used to have it (still in the screenshot in the docs) but was removed because the implementation no longer worked in Java 8+. I'm not sure there is still a way to make this work. Are there even still databases where no JDBC driver is available? Haven't seen one in a long time.

nadment commented 9 months ago

There is a JDBC-ODBC bridge provided by Cdata if you want to try if it works with Hop's generic RDBMS connector. https://www.cdata.com