JDBC Sender

[Former Member]

Hi,

We have DB Link (Oracle Based) as a system which needs to be connected for XI.

Xi will need to fetch two tables at a time and update the same. I would like to know the complete pre-requisite required to use the scenario.

Please do guide me on this.

Edited by: Krish on Apr 30, 2009 11:13 AM

[rajasekhar_reddy14 · Accepted solution]

we can fetch the data from DB System use sender jdbc adapter

1) configure required jar files .

2) write join statemnet to get the data from two tables.

please find below link.

http://help.sap.com/saphelp_nwpi71/helpdata/en/33/e6fb40f17af66fe10000000a1550b0/frameset.htm

http://help.sap.com/saphelp_nwpi71/helpdata/en/43/9519abb1146353e10000000a11466f/frameset.htm

and explain u r requirement bit clearly..

cheers

raj

[Former Member · Accepted solution]

Hi,

Prerequisite for using JDBC adapter.

1) JDBC adapter driver wont be available as default.

Please ask your BASIS team to configure Oracle driver. Create com,sap.aii.jmsproviderlib.sda file after inserting appropriate jar file. If ur source DB is ORACLE 10.2 you need ojdbc14.jar/class file which is available in the ORACLE vendor site. Append the jar file to jmsproviderlid file and deploy through SDM.

Please check in Visual admin whether drivers are installed or not.

2) Fetchin from two table.

As far as my knowlede you need to write stored procedure for JOIN query and fetching from two table.

Thanks,

Regards,

Vineetha.

[jyothi_anagani]

Hi Krish,

Refer this link. It will really help you.

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/frameset.htm

Thanks.

[Former Member]

Hi Krish,

Pre requisites to access the data from Database.

To access the data from the database we need the jar files for that drivers, BASIS guys install this drivers on the PI system.

We have to know the connection and driver path, and know the database user name and password.

By using the select/join statement we can retrieve the data from multiple tables.

Regards

Ramesh

[former_member732072]

Hi Krish,

Please have look at the following links and see if it helps.

and

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/ee5bc490-0201-0010-e9b5-a258cf08...

Best Regards