Need help to connect my database with Oracle SQL developer 11g

KNIME Analytics Platform
1

Hi All 

I am unable to connect with database using Database Connector.

Additionally i have also added database driver ojdbc6.jar to connect, unfortunately not able to connect.

Can i request for a help on procedure i need to follow to connect using any specific node for Oracle SQL Developer - 11g.

 

Regards

Praveen

2

Hi Praveen,

did you setup correctly the database URL parameters

host

port

database_name

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

What king of error message did you get in the knime console ?

Regards

Thierry

3

Thanks for reply..

is able to resolve the issue after adding SID (Oracle system ID)

Regards

Praveen