Skip to Content

DB Connect across SAP systems

We normally use RFC connections to fetch data between SAP systems. Can we do a DB connect to achieve similar results? This question is also from a performance perspective.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jun 29, 2017 at 05:10 PM

    RFC is pretty efficient, I'm with Matthew on this and would look at improving the overall process or application logic instead. Do you need every call? How about shared memory buffering?

    In my experience there are usually a LOT of things that can be tuned that have a greater impact than the RFC overhead. The same performance principles apply to RFCs as with SELECT statements.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 29, 2017 at 05:08 AM

    Yes. I don't see why querying a database would be worse than calling a program in another system which queries the same database (not talking about the case the network is different between systems).

    Please search DBCON in the forum, there are tons of answers.

    Add comment
    10|10000 characters needed characters exceeded

    • The reason why you should be careful is that it bypasses all security checks, which means that a user may well have different access when getting data in system X from system Y, and when logging into system Y.

      Direct access to the database from outside has historically been discouraged for this reason (and probably some others - I seem to recall it possibly affecting database stats and therefore performance).

  • Jun 29, 2017 at 05:36 PM
    Add comment
    10|10000 characters needed characters exceeded