1 Reply Latest reply on Aug 9, 2021 1:20 AM by Jagadish Mohan Gaglani

    How to bring in source/target files used in Informatica powercenter

    Resmi Rajendra Active Member

      Hi All,

       

      I have scanned Informatica powercenter repository using native resource type 'Powercenter' and similarly we have oracle database objects scanned using native resource. But the powercenter mapping uses files for

      source and target. What is the process to bring in these information into EDC?

       

      1. should I use resource type 'File System' to scan the aix box where powercenter is configured?

      2. Is there any connection assignment to be done after aix box scanning to link the files with powercenter mappings? something similar to database level connection assignment.

      3. The powercenter server (aix) is accessible only through a gateway server/jump host? Will that be supported in resource type 'File System'? How to configure that in EDC resource?

      4. what all permission required for edc user to scan the server?

       

      Thanks for your response.

        • 1. Re: How to bring in source/target files used in Informatica powercenter
          Jagadish Mohan Gaglani Guru

          Hey Rajendra,

           

          Please see my responses below.

           

          Can you please elaborate which Version of Informatica EDC are you using

           

          1. should I use resource type 'File System' to scan the aix box where powercenter is configured?  -

           

          for AIX we need to have appropriate connector available on your machine or you could explore Informatica Power Exchange - All Legacy Environment such as IBM Mainframe ,Midrange all need special connectors to establish connection - Also Is your AIX File stored on Linux or AIX On windows,

          You need to be specific with your Environment setup - in order for others to help you

           

          2. Is there any connection assignment to be done after aix box scanning to link the files with powercenter mappings? something similar to database level connection assignment.

          Yes you need to ensure that AIX Connectivity between your EDC and AIX is getting established or not

          3. The powercenter server (aix) is accessible only through a gateway server/jump host? Will that be supported in resource type 'File System'? How to configure that in EDC resource?

          Is your AIX a file based system - Meaning is it a Flat File or VSAM File or network based File

          4. what all permission required for edc user to scan the server?

           

          EDC user need to have read access at a minimum to be able to access the file . Depending on whether a read or Write Operation need to be performed. Please do a self-Evaluation too , - in order to come to a conclusion.

           

          Thanks,

          Jagadish