Prerequisites¶
Alation Cloud Service Applies to Alation Cloud Service instances of Alation
Customer Managed Applies to customer-managed instances of Alation
Before you install the PowerCenter OCF connector, ensure that you:
Enable Network Connectivity¶
Open outbound TCP port 1521 to Oracle and port 1433 to the SQL Server Database server.
Create a Service Account¶
Create a user for the Informatica PowerCenter repository, see Create the PowerCenter Repository User.
Permissions¶
Read access is required for the Informatica PowerCenter repository database configured (Oracle or SQL Server). Data is extracted from database using MX views and tables.
Required Information¶
Database Properties¶
To configure the Informatica PowerCenter the database properties of the associated data sources (Oracle or SQL Server) are required. To get the databse properties:
Login to Informatica Administrator.
Click Services and Nodes.
3. In the Domain Navigator pane Select the Domain and then select the Repository Service from where the data needs to be extracted. Goto Properties, then select Database properties. Capture the credentials.
Go to Properties > Database Properties.
Copy the Database Username and Database Password to your local machine.
See Database Properties for more information.
Cross-System Lineage¶
To extract the schema details for source and target data source from the repository database:
Go to Workflow Designer and select the repository.
In the Edit Tasks window, go to Mapping tab.
Click Sources folder in the left pane and select the Source.
In Properties section, provide the Owner Name and Source Table Name for the selected Source. For Snowflake and Redshift database, the owner name must be in the format:
database name.schema name(case-sensitive). Example:dev.publicClick Targets folder in the left pane and select the Target.
In Properties section, provide the Table Name Prefix for the selected Target.
Click Ok.
See Relational Sources and Relational Targets for more details.