cancel
Showing results for 
Search instead for 
Did you mean: 

web service to update ms access database

Former Member
0 Kudos

Dear All

I need to know if there is a webservice that can be used for the purpose of updating a MS ACCESS database table with data from sap tables.

Pointers to this issue is highly appreciated.

Regards

Sudheendra

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hello Sudheendra,

you might want to read a blog of mine, called <a href="/people/anton.wenzelhuemer/blog/2006/03/27/accessing-arbitrary-databases-from-within-abap-using-a-php-data-hub-and-web-services arbitrary databases from within ABAP using a PHP data hub and web services</a>, and especially take note of the reference to the ADOdb libraries for PHP. The example shown together with the library provides you with a complete abstraction layer which would definitely allow to solve your problem in a very smart and sustainable way. The only downside being the involvement of an additional programming stack, PHP (which is of very small footprint though).

regards, anton

Answers (2)

Answers (2)

Former Member
0 Kudos

Hay Sudheenda,

I geuss you could always use SAP XI/PI and turn the webservice into a JDBC call to update the access database (I never tried that with ACCESS but it worked on ORACLE, DB2 and SQL server).

Greets,

Uri Lifshitz.

nilayghosh
Active Participant
0 Kudos