Skip to Content

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

Transition from Informatica ETL to SAP HANA system

Hi,

My company is looking to replace the exisitng DW solution with SAP HANA to resolve the performance issue related to overnight batch loading ( as of today it takes around 8 hrs to load close to a billion de-normalized data into Oracle tables) and the issue that Business user facing to retrieve data into Excel pivots and Bo reports for decision making. Can some one please help me understand the following?  We are currently using Informatica as ETL tool ( we have some complex ETL logics in our Informatica jobs) and BO as the reporting tool. Oracle is the database that we use for reporting. So my questions are

1) We currently use Informatica as the ETL tool to extract the data from our Oracle based source system and load the data into Oracle based data warehouse. So If we replace ORACLE DB with SAP HANA aas our DW database can we still use Informatica as th ETL tool or should we use SAP Data Services as the ETL tool?

2) What is the differenece between SAP data Service and SAP BO Data Integrator?

3) If I have to make the transition from Informatica to SAP HANA, what areas should I focus and what is the learning curve involved in the process. I do not want to be only doing the ETL part but my end goal is to be a SAP HANA solution architect. My core skill is ETL so obviously I want to start from there and make a progression towards all other SAP HANA architecture.

I just wanted to know how SAP HANA can connect all these pieces together  ( will it make Informatica obsolete in near future ) and how I can make the transition to the ever growing community of SAP HANA developers and contribute to this community with my real time learning experiences.

Thanks

Shanil.

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