Oracle to XI to R/3 : Does anybody implemented?

[Former Member]

Hi,

I have a scenario where Oracle system has to make a call itself to XI and get the data from R/3 system. Does anybody have implemented this kind of scenario?. The call should come through XI(webservice).

I appreciate any ideas.

Thanks,

Raj.

[MichalKrawczyk · Accepted solution]

Hi Raj,

in order to help you maybe you can be a little more clear:

oracle system = oracle database or oracle applications?

if you're using oracle db maybe you can try

to create a procedure which would create a file

wich query data which could be pooled by the xi

and then r3 and then back to oracle jdbc?

(with ms sql server it's possible I believe so it should

be with the oracle too)

Regards,

michal

[MichalKrawczyk · Accepted solution]

Hi,

on the other hand why can't you use standard

jdbc serder adapter which pools the records

from the oracle db ?

this is a well known standard maybe you can just use this approach?

Regards,

michal

[Former Member · Accepted solution]

Hi Michal,

Thanks for the help. I want to know both ways.

1. How can we do it in Oracle Applications. I guess one way is web service call by the oracle apps system, but

2. in this case how can we make it communicate through XI?.

3.If it is a web service, it communicate directly to R/3 system, Isnt it?, but we want to enable XI only as a middleware.

Thanks and I appreciate your input.

Raj.

[moorthy · Accepted solution]

Hi,

<i>

2. in this case how can we make it communicate through XI?.</i>

If it is a WebService, Technically you can configure SOAP Sender Adapter to get the data into XI and then proceed.

Just check this SAP Help-

http://help.sap.com/saphelp_nw2004s/helpdata/en/9f/fdca3f01f33e1ce10000000a114084/content.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/ebb4c490-0201-0010-86be-88d...

Thanks,

Moorthy

[MichalKrawczyk · Accepted solution]

Hi,

as Moorthy suggests you need to use sender soap adapter

but first you have to generate a WSLD file

from the XI (you can do it from the directory - menu)

which will be consumed by the calling application

(in your case oracle app)

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

[Former Member · Accepted solution]

Hi Michal and Moorthy,

Thanks for the help on this issue. We need to generate the WSDL from Directory because, we need to communicate through XI only??.

How do we generate WSDL from directory?. Do we need to import the RFC into Directory?.

Any example scenarios??.

Thanks,

Raj.

[MichalKrawczyk · Accepted solution]

hi,

>>>>We need to generate the WSDL from Directory because, we need to communicate through XI only??.

yes

>>>>How do we generate WSDL from directory?. Do we need to import the RFC into Directory?.

once you set your configuration

in ID (so your whole scenario)

you can generate WSDL from DIRECTORY (and only from there)

>>>>Do we need to import the RFC into Directory?.

no need it will be visible in ID through IR

(with the WSDL generation function from menu)

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

[MichalKrawczyk · Accepted solution]

for exmaple have a look at this:

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

Regards,

michal

[moorthy · Accepted solution]

Raj,

Example Scenario-

/people/riyaz.sayyad/blog/2006/05/07/consuming-xi-web-services-using-web-dynpro-150-part-i

/people/siva.maranani/blog/2005/09/03/invoke-webservices-using-sapxi

https://websmp107.sap-ag.de/~sapdownload/011000358700006944112005E/HowToDevlopWebserviceApp.pdf

Regards,

Moorthy

[Former Member · Accepted solution]

Thanks Moorthy, and Michal. what you guys are doing on sunday evening ...take some rest..nobody will come near to you on SDN.....Wish to see you on Top10 of all forums.

//Raj.

[MichalKrawczyk · Accepted solution]

it's Sunday already?

that means tomorrow is Monday and we can finally

go to work hehe )

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>