JDBC Driver details

[Former Member]

hello

I have a JDBC Sender scenario. I installed the JDBC driver and I would like to know where can I get the data for the communication channel:

JDBC Driver

connection

also where and how do I create username and password?

are they u/p on the JDBC Driver or this are the U/P directly to the DB?

Thanks

Kfir

[rajasekhar_reddy14 · Accepted solution]

> I have a JDBC Sender scenario. I installed the JDBC driver and I would like to know where can I get the data for the communication channel:

> JDBC Driver

> connection

You have already installed driver in PI system,so you shoul know the driver name,which db driver you have installed??

>

> also where and how do I create username and password?

> are they u/p on the JDBC Driver or this are the U/P directly to the DB?

>

user name and password should get from Data base team,the details what you are going to enter,the user name should have authorizations to access the data base.

data base name also you will get it from Data Base team,like where you updating or inserting data.

Regards,

Raj

[Former Member · Accepted solution]

hi,

the installation jar is ojdbc14.jar.

my DB is oracle 10.

I couldnt find, as I wrote before where do I find the string of the JDBC drvier name. in what folder on the PI Server.

also, where do I get the connection to the DB?

(I know the DB Schema and other parameters that I need)

Kfir

[GabrielSagaya · Accepted solution]

Please check those article that could help you!!

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/bdd6a690-0201-0010-238a-9c95a5fb6...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/60237e74-ef19-2b10-5a9b-b35cc6a28...

[Former Member · Accepted solution]

thanks for the help.

one article show me how to upload the driver which I did.

I would like to know where do I get the information string in order to config my JDBC Sender communication channel.

I need to pu there the string of JDBC Driver and connection.

as far as I know this is a copy/paste issue from one of the folder that I can not find.

I would like to know where do I get this strings or what is the convention of writing one

Kfir

[Former Member · Accepted solution]

Hi Kfir,

Try this:

JDBC Driver: oracle.jdbc.driver.OracleDriver

Connection String: jdbc:oracle:thin:@<HOST>:<PORT>:<SID>

Here SID is the SID of the end-system DB and not the PI system.

Cheers,

Varun