Oracle Database Connector with SID

KNIME Analytics Platform
1

Hello,

I try to connect to a remote database using the database reader node.

I have the following information about the database available: Host, Port, SID.

jdbc:oracle:thin://<host>:<port>/<database_name>,

the connector asks for "host", "port" and "database_name". "Host" and "Port" are clear but I don't know what to enter as "database_name". I tried entering the SID by I get the following error:

TNS:listener does not currently know of service requested in connect descriptor

I can connect to the database via SQL Developer no problem so its not a connection/database problem.

Any advice?

Thank you

2

Hi,

you should be able to connect to the database by using the SID as the database_name. For details about the jdbc connect string see the OraFAQ.

Don´t you also need to specify the jdbc connect string in the SQL Developer? If that is the case just use the same string in the Database Connector node.

Bye,

Tobias

3

Hello Tobias,

thank you for your input. Problem has been solved by using

"jdbc:oracle:thin:@<host>:<port>:<SID>"

as connection string.