IBM db2 connection help

[elaadani]

Hi, I need help to connect to IBM DB2.
I have followed some instructions on this forum, but have not been able to get there.
I have uploaded the drivers in preferences, database in knime, but I use legacy database, because I don’t know the ID of the jdbc driver.

Then, in the node configuration I do this

and I get this

Please help me with this

Thank you in advance

[mlauber71]

Id and name should be something you set in order to identify your driver. So you could invent something like in this example

SQLITE and Window Functions

@tobias.koetter thank you for this hint this opens up the whole world of window functions. I downloaded the latest JAR file from the Maven site and told KNIME where to find the driver. [image] [image] @khatuaani now you can benefit from the latest developments with H2 (and SQLite).

[ipazin]

Hello @elaadani,

I suggest to register driver with non legacy framework and then we can troubleshot it together if you fail to connect. For registering your own JDBC driver check this part of database guide:

https://docs.knime.com/latest/db_extension_guide/index.html#register_jdbc

Br,
Ivan