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

Connecting 3rd party database & SAP system thru XI

Posted on Dec 05, 2003 at 07:45 PM 18 Views

Hi Friends,

     I am working on a Scenario in XI very similar to Described in Master guide (1.3.5) & (1.3.2).( Data from a legacy system needs to be read at regular intervals & made available to another system(SAP) in the form of an XML Message.)

To be exact the  scenario is like SQLSERVERDB<==>XI2.0<==>SAPR/3 4.6C

My Questions are,

1. Can I define in "SLD", the Legacy System Database (Non SAP system) from which data is read( Similar to how we define sAP systems in SLD) ?

2. Basically, I will be querying the database Using the JDBC Adapter. Since I am specifying the query during configuration of the adapter,I am not able to visualize the reason for specifying an Interface for the Legacy system in Integration repository. Assuming, still if I have to define an interface at DB side.

What will be the input & Output message type?

Does all these things will be taken care by JDBC adapter, while I configure the adapter?

Do I just have to define an interface & link that to the adapter?

3. If I need an Outbond & Inbound JDBC adapter. Do I have to run two instances of the adapter & configure one has Inbound and other has outbond?

4. In the XI Documentation it says JDBC adapter comes with XI2.0. I know I need to install &Â Â configure it. But is the adapter Free of cost?

5. Please refer me some websites/Links from where I can get information on how to Handle this type of Scenarios.

thanking you in anticipation

bye

Mathew

SAP Process Integration
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Prasad Illapani
    Prasad Illapani
    Posted on Dec 05, 2003 at 07:45 PM

    Hi Mathew,

    Below are the answers:

    1. Yes u have to create a Non SAP Business System(3rd Party System) in SLD for your Legacy System.

    2. U can choose any interface name u want to. Just use the same name in the Int. Repository and in the JDBC inbound Adapter configuration properties file.

    3. Yes u have to define 2 instances, one for Inbound and Outbound.

    4. The  Adapter Engine which inculdes JDBC Adpater is part of XI-2.0 licensing. U have to install it either locally on XI box or any other sytem and configure it.

    5. Check the SAP Help Portal: http://help.sap.com for more info. It has examples but may not have all the business scenarios.

    Thanks

    Regards

    Prasad

    Add comment
    10|10000 characters needed characters exceeded

    • Prasad Illapani Former Member
      Dec 11, 2003 at 07:14 PM

      Hi Mathew,

      Tips:

      1.Group: SPACE (Some times, the users are created under this Group). Check with ur System Admin for this value.

      2. Also add the GEM System IP Address in ur host file under the Dir:C:WINDOWSsystem32driversetc from where ur accessing.

      3. Make sure the message server value is correct.

      thanks

      Regards

      Prasad