7 Replies Latest reply: Jan 23, 2010 10:40 AM by 538200 RSS

    Integration with Hyperion 11 and Oracle EBS - R12.

    538200
      Hi Guy's,

      Can any one tell me how to integrate Hyperion - 11 and Oracle E-Business Suite - R12.
      I have got a blog but it's not ever usefull.

      http://www.appsinsight.net/2008/03/31/oracle-enhances-integration-across-oracle-bi-hyperion-essbase/

      Please help.

      Thanks
      Bachan.
        • 1. Re: Integration with Hyperion 11 and Oracle EBS - R12.
          Sandeep Reddy
          HI,

          1. That blog refers to OBIEE i.e Oracle Business intelligence. It talks of its integration with EBS and essbase .

          2. But, I understand your requirement as integration between essbase and EBS.

          3. Essbase , it has EIS or essbase studio ,which are capable of pulling data from relation database . If you know the tables and fields of EBS system , you could achive that .

          4. If you are looking for something simpler and mroe integrated with the help of adapters. I am aware that FDQM has a Oracle e-Business suite adapter ( which would be your source adapter ) to pull data from EBS and FDQM has target adapter for essabse ,with the help it can push data into essbase.

          5. I think John can add his view point from ODI, which I am not sure of .

          Sandeep Reddy Enti
          HCC
          http://hyperionconsultancy.com/
          • 2. Re: Integration with Hyperion 11 and Oracle EBS - R12.
            Sandeep Reddy
            HI,

            1. That blog refers to OBIEE i.e Oracle Business intelligence. It talks of its integration with EBS and essbase .

            2. But, I understand your requirement as integration between essbase and EBS.

            3. Essbase , it has EIS or essbase studio ,which are capable of pulling data from relation database . If you know the tables and fields of EBS system , you could achive that .

            4. If you are looking for something simpler and mroe integrated with the help of adapters. I am aware that FDQM has a Oracle e-Business suite adapter ( which would be your source adapter ) to pull data from EBS and FDQM has target adapter for essabse ,with the help it can push data into essbase.

            5. I think John can add his view point from ODI, which I am not sure of .

            Sandeep Reddy Enti
            HCC
            http://hyperionconsultancy.com/
            • 3. Re: Integration with Hyperion 11 and Oracle EBS - R12.
              JohnGoodwin
              There are adaptors available for ODI that integrate with ebusiness suite, all depends what you want to achieve whether to use ODI. You will definitely need an understanding of the structure of the relational tables within the ebs warehouse.
              The other route is using the ERP integrator with FDM, more information available at :- http://download.oracle.com/docs/cd/E12825_01/epm.111/erpi_admin/frameset.htm?launch.html

              Cheers

              John
              http://john-goodwin.blogspot.com/
              • 4. Re: Integration with Hyperion 11 and Oracle EBS - R12.
                Sandeep Reddy
                Hi,

                1. Adding to what John has said, To use ERP integrator, you need ODI , which is not the same case with other adaptor FDQM e -Business suite adapter.

                2. I am sure with ERP integrator would integrate with EBS better than FDQM e Business suite adapter ( as the latter has capability to pull data only from GL_BALANCES AND GL_CODE_COMBINATIONS).

                Sandeep Reddy Enti
                HCC
                http://hyperionconsultancy.com/
                • 5. Re: Integration with Hyperion 11 and Oracle EBS - R12.
                  JohnGoodwin
                  Also the old e-business adaptor is no longer available as it has been replaced by the ERP integrator.

                  FDM Readme :-
                  Note: The adapter for Oracle E-Business Suite is no longer included in the FDM adapter suite. Use the ERP Integration adapter to integrate FDM with Oracle E-Business Suite Financials.+

                  Cheers

                  John
                  http://john-goodwin.blogspot.com/
                  • 6. Re: Integration with Hyperion 11 and Oracle EBS - R12.
                    538200
                    Hi Sandeep,

                    Thanks for the descriptive details, can i have the link to download ODI and steps to integrate EBS with Hyperion.

                    Desperately waiting for your reply.
                    Thanks a tone in advance
                    • 7. Re: Integration with Hyperion 11 and Oracle EBS - R12.
                      JohnGoodwin
                      I have given you the link Re: How to Integrate Hyperion with EBS-R12
                      You will need to read the documentation to find out how to integrate with ebs, if you have never used ODI before then you will have quite a bit of learning to do first.

                      Cheers

                      John
                      http://john-goodwin.blogspot.com/