Real Time ETL with SAP Data Services

[Former Member]

Hi, i would like to know if there´s possible to implement real time ETL using just Data Services or if i need sybase or some other replication tool?.is there any diagram or design you can share? regards

[Former Member · Accepted solution]

Hi Gerardo,

You can use SLT replication for real time extraction and Web services as data source.

If your using BW on HANA then try ODP with SLT.

Mostly Data service used for batch process only.

Thanks,

Shakthi Raj Natarajan

[Former Member · Accepted solution]

Thank you.

lets say that i dont have BW.

my architecture is:

Sources               ETL               Repository               Result

DB2                    DS                    SQL                         Excels

SQL                    DS                    SQL                         OLAP´s

im trying to extract customer information (MDM), in real time basis from our core systems (DB2 & SQL).

i read a few articles on how Change Data Capture could do that, but not sure if i have to replicate, or if i can make continuos connections to our core systems

what do you think of that?

[Former Member · Accepted solution]

Hi,

Technically it is possible but need to consider the performance impact.

Try in Data services and Data Quality Scn Area where experts could help.  Where is this place located?

Thanks,

Shakthi Raj Natarajan

[former_member187605]

For sure that's possible in SAP Data Services. We've got real-time jobs thoroughly documented in the official documentation. But why don't you start your research from Realtime at a Glance - Enterprise Information Management - SCN Wiki?