Setup takes about 15 minutes.

Introduction

Connecting Informatica PowerCenter to Foundational allows Foundational to determine lineage and downstream impact for Informatica ETL pipelines.

Informatica PowerCenter is a widely used, enterprise data integration platform and a robust ETL (Extract, Transform, Load) tool. It is primarily used to connect to various data sources, apply transformation logic according to business requirements, and load the processed data into target systems like data warehouses for analytics and reporting.

To make the connection, you need to:

Configure network access
Create a user in PowerCenter
Connect Foundational to Informatica PowerCenter
(Optional) Get database details from Informatica

Prerequisites

Ensure you have:

Informatica PowerCenter admin rights to create a service account in the underlying database (SQL Server or Oracle)
Added Foundational IP addresses to the allowlist, see the article Allowing IP access to Foundational

(Optional): Access to the underlying repository database (Oracle or SQL Server)

Access permissions

Foundational works with metadata only and does not access your data or run ETL jobs. The permissions you assign to Foundational enable it to:

Read Informatica metadata stored in the PowerCenter repository
Read mappings, workflows, and sessions
Understand dependencies between sources and targets, and track lineage and downstream impact across ETL pipelines.

Configure network access

Open inbound ports for Informatica PowerCenter Service Manager. For more information, see the Informatica documentation:

TCP port 6006 (Inbound)
TCP ports 6014–6114 (Inbound)

Optional settings if you want Foundational to have database access

Open inbound ports for Informatica’s underlying physical database:
- For Oracle: Open TCP port 1521 (inbound)
- For SQL Server: Open TCP port 1433 (inbound)

Create a user in PowerCenter

Follow the steps in the Informatica PowerCenter documentation to create a new user for Foundational. This allows Foundational to access your PowerCenter information.
Save these credentials. You’ll need them to set up the connection.

Optional: Get database details from Informatica

Informatica stores metadata in an underlying database (for example, Oracle or SQL Server). If you want Foundational to have access to the database, choose one of the following options:

Option 1: Use the existing repository database user

Log in to Informatica Administrator > Services and Nodes.
Select Domain > Repository Service.
Go to Properties > Database Properties.
Save these details. You’ll need them to set up the connection.
- Type
- Connection String
- User Name
- Password

For reference, see the I nformatica documentation on repository database properties.

Option 2: Create a new repository database user

Create a new user in the underlying repository database (Oracle or SQL Server).
Grant the user SELECT permissions on all tables under:
- OPB_
- REP_
Save these details. You’ll need them to set up the connection.
- Type
- Connection String
- User Name
- Password

Connect Foundational to Informatica PowerCenter

In Foundational, open the Connectors & Integrations page.
In ETL, select the Informatica PowerCenter card and click Connect.
Click Add Account.
The initial setup screen opens. Click Start Setup.
The Set Up New Connection screen opens.

Enter the details:
- PowerCenter Service Manager URL: The URL you use to access
  PowerCenter services in a browser.
- PowerCenter User: The username of the PowerCenter user for Foundational.
- PowerCenter Password: The password for the PowerCenter user.
Optional settings:
- Informatica Database URL: Get this from Repository Service → Database Properties in Informatica. Use the Connection String value as the Informatica Database URL.
- Informatica Database User: The name of the user.
- Informatica Database Password: The password for the database user that has SELECT access to the repository tables (OPB_, REP_).
Click Next.
The final setup screen opens. To complete the connection, click Save.