Data Integration Connections

Data Integration Connections

Connection configuration

Connection configuration

When you configure a connection, the connection becomes available for use within the organization.
If you use sub-organizations and you want a connection to be available to multiple sub-organizations, create the connection in each sub-organization.
Configure connections on the
Connections
page. The
Connections
page lists all of the connections that have been configured in the organization. You can create a connection on this page. You can also search for an existing connection by name or description, by name only, or by description only.
The following image shows the
Connections
page:
The Connections page shows all of the connections that have been configured in the organization. The page shows the name, type, runtime environment, and service URL for each connection. To create a connection, click "New Connection" at the top of the page. You can use the search field above the connections list to search for a connection.
When you configure a connection, you specify the runtime environment for the connection. The runtime environment must contain an agent that is running. You can override the runtime environment in the connection from the mapping or mapping task.
The runtime environment manages the connection between
Informatica Intelligent Cloud Services
and the connection endpoint. It helps you perform the following tasks:
  • Test the connection to the endpoint.
  • Display objects available for the connection and retrieve metadata when you use the connection in an asset. You can preview data in the source, target, or lookup object selected in the asset.
  • Run assets that use the connection to read from a source, transform data, or write data to a target.
You can configure a connection to a database, cloud data warehouse, or other endpoint type. When you create a source or target connection to a database or cloud data warehouse, you connect to a table, alias, or view. For example, when you create a Snowflake Data Cloud connection, you connect to a Snowflake table or view. For more information about creating connections to different types of endpoints, see the help for the appropriate connector.
When you configure connections for sources and targets in a mapping or task, where the connections require you to specify the code page, ensure that the code pages are the same. If the source system and target system in a task use different code pages, the
Informatica Intelligent Cloud Services
might load unexpected data to the target.
You can delete any connection that you create as long as the connection is not used by a saved query or task.

0 COMMENTS

We’d like to hear from you!