4 Replies Latest reply: Sep 18, 2013 10:50 PM by 1012870 RSS

    ERP INTEGRATOR and FDM

    1012870

      Hi All

       

      We have new  requirement our Source is PeopleSoft from that we want to load data to essbase and planning  using ERP Integrator

       

      Previously we use to get text files from Peoplesoft and we use to load it FDM  to Planing & Essbase

       

      What are prerequisites  to connect to Peoplesoft -> ERP Integrator -> FDM 

       

      Do we require ODI to connect to Peoplesoft ?

       

      Can anyone explain  me the flow

       

       

      Thanks,

        • 1. Re: ERP INTEGRATOR and FDM
          TomBlakeley

          Hello,

           

          There are several integration points involved.

           

          One is connecting ERPi & FDM through the use of the appropriate adapter, and additional metadata information.

           

          Second is connecting ERPi to the underlying source - in this case through PeopleSoft & ODI. There are a variety of configuration steps involved here as well.

           

          I would start with the ERPi documentation at oracle.com, and Oracle Support - there are a series of presentations available that walk through the process steps.

           

          Sneak Edit for 11.1.1.3: Configuring ERP Integrator 11.1.1.3</title><meta name="Title" content="Configuring ERP Integrato…

           

          What version are you on?

           

          As always - forum is here to help.

           

           

          Thanks,

          Tom

          • 2. Re: ERP INTEGRATOR and FDM
            1012870

            Hi Tom

             

            We are using

            1. Hyperion 11.1.2.2  Essbase ,Planning and FDM

            2.ODI 11g

            3.Now we want to Connect to Peoplesoft using ODI -> ERPi -> FDM ->Essbase and Planning

             

            One is connecting ERPi & FDM through the use of the appropriate adapter, and additional metadata information.

            If possible can u explain the above clearly



            Thanks

            • 3. Re: ERP INTEGRATOR and FDM
              Francisco Amores

              You need to:

               

              1. Configure ODI topology with Peoplesoft Credentials

              2. Register your Peplesoft instance as source system

              3. Register your target applicaitons

              4. Configure ERPI (locations...data load rule)

              5. Configure ERPI as source adapter of FDM

              6. trigger your data load rule from FDM

               

              ODI is a component of ERPI and will be executing scenario to extract data from PSFT.

               

              I suggest you have a look to all Peoplesoft topics of ERPI admin guide. Important one is about preparing the integration

               

              HTH

              • 4. Re: ERP INTEGRATOR and FDM
                1012870

                1. Configure ODI topology with Peoplesoft Credentials - (is it mandatory  or we can use File(.txt data file) here instead of giving Peoplesoft credentials )

                2. Register your Peoplesoft instance as source system - ( we want to give file (.txt ) here )

                3. Register your target applications

                4. Configure ERPI (locations...data load rule)

                5. Configure ERPI as source adapter of FDM

                6. trigger your data load rule from FDM

                 

                Thanks,