Skip to Content
author's profile photo Former Member
Former Member

Sap XI reading external databases (DB/2 on PC)

My company looking at Sap XI, to replace interfaces written by Sap Business Connector (BC). Currently BC connects to remote PC database (Db2) are reads the table via odbc connections and passes the data thru BC into Sap Function Module (RFC) as input parameters.

Questions

1. Can Sap XI connect to remote database (PC) directly or do you need to convert the data into XML format ?

2 In Business Connector a remote PC Appl can trigger a process on BC to run via Http statement, I.e., http://abcbuscon01:5555/invoke/ABCXXX.Process/SAP_ABC_Interface

Can you do this in Sap XI ? If so, what does the command in the remote system look like to tirgger a process on XI to run.

Thanks for any assistance...

Bill Sharp

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 01, 2003 at 06:41 PM

    Hi Bill,

    1. XI can connect to external databases via the JDBC adapter. To use the JDBC adapter you need to install a JDBC driver for the database you are using. These drivers are vendor-specific. In your case you would have to find a vendor who makes a JDBC driver for DB2, or perhaps an JDBC-ODBC bridge.

    The message format internal to XI will be in XML, but the JDBC adapter will nicely generate SQL statements to go communicate with your DB.

    2. This can be achieved with the plain HTTP adapter, which is built into XI. You can find all the information in the online help at

    help.sap.com / SAP NetWeaver/ SAP XI / SAP XI2.0 SR1 / Runtime / adapters / plain HTTP adapter.

    Hope this helps,

    Cheers,

    Jerome

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.