Third party app connection to sap db - proper way ?

[Former Member]

Hello,

What is the proper way to connect to SAP db for third party app ?

I see two alternatives:

a. db vendor provided db API - like ODBC driver and etc. (maybe sap provides it's own db specific drivers?)

b. sap RFC

Which method is recommended in read-only/read-write scenarios ?

thanks,

Vilius

[former_member182307 · Accepted solution]

Hello,

I'm assuming that what you call an SAP db is an database in which the SAP data is. Not the SAP DB database RDBMS.

If you intend to update some SAP data, you must use the applicative SAP layer.

Meaning , you must use the interfaces provided by SAP ( like standards API, BAPI etc ... ) and RFC.

You must not update the SAP database directly through custom code, using for example an ODBC connection and performing inserts in the db tables.

The SAP application layer is responsible for data integrity, therefore if you bypass it in some way, this data integrity is not insured anymore. This can lead to major problems.

The SAP data is spread across multiple tables and you' ll have an hard time trying to find out which set of table to update throughout the application in order to keep the data integrity by yourself.

It's the same for reading data from SAP. You must use the standard objects provided by SAP.

Best regrads,

Steve.

[former_member1283074]

HI

hope this link will help you

http://vldb99.scit.wlv.ac.uk/IndustrialSpeakerSlides/SAPVLDB.pdf

[Former Member]

This link not open...I want this link...how to I get?....