Categories
OBIEE to OAS Migration and Informatica (APP) ETL Impact
Hello Folks.
A customer is migrating from OBIEE to OAS and need to know how it impact your currently ETL Informatica. Are there additional task to do? Any consideration about ETL Informatica support and OAS?
Thanks in advance
Answers
-
OAS doesn't have any support for Informatica, just like OBIEE doesn't have any support for Informatica : both OAS and OBIEE don't interact at all with Informatica.
OAS and OBIEE do use data stored somewhere, how the data get there (Informatica as ETL) isn't something OBIEE or OAS do care about.
0 -
Hello Gianni. Thanks for your answer.
In this link https://docs.oracle.com/cd/E14847_01/bia.796/e14843/anyinstadmoverview.htm#i1018278 appear an integration between Informatica PowerCenter and OBBIE. It is still valid and/or is valid on OAS too?
0 -
There is no interaction. OBI did and OAS / OAC do read from data sources. Doesn't matter what they are, doesn't matter what ETL/ELT tool is used. Informatica was - with regards to your link about 14 years ago - just an ETL tool that filled the DWH. That's it.
OAS / OAC would also have zero "dependency" on Talend writing into a DB2. Or a PL/SQL statement writing into MS SQL. Or a text file being loaded into a cube via command line.
Data storage is data storage. The analytical engine is the analytical engine.
0 -
That link is not about OBIEE, it's about OBIA. And you asked in the OBIEE category about OBIEE.
Are you saying that you are asking about OBIA instead?
0 -
