Hi, I’m working on a telecom audit project and need to connect KNIME to an Oracle database using ODBC. I’ve used ODBC connections in other platforms like Alteryx, but I’m having trouble figuring out the best way to set this up in KNIME. I’ve tried using the Oracle Connector node, but without any luck.
If anyone has any advice on how to achieve this I would really appreciate it!
Hi @AshlynStahl , welcome to the KNIME community forum.
I wonder if you could elaborate on why you “need” to use ODBC. KNIME, being a java based application natively uses jdbc drivers and the database connection nodes are designed to use JDBC.
Alteryx, by contrast, is not written in java and I believe generally uses ODBC.
This post from 2016 explains that java no longer includes the JDBC ODBC Bridge.
Although I’ve not tried this (and don’t know how old it is or if it is still relevant) have you seen the following page from cdata?
https://www.cdata.com/kb/tech/bridge-jdbc-knime.rst
I’m intrigued though why you’d want to go to such a lot of effort (and possibly expense) to connect to Oracle when the JDBC driver is ready and waiting to do the job, hence my question over the rationale behind needing to use ODBC.
2 Likes
Hello @AshlynStahl ,
welcome to the KNIME Community 
as @takbb already mentioned connecting to Oracle via ODBC is tricky and requires a commercial third party driver.
That said usually if you can connect via ODBC you can also connect via JDBC. How to set this up in KNIME for Oracle is explained here. Once KNIME is properly setup you only need is the database host name, port (if you don’t know it use the default 1521) and your DB login.
If you want to know more on how to work with databases in KNIME check out the KNIME Database Extension Guide or view one of the available videos on KNIMETV.
Bye
Tobias
3 Likes
