Skip to Content
avatar image
Former Member

Query regarding XI interaction with database

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 05, 2005 at 01:03 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 05, 2005 at 12:27 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 05, 2005 at 02:07 PM

    Hi all

    Thanks for your help

    Could someone suggest appropiate weblogs / online documents regarding the same

    Add comment
    10|10000 characters needed characters exceeded