By default the selected connection type is displayed as the Informatica PowerCenter.
If required, the drop-down list allows the user to change the connector type and based on the selection of the connection type, the fields associated with the selected connection type are displayed.
| | |Credential Manager
The purpose of a credential manager is to enhance the security that stores the API keys, passwords, certificates, and other sensitive data securely and helps to manage access, rotates, and audit secrets.
OE Credential Manager: Informatica PowerCenter connection is configured with the basic Username and Password of the service account in real-time when OvalEdge establishes a connection to the Informatica PowerCenter database. Users must manually add the credentials if the OE Credential Manager option is selected.
HashiCorp: The credentials are stored in the HashiCorp database server and fetched from HashiCorp to OvalEdge.
AWS Secrets Manager: The credentials are stored in the AWS Secrets Manager database server and fetched from the AWS Secrets Manager to OvalEdge.
Azure Key Vault:
Azure Key Vault allows for secure storage and strict access mechanisms of sensitive information such as tokens, passwords, certificates, API keys, and other confidential data.
For more information on Azure Key Vault, refer to Azure Key Vault
For more information on Credential Manager, refer to Credential Manager
| | | License Add-Ons |All the connectors will have a Base Connector License by default that allows you to crawl and profile to obtain the metadata and statistical information from a datasource.
OvalEdge supports various License Add-Ons based on the connector’s functionality requirements.
Select a connection name for Informatica PowerCenter. You can specify a connection name to identify the Informatica PowerCenter connection in OvalEdge.
Example: Informatica PowerCenter\_test
| | | Connector Environment |The environment dropdown menu allows you to select the environment configured for the connector from the dropdown list. For example, PROD, or STG (based on the configured items in the OvalEdge configuration for the connector.environment).
The purpose of the environment field is to help you identify which connector is connecting what type of system environment (Production, STG, or QA).
Note: The steps to set up environment variables are explained in the prerequisite section.
| | | Informatica Database |Informatica has four databases to store metadata. They are DB2, PostgreSQL, Oracle, and SQL Server. Select the database from the drop-down list. Based on the database selection, the user needs to provide the respective details.
However, the SQL server will authenticate the connection based on either SQL server authentication or Windows Authentication.
| | | Server\* | This is the Hostname or IP address of the Informatica PowerCenter. | | | Port\* | Enter the port number to connect to the database | | | Database\* | Provide the name of the database, sid, or service name that is associated with the Informatica PowerCenter connection. | | | Repository Schema | The Repository schema contains all metadata related to a mapping, source, or target stored. Enter the name of the repository schema. This is to be filled in mostly in the case of Oracle) | | | Driver\* | Driver is defaulted based on the Informatica database selected from the drop-down list. By Default is “com.microsoft.sqlserver.jdbc.SQLServerDriver” | | | Username\* |Username required to connect to the Informatica PowerCenter Repository Database. Enter the Service Account Name established to access the Informatica PowerCenter Repository.
Note: Sometimes, this field is autofill filled by the web browser with the current OvalEdge user login. Please enter the Informatica PowerCenter Service Account name.
| | | Password\* | Password for Informatica PowerCenter Repository User account | | | Connection String |Set the Connection string toggle button to automatic to get the details automatically from the credentials provided. Alternatively, you can manually enter the string.
If the connection string is set to:
It is important to provide the correct path to the parameter file that is used in the mapping. This is because the parameter file contains information that is necessary for the lineage to correctly identify the source and target objects used in the mapping.
| | | Default Governance Roles\* |Users can select a specific user or a team from the governance roles (Steward, Custodian, Owner) that get assigned for managing the data asset.
Note: The drop-down list displays all the configurable roles (single user or a team) as per the configurations made in the OvalEdge Security | Governance Roles section.
| | Admin Roles\* |Select the required admin roles for this connector.
To add Security and Governance Admin roles, search for or select one or more roles from the list, and then click on the Apply button.
The security and Governance Admin is responsible for:
A solution is required to circumnavigate the customer firewall when OvalEdge is deployed as a SaaS application. That solution is OvalEdge Bridge. A bridge is a type of firewall that operates at the network layer.
For more information, refer to Bridge Overview
| | {% hint style="info" %} Notes: \* (asterisk) indicates the mandatory field required to establish a connection. Once all the parameters are entered, the user can validate the details and save the connection that will get displayed on the Connector Home page.\ It is up to the user's wish, you can save the connection details first, or you can validate the connection first and then save it. {% endhint %} 1. Click on the Validate button to validate the connection details. 2. Click on the Save button to save the connection. Alternatively, the user can also directly click on the Save & Configure button that displays the Connection Settings pop-up window to configure the settings for the selected Connector. The Save & Configure button is displayed only for the Connectors for which the settings configuration is required. ### Connection Validation Errors | Error Messages | Description | | ------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------- | | Failed to establish a connection, Please check the credentials(User name, Password, Server name, etc.,) | In case of an invalid user name, wrong password, invalid Server name | {% hint style="info" %} Note: If you have any issues creating a connection, please contact your assigned OvalEdge Customer Success Management (CSM) team. {% endhint %} ## Connection Settings #### Lineage For the Informatica PowerCenter Connector, only the Lineage setting option is available, and it is enabled when the Auto Lineage License option is selected. The purpose of the lineage setting is to serve the option of changing the server/source connection to build the lineage. You can configure multiple servers simultaneously in the Selecting Source Server Type for lineage and also set the connection priority lists to pick the tables in the Connections Priority to pick the source table for lineage building. #### The Crawling of Schema(s) You can use the Crawl/Profile option, which allows you to select the specific schemas for the following operations: crawl, profile, crawl & profile, or profile unprofiled. For any scheduled crawlers and profilers, the defined run date and time are displayed to set. 1. Navigate to the Connectors page, and click on the Crawl/Profile option. 2. Select the required Schema(s). 3. Click on the Run button that gathers all metadata from the connected source into the OvalEdge Data Catalog. ## Additional Information ### SQL Server Database Authentications OvalEdge connector integrates with authentication mechanisms for crawling databases and schemas from an Informatica PowerCenter. The users must enter the source credentials and database information for each type of connectivity. When a user selects a SQL Server database it requires the following types of authentication. 1. SQL Server Authentication 2. Windows Authentication #### SQL Server Authentication Enter the following details to establish an Informatica PowerCenter connection using SQL server authentication.
Username required to connect to the Informatica PowerCenter Repository Database. Enter the Service Account Name established to access the Informatica PowerCenter Repository.
Note: Sometimes, this field is autofill filled by the web browser with the current OvalEdge user login. Please enter the Informatica PowerCenter Service Account name
| | Password\* | Password for Informatica PowerCenter Server account | | Connection String |Set the Connection string toggle button to automatic to get the details automatically from the credentials provided. Alternatively, you can manually enter the string.
If the connection string is set to:
It is important to provide the correct path to the parameter file that is used in the mapping. This is because the parameter file contains information that is necessary for the lineage to correctly identify the source and target objects used in the mapping.
| #### Windows Authentication Enter the following details to establish an Informatica PowerCenter connection using Windows Authentication.
Set the Connection string toggle button to automatic to get the details automatically from the credentials provided. Alternatively, you can manually enter the string.
If the connection string is set to:
It is important to provide the correct path to the parameter file that is used in the mapping. This is because the parameter file contains information that is necessary for the lineage to correctly identify the source and target objects used in the mapping.
| *** Copyright © 2025, OvalEdge LLC, Peachtree Corners GA USA