Hello Friends,
We have been using ODI since +4 years for data integration for our EPM projects. Happy so far with E2E automated setup that we have built.
Now, we are asked by our management to see if we can use Informatica (Our Enterprise ETL) instead of ODI. We know INF connectors will always lag behind EPM in terms of versions and Oracle recommendation is to use ODI. We are thinking to use INF to able to provide AGG tables to be loaded into Essbase/Planning using load rules and extract using report scripts/data export.
Like you help with suggestions.,
1. Are we heading in right direction? compared with technology trend ETL for EPM
2. Though we know its going to work having INF produce final output data for load rules to load data into Essbase/planning., what i'm afraid is features that we get from ODI as default need to be built in other solution. Like (exception handling, Metadata build Essbase/planning properties, notifications--etc)
Please provide your suggestions on your experience of migrating to ODI from other mechanism Or switching out of ODI to adopt other ways to load metadata & data loads into EPM
Thanks.