Skip to Content
0
Apr 25, 2014 at 07:08 PM

Need technical details on how 3rd Party ETL will load data into S&OP HANA

47 Views

Can any of you help me to get clarity on how 3rd party ETL tools works.


We use informatica as ETL tool. We understand that 3rd party ETL can't access HANA staging tables and have to use files to load the data.

Form documentation it is not clear on following aspects on 3rd Party ETL

1) What is destination for flat files generated by ETL for HANA to load?

2) What is the file size? any limitations?

3) What is the format for master data and KF for ETL tool? Can we use same format that UI generates for manual loads?

4) How is ETL get "Handshake" from HANA and feedback on loads and error messages.

For example, we have created master data (GEO) and KF(BOOKNGREF) in our

planning area. Attached files generated from UI templates and loaded

using manual loads. We are not clear how to generate and load these files by

ETL while loading, where to place and how ETL will get confirmations and

error messages.


Thanks,

Krishna


Attachments