Connecting 3rd party database & SAP system thru XI

[Former Member]

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

[former_member189324]

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

[Former Member]

Hi Prasad,

I am trying to import RFC from an SAP R/3 4.6C system.

but its throwing an error has shown below.

ERROR MESSAGE:

Unable to establish connection to R/3 system GEM (Client = 200)

Tips

1. Is the target system online?

2. Check the connection data ( note that server names & groups are case sensitive)

Tips for admins:

3. Does the user have the required authorization in the target system?

4. Is the target system configured correctly in ?etc/Services??

Connection data we entered:

System: GEM

Message Server: abcdef

Group: PUBLIC

Client: 200

I am sure that answer for 1,2, & 3 is yes. Admins told me that 4th one is also taken care off.

What might be the mistake I am making ?

thanks

Mathew

[former_member189324]

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