Connect to Oracle database with SID

OL Connect Professional DataMapper
1

Hi,

We want to connect to an Oracle database server with SID like that :

jdbc:oracle:thin://username:password@serveurIP:1521:SID

Actually we cannot do it with the wizard, how we can do by an other way ?

Thanks for your help.

HH

2

Hi,
I would suggest you to use a script within the Datamapper to Connect to the Oracle database.
There is a MySQL sample in the forum on the following link.
You should change it to your needs.
Here is the link:

3

Hi,

I can connect inside a script.

I found a woraround, Use wizard for jdbc derby connection and change mannually the connection string to an oracle connection.

HH