You can create a connection for connectors that are installed in Informatica Intelligent Cloud Services. You can create a connection on the Connections page in Administrator or when you create a source, target, or lookup object in a mapping or task in Data Integration.
Note: If your organization is configured to retrieve sensitive connection credentials from an external secrets manager, you need to create and edit connections in Administrator. You can't create and edit connections when you configure mappings and tasks in Data Integration.
When you configure a connection, you specify properties for the connection. Connection properties enable an agent to connect to data sources.
1Configure the following connection details:
Property
Description
Connection Name
Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -
Maximum length is 100 characters. Connection names are not case sensitive.
Description
Description of the connection.
Maximum length is 255 characters.
Type
Type of connection, such as Salesforce or Oracle.
2If you use an external secrets manager, select Use Secret Vault, select the checkbox next to each property that you store in the secrets manager, and enter the secret name for each property.
Enter the secret name in the following format:
- AWS Secrets Manager: <secret name>:<secret key>
- Azure Key Vault: <secret name>
For example, you configure a relational connection and you store the database password in AWS Secrets Manager. The secret name is MySQLServerCredentials, and the secret key is MyPassword. Select Use Secret Vault, enable the checkbox next to the Password field, and enter MySQLServerCredentials:MyPassword in the Password field, as shown in the following image:
3Select the runtime environment to be used with the connection.
If you use an external secrets manager, the runtime environment you select must contain a local Secure Agent that runs the SecretManagerApp service. The Hosted Agent, serverless agents, and cloud-hosted agents can’t connect to an external secrets manager.
4Configure the connection-specific properties.
For example, if you configure a flat file connection, enter the directory where the files are stored, the date format for date fields in the files, and the code page of the system that hosts the files.