Informatica PowerCenter Repository

Parent Previous Next

Informatica PowerCenter Repository


Informatica System Requirements

  If connecting to a SQL Repository:

o   64-bit Operating Systems:

  Microsoft ® SQL Server ® 2012 Shared Management Objects x64

  Microsoft ® SQL Server ® 2012 Shared Management Objects x86

o   32-bit Operating Systems:

  Microsoft ® SQL Server ® 2012 Shared Management Objects x86

  If connecting to an Oracle Repository:

o   64-bit Operating Systems:

  64-bit Oracle Data Access Components (ODAC) 12c

  64-bit Oracle 12c Managed Data Access Client installed into the GAC

  32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio 12c

  32-bit Oracle 12c Managed Data Access Client installed into the GAC

o   32-bit Operating Systems:

  32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio 12c

  32-bit Oracle 12c Managed Data Access Client installed into the GAC


With the Informatica provider, users will be able to use DOC xPress to easily create metabase documentation from an Informatica PowerCenter.


Best Practices

BI Compare

Documentation

Lineage

Data Dictionary

a

b


a Best Practices rules can be analyzed for the Informatica PowerCenter Repository provider once the user has created User Defined Best Practices


b Data Dictionary categories can be applied to the Informatica PowerCenter Repository provider once custom paths have been created


Getting Started

1.   After creating a solution, click the "Add" button on the right side of the page


2.   Give the solution item a meaningful name


3.   Select the Informatica PowerCenter provider from the source type drop down



4.   Select the type of repository that will be documented, either SQL Server or Oracle and then provide a valid data source, credentials, and database



5.   You may also customize your documentation by adding filters


Important Note:

Excluding certain types may affect Lineage Analysis.



6.   Click "OK" to add the Informatica PowerCenter Repository to the Solution Items window