BODS vs SLT

[Former Member]

Hi Friends,

i have a question.

which one is the best option to suggest a client BODS or SLT and why?and the client has no budget issues.

what could be the best reasons/factors to provide so that they can think and take a decision.

[former_member182967]

Hello Pradeep,

Maybe the following pictures can provide the information to you.

Data Services is an ETL tool that can connect to multiple types of data containing systems (more or less any DB; ABAP Dictionary; Hadoop; ...). It can read from and write into these systems, facilitating any type of ETL process between more or less any combination of source and target. It also allows defining complex transformation rules in between, has scheduling capabilities and what have you. In most cases, you don't have any special functionality to generate delta information between two loads from the same source (exceptions apply, e.g. using BW Extractors as sources in DS). That's why DS is mostly operated in batch mode.

SLT on the other hand installs a functionality to get a generic delta on any table - by means of table triggers. This enables the tool to pull data from the source system with latency of the order of magnitude of one second ("real time"), no batch processing needed here, rather a continuous stream of data from source to target. The primary use case is to replicate from AS ABAP-based systems into SAP HANA, but by now you can also read from non-ABAP sources. Transformation capabilities exist, but are largely limited to DS.

Thanks & Best Regards,

Tong Ning

[Former Member]

Thanks for the info Tong Ning. It helped in providing the info. 🙂

[abhishek_singh11]

Hi Pradeep,

Please go through a blog written by John, which answers all your questions.

https://blogs.saphana.com/2013/04/07/best-practices-for-sap-hana-data-loads/

Thanks Much,

Abhishek

[Former Member]

That was a great piece of info Abhishek. Thank you very much friend.

Regards,

Pradeep