Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ODBC vs RFC connectivity - which is faster?

Hi,

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?

Tags:
Former Member
replied

Isn't it obvious that an application going straight to the data (ODBC) will outperform one that has to pass through an additional application layer (RFC)?

Have a look at Best way to read data from SAP ECC for the different options for getting data out of ECC.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question