Data Integration Process using SAP Data Services (BODS)

[former_member5846]

Hi Experts,

How can we perform data integration in SAP environment ?

Source System : SAP HANA DataBase

Target System : MS SQL Server

ETL tool: SAP Data Services (BODS)

[werner_daehn · Accepted solution]

Two datastores, one for Hana, one for SQL Server and a job, workflow, dataflow reading a table from Hana and loading a SQL Server table?

[former_member5846 · Accepted solution]

Thanks a Lot.

[former_member5846 · Accepted solution]

So basically we do not need to use IDOC / RFC to send data into SQL system from SAP DS staging area ? Right ?

[werner_daehn]

That's a question of the desired qualities. From a technical point of view your understanding is correct.

In 95% of the cases reading the SAP tables is fine.

In 4% of the cases you want to utilize SAP function modules to do some transformations for you. Function Modules are invoked from remote via RFCs/BAPIs.

In 1% of the cases you want to have a low latency of the data. Meaning the instant the data gets changed in the SAP system, an IDOC shall be generated, it is received by Data Services and DS loads the contents into the target SQL Server. If IDOCs would be used in SAP everywhere and for everything, then you would go down that route more often but since they have quite a performance penalty, they are not that commonly used.

I have collected the pros/cons a few years back:

https://wiki.scn.sap.com/wiki/display/EIM/Overview+SAP+Interfaces

[former_member5846]

Thanks a lot for your explanation. 🙂