proxies to jdbc scenario help...!

[Senthilprakash1]

Dear All,

I am very new to XI , can anyone guide me step by step process for

1. File to webservice scenario via xi

2. Proxies to jdbc scenario via xi

3.IDOC to JDBC scenario via xi

will be much helpful as i need to complete these processes very soon.

Thanks in Advance.

[Former Member · Accepted solution]

HI,

Here are the documents:

Webservice scenario:

these 3 documents should explain it all,

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/befdeb90-0201-0010-059b-f22...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5f3ee9d7-0901-0010-1096-f5b...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/d23cbe11-0d01-0010-5287-873...

troubleshooting SOAP:

/people/varadharajan.krishnasamy/blog/2007/01/09/troubleshooting-soap-message--xi

IDOC and JDBC Scenarios:

/people/prateek.shah/blog/2005/06/08/introduction-to-idoc-xi-file-scenario-and-complete-walk-through-for-starters --> For Idoc sender: IDOC -file

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 --> for jdbc receiver: file -JDBC

IDOC configuration :

Refer the help:

/people/swaroopa.vishwanath/blog/2007/01/22/ale-configuration-for-pushing-idocs-from-sap-to-xi - ALE settings for R3-XI

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e07dcaa0-a92b-2a10-3a96-b3d942bd...

Idoc to File:

/people/prateek.shah/blog/2005/06/08/introduction-to-idoc-xi-file-scenario-and-complete-walk-through-for-starters

This is expalined both the scenarios:

Please follow the below process for configuration:

Pre-requisites for Inbound IDoc to R/3 from PI:

Configuration required at Xi side:

Go to IDX1: configure the port.

Go to IDX2: load the DOC metadata.

Go to SM59: Create RFC destination which points to R3 system this is require in the case where your IDOC is sent to R 3 system,

Configiration required at R3 side:

Maintain Logical System for PI (SALE transaction):

Maintain Partner Profile for XI system(WE20):

Pre-requisites for Outbound IDoc from R/3 to PI:

Configurations required in R/3:

Maintain Logical System (SALE)

Define RFC Destination (SM59) which points to PI system

Maintain Port (WE21)

Maintain partner profile. (WE20):

Maintain Distribution Model (BD64):

JDBC:

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

Writing Stored Procedures-

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

http://www.ics.com/support/docs/dx/1.5/tut6.html

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

http://www.ics.com/support/docs/dx/1.5/tut6.html

http://java.sun.com/docs/books/tutorial/jdbc/basics/sql.html

http://www.sqlteam.com/article/stored-procedures-an-overview

Proxy:

Client Proxy:

/people/ravikumar.allampallam/blog/2005/03/14/abap-proxies-in-xiclient-proxy

Server Proxy:

/people/siva.maranani/blog/2005/04/03/abap-server-proxies

Smarter Approach for coding ABAP Proxies

/people/sravya.talanki2/blog/2006/07/28/smarter-approach-for-coding-abap-proxies

File to Inbound Proxy:

/people/prateek.shah/blog/2005/06/14/file-to-r3-via-abap-proxy

How do you activate ABAP Proxies?

/people/vijaya.kumari2/blog/2006/01/26/how-do-you-activate-abap-proxies

Debugging Inbound Proxy:

/people/stefan.grube/blog/2006/07/28/xi-debug-your-inbound-abap-proxy-implementation

Thanks and Regards,

Chirag Gohil

[Former Member]

Hi

File to Webservice

1.Configure the File Adapter as Sender Adapter.

For the Webservices do the following

1.First you need to Uploading the WSDL into the Integration Repository

For this

Go to your Software Component Version and open the required Namespace. Create an External Definition:

In the external definition object, choose Category wsdl and click Import external definitions.

2.Now create MI.

In the message interface object, select the message types of the external definition

object by using the input help.

3.Creating a SOAP Receiver Channel

The obligatory parameters in the configuration are Target URL and SOAP action.

4.Finally Test the Scenario Using a SOAP Client.

These are the basic steps.Rest people have given you many links.

Get back if you have some doubts.

Thanks

[Former Member]

Hi

I have done IDoc to JDBC using a Purchase Order IDoc.Its done like a normal scenario.

1) Get the IDoc into the XI system by doing the ALE Configuration as you do in case of IDoc to File Scenario.

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/sapR3%28Idocs%29ToXI--Steps+Summarized&

2)Do not create Sender CC for IDoc and no Sender Agreement also.

3)For JDBC Adapter you need to deploy the particular driver, in order to enable XI talk to your DB

Also have a look at the following to install these driver in XI

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

For the real configurations

XML SQL Format and Native XML Format

FILE to JDBC Adapter using SAP XI 3.0

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

Configuring the Receiver JDBC Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

These are the basic required for any scenario with JDBC Adapter.

Be sure about the Receiver structure because JDBC Adpter requires a special structure as i have mentioned above.

4)Once the JDBC Reciever CC is done, finish the scenario like a normal one.

Rest if you have any scenario specific queries let me know..

Thanks.

[nikhil_bose]

hi selva,

1) How to read from CSV (Comma Separated Value File) :: File Adapter

/people/sap.user72/blog/2005/01/06/how-to-process-csv-data-with-xi-file-adapter

2) How to integrate with WebService :: SOAP Adapter

/people/shabarish.vijayakumar/blog/2007/11/07/walkthrough--soap-xi-rfcbapi

3). jdbc adapter

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

4) idoc to jdbc

/people/swaroopa.vishwanath/blog/2007/01/22/ale-configuration-for-pushing-idocs-from-sap-to-xi

go through the scenario blogs and most welcome to ask further questions.

regards

nikhilbos

[Former Member]

Hi

<b>1. File to webservice scenario via xi</b>

/people/arpit.seth/blog/2005/06/27/rfc-scenario-using-bpm--starter-kit

refer that to design your interface. Note that instead of RFC you will require to use a WSDL for the WS call.

Fotr more about WSDL and its usage in a scenario ref:

/people/shabarish.vijayakumar/blog/2006/03/23/rfc--xi--webservice--a-complete-walkthrough-part-1

/people/shabarish.vijayakumar/blog/2006/03/28/rfc--xi--webservice--a-complete-walkthrough-part-2

For more :

/people/sap.user72/blog/2005/10/20/consumingcalling-webservices-from-databases

/people/siva.maranani/blog/2005/05/23/communication-between-sap-system-webservice-using-proxies

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/40728f7b-0401-0010-d9bc-8c7...

For Sync/Async Bridge

/people/sriram.vasudevan3/blog/2005/01/11/demonstrating-use-of-synchronous-asynchronous-bridge-to-integrate-synchronous-and-asynchronous-systems-using-ccbpm-in-sap-xi

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1403 [original link is broken] [original link is broken] [original link is broken]

you can do this without a BPM.

You can call a webservice from your UDF. please look into blog for more,

/people/bhavesh.kantilal/blog/2006/11/20/webservice-calls-from-a-user-defined-function

2.IDOC to JDBC scenario via xi

Have a look at these threads

/people/laxman.molugu/blog/2006/08/13/integration-with-databases-made-easy-150-part-1

/people/michal.krawczyk2/blog/2005/09/01/xi-idoc-adapter--edidc40--demystified

refer this:

/people/prateek.shah/blog/2005/06/08/introduction-to-idoc-xi-file-scenario-and-complete-walk-through-for-starters --> For Idoc sender: IDOC -file

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 --> for jdbc receiver: file -JDBC

Thanks!!!