Interface to share data related to CATS (Time Sheet)

[Former Member]

Hi All,

A VB allpication is maintained where employee Time Sheet is stored. This data is stored in SQL server.

The SAP ECC 6.0 is also present in the business environment.

Now the Timesheet data from SQL server has to be moved to SAP Database.

(The Table CATSDB has to be updated.)

I am looking for a Design how to cary out this exercise using XI as a middleware....?

I believe using flat files and BAPI, it can be easily done in ABAP environment.

But my Client wants to do it using XI.....

Can anyone has encountered this kind of requirement...????

Please guide me.....

Regards

Pavan

Message was edited by:

Pavan Sanganal

[Former Member]

Hi pavan,

there are two options...

1) if u can manage the timesheet data in a file... then u can go for File to RFC/File to Proxy

2) Use JDBC adapter to pull the data from Database ..ie.. u can go for JDBC to RFC/JDBC to Proxy.

Another option may be.... (i am not sure)

if u can create a WSDL for the VB application...(it should contain the time sheet data u need top post)...then u can go for SOAP to RFC/SOAP to Proxy.

regards

BILL

[Former Member]

Hi,

Easiest way is to get the data from the SQL server using the JDBC adapter and send into ECC 6.0 using an ABAP proxy. Or get a flat file of the data and use the File/FTP adapter to process it into XI instead of the JDBC adapter.

The inbound ABAP proxy would call the relevant BAPI to populate the data correctly in ECC.

Cheers

Colin.