Skip to Content
avatar image
Former Member

ODBC vs RFC connectivity - which is faster?


I have a SAP Application Datastore to which I connect to - one connection is using ODBC which connects to the underlying database and another connection is RFC connection where I am using ABAP Data Flows with RFC Data Transfer.

I have a dummy job that directly pulls data from the Open hub table and dumps it into a Template table. My ODBC job runs at twice the speed of my RFC job, but the BASIS team is adamant that RFC is faster than ODBC and want us to move to RFC (mainly due to security concerns). Could you guys throw light on the same? Am I doing the ABAP development wrong? Or like we believe, is ODBC connection faster than RFC connection with BODS 4.2?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 08, 2016 at 01:29 PM

    My experience too is that direct data-level access is always faster than going thru the ABAP layer. But your Basis team is right, you should not connect directly to the underlying database, unless in very exceptional cases, e.g. when dealing with Z-tables.

    Add comment
    10|10000 characters needed characters exceeded