Query regarding XI interaction with database

[Former Member]

Hi all,

I have got the Oracle database and SAP R/3 system

Is it possible that through JDBC adapter ,

a) Direct fetching of data from database

b) Data should come in XI and after mapping should be

posted in SAP R/3 .i.e complete automated process

c) Is it possible to put direct query statement in XI

while connection with database through JDBC adapter

E.g For fetching the vendor data from database

Select * from ....

Thanks in advance

Shikha Jain

[Former Member · Accepted solution]

Hi Jain ,

The JDBC sender adapter will allow you to specify the SQL statement & also specify a Poll" interval which you can specify based on the frequency with which ur table ll be updated and thats it , since its a pull from XI , no manual intervention is needed

Regds

Saravana

[Former Member]

Hi all

Thanks for your help

Could someone suggest appropiate weblogs / online documents regarding the same

[Former Member]

Shikha,

<i>a) Direct fetching of data from database</i>

In the JDBC Sender adapter you have to mention the SQL Query.

<i>b) Data should come in XI and after mapping should be

posted in SAP R/3 .i.e complete automated process</i>

This is what XI does. There is no manual intervention needed.

<i>c) Is it possible to put direct query statement in XI

while connection with database through JDBC adapter

E.g For fetching the vendor data from database

Select * from ....</i>

your question a is same. You can execute a SQL statement in the Adapter which polls the database in the intervals you mention. It could be a SELECT or EXEC PROC etc.

regards

Shravan