Forum Stats

  • 3,783,607 Users
  • 2,254,809 Discussions
  • 7,880,481 Comments

Discussions

Can we use ODI with Informatica for Planning and Essbase

User_HUBCP
User_HUBCP Member Posts: 186 Blue Ribbon
edited Dec 14, 2011 10:56PM in EPM System Infrastructure
If we have Informatica datawarehouse, can I use ODI to integrate with Essbase and Planning ? Or do we need to buy informatica adapters for essbase/planning ?

Best Answer

Answers

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    Are you licensed to use ODI with Essbase and Planning, if you are and the datawarehouse is accessible by jdbc/odbc then yes you would be able to use ODI.
    Saying that there are some DIM adaptors available which run on informatica - http://download.oracle.com/docs/cd/E17236_01/nav/portal_6.htm

    Cheers

    John
    http://john-goodwin.blogspot.com/
    JohnGoodwin
  • User_HUBCP
    User_HUBCP Member Posts: 186 Blue Ribbon
    Thank you John, for your response. We are accessing our options as to which way to go. We dont have licenses for ODI for Essbase or Planning. We have informatica expertise we would like to use them. The confusion is should we buy the adapters for informatica or licenses for ODI. I understand having ODI with Informatica would add an additional integration layer.
  • I may be mistaken, but I think you have a "limited" ODI use when you purchase Planning. This is primarily to load metadata and data into your Planning app as the target.
  • 808829
    808829 Member Posts: 14
    Accepted Answer
    Gerd,

    you are not mistaken, Planning 11.x is bundled with Essbase and ODI for the limited use with planning.

    John Conlee
    [email protected]
This discussion has been closed.