AccessDatabaseTable to SAPB1(UDT) through SAPB1IF

[Former Member]

Hello Experts,

My external System is AccessDatabase,I need pick up data from Access Database table and port to the SAPB1 UserDefined Table Through SAPB1 Integration Framework..Any one can give me suggestions to do this.

1.SLD Connections

2.Inbound and Outbound Connections

3.Processing Steps

Help would be greatly appreciated..

Thanks,

Vijay Kumar

[Former Member]

Hi Vijay,

Does the problem solved already?

Cheers,

Qiaoli

[Former Member]

Hi Vijay,

If my understanding is correct, you are going to retrieve data from one table in one DB and insert the data to another table/DB right? .. then it should be like this -

First need to configure SLD connection. Choose system type [J.Anysystem] and JDBC connection information. Sample and screenshot:

• Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
• url: jdbc:sqlserver://[Servername];integratedSecurity=false;databaseName=[DatabaseName]

If you want to connect to two DB, then create two SLD.

Second, the inbound and outbound of the scenario step can be set to avoid because the msg is not retrieved from external system. When you set inbound to avoid, you should also set the timer, means how often the step will be triggered to run.

Third, the scenario step should look like as below.

The first atom is to call sql from DB a to get the data you want to insert into the DB b; in the outbound of the first sql call you will have the returned result data, then use the xform atom to do some transform; afterwards you can use the returned value to update DB b.

Hope it helps a bit.

Regards,

Qiaoli