SAP XI JDBC Adapter

[Former Member]

Hi,

I have few question and I am requesting you to answer my questions.

1. What is the purpose of Program ID to specify when we configure the Sender RFC communication Channel?

2. How to get the JDBC Driver name , connection parameters, Host and Port for the JDBC Communication channel configuration. My Basis consultant said, he has not aware this JDBC Adapter?

I need to use JDBC Adapter for my JDBCXIFile Scenario. Please explain me the step by step procedure. Please explain me from where we need to get the above parameters and JDBC Driver already configued in XI. I need the Driver name with syntax and connection parameters, host and port.

3. Where we need to write the SQL Query for SELECT, INSERT, DELETE, and UPDATE in configuring the Receiver JDBC Communication channel?

I am very thankful to you in advance.

Nagarjuna.

[Former Member · Accepted solution]

Hi,

I have few question and I am requesting you to answer my questions.

1. What is the purpose of Program ID to specify when we configure the Sender RFC communication Channel?

Program ID : Program ID of the registered server program. The selected program ID must uniquely describe the RFC sender channel in the configured gateway (Application Server (Gateway) and Application Server Service (Gateway) parameters). Also this program where you execute your RFC function with specified RFC destination.

2. How to get the JDBC Driver name , connection parameters, Host and Port for the JDBC Communication channel configuration. My Basis consultant said, he has not aware this JDBC Adapter?

I need to use JDBC Adapter for my JDBCXIFile Scenario. Please explain me the step by step procedure. Please explain me from where we need to get the above parameters and JDBC Driver already configued in XI. I need the Driver name with syntax and connection parameters, host and port.

Host and Port for the JDBC Communication channel configuration: there are DB parameters which you are using.

info about installation drivers for JDBC & JMS adapters

FIRST: drivertool you can find at https://www.sdn.sap.com/irj/sdn/howtoguides

Then Exchange Infrastructure How-to Guides for SAP NetWeaver 2004 How to Install and Configure External Drivers for JDBC & JMS AdaptersDownload attached system files (ZIP 16KB)

SECOND:installation guiade:

External Driver Configuration for Process Integration 7.0

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

Tips and Tutorial for Sender JDBC Adapter

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

File-to-JDBC(Receiver JDBC)

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

3. Where we need to write the SQL Query for SELECT, INSERT, DELETE, and UPDATE in configuring the Receiver JDBC Communication channel?

You write them in action tag in Message Mapping.

For the details find "Document Formats for the Receiver JDBC Adapter" on help.sap.com

BR,

Dzmitry

[Former Member]

yes

[Former Member]

Hi,

JDBC ADAPTER

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

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

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

JDBC - http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

multiple tables with JDBC - http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous

JDBC RECEIVER ADAPTER

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

Regards

Pullarao