JDBC Receiver adapter

[Former Member]

Hi All

We have been live for about 6 months, Now we have a scenario where we need to write file to a sql database. I have read post that tells me to intsall the jdbc drivers, In one of the post they say we need to change the secure sore from oracle to sql? Is this going to avect the way the system work currently? Any help on jdbc receiver would be appreciated still a bit confused on where to begin.

Regards

[Former Member]

hi

please check the following links

Tips and Tutorial for Sender JDBC Adapter

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

http://help.sap.com/saphelp_nw04s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/content.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Also you can look at this scenario --> File to JDBC:-

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

Regards.

[Former Member]

Hi Stephan,

We use the JDBC adapter and the experiences so far are very good.

I think that if you read the standard JDBC adapter documentation on sap.help.com, you will see that the installation and configuration is pretty straight forward.

I expect that there's no need to change any settings on your DB in order to use this adapter unless you have very specific requirements...

Regards,

Rob