PowerCenter Connectivity
PowerCenter uses the TCP/IP network protocol, native database drivers, ODBC, and JDBC for communication between the following PowerCenter components:
- •PowerCenter Repository Service. The PowerCenter Repository Service uses native database drivers to communicate with the PowerCenter repository. The PowerCenter Repository Service uses TCP/IP to communicate with other PowerCenter components.
- •PowerCenter Integration Service. The PowerCenter Integration Service uses native database connectivity and ODBC to connect to source and target databases. The PowerCenter Integration Service uses TCP/IP to communicate with other PowerCenter components.
- • Metadata Manager Service. Metadata Manager use JDBC and ODBC to access data sources and repositories.
- •PowerCenter Client. PowerCenter Client uses ODBC to connect to source and target databases. PowerCenter Client uses TCP/IP to communicate with the PowerCenter Repository Service and PowerCenter Integration Service.
The following figure shows an overview of PowerCenter components and connectivity:
The following table lists the drivers used by PowerCenter components:
Component | Database | Driver |
|---|
PowerCenter Repository Service | PowerCenter Repository | Native |
PowerCenter Integration Service | Source Target Stored Procedure Lookup | Native ODBC |
Metadata Manager Service | Metadata Manager Repository | JDBC |
PowerCenter Client | PowerCenter Repository | Native |
PowerCenter Client | Source Target Stored Procedure Lookup | ODBC |
Custom Metadata Configurator (Metadata Manager client) | Metadata Manager Repository | JDBC |
Repository Service Connectivity
The PowerCenter Repository Service manages the metadata in the PowerCenter repository database. All applications that connect to the repository must connect to the PowerCenter Repository Service. The PowerCenter Repository Service uses native drivers to communicate with the repository database.
The following table describes the connectivity required to connect the Repository Service to the repository and source and target databases:
Repository Service Connection | Connectivity Requirement |
|---|
PowerCenter Client | TCP/IP |
PowerCenter Integration Service | TCP/IP |
PowerCenter Repository database | Native database drivers |
The PowerCenter Integration Service connects to the Repository Service to retrieve metadata when it runs workflows.
Connecting from PowerCenter Client
To connect to the PowerCenter Repository Service from PowerCenter Client, add a domain and repository in the PowerCenter Client tool. When you connect to the repository from a PowerCenter Client tool, the client tool sends a connection request to the Service Manager on the gateway node. The Service Manager returns the host name and port number of the node where the PowerCenter Repository Service runs. PowerCenter Client uses TCP/IP to connect to the PowerCenter Repository Service.
Connecting to Databases
To set up a connection from the PowerCenter Repository Service to the repository database, configure the database properties in Informatica Administrator. You must install and configure the native database drivers for the repository database on the machine where the PowerCenter Repository Service runs.
Integration Service Connectivity
The PowerCenter Integration Service connects to the repository to read repository objects. The PowerCenter Integration Service connects to the repository through the PowerCenter Repository Service. Use Informatica Administrator to configure an associated repository for the Integration Service.
The following table describes the connectivity required to connect the PowerCenter Integration Service to the platform components, source databases, and target databases:
PowerCenter Integration Service Connection | Connectivity Requirement |
|---|
PowerCenter Client | TCP/IP |
Other PowerCenter Integration Service Processes | TCP/IP |
Repository Service | TCP/IP |
Source and target databases | Native database drivers or ODBC |
The PowerCenter Integration Service includes ODBC libraries that you can use to connect to other ODBC sources. The Informatica installation includes ODBC drivers.
For flat file, XML, or COBOL sources, you can either access data with network connections, such as NFS, or transfer data to the PowerCenter Integration Service node through FTP software. For information about connectivity software for other ODBC sources, refer to your database documentation.
Connecting from the PowerCenter Client
The Workflow Manager communicates with a PowerCenter Integration Service process over a TCP/IP connection. The Workflow Manager communicates with the PowerCenter Integration Service process each time you start a workflow or display workflow details.
Connecting to the PowerCenter Repository Service
When you create a PowerCenter Integration Service, you specify the PowerCenter Repository Service to associate with the PowerCenter Integration Service. When the PowerCenter Integration Service runs a workflow, it uses TCP/IP to connect to the associated PowerCenter Repository Service and retrieve metadata.
Connecting to Databases
Use the Workflow Manager to create connections to databases. You can create connections using native database drivers or ODBC. If you use native drivers, specify the database user name, password, and native connection string for each connection. The PowerCenter Integration Service uses this information to connect to the database when it runs the session.
PowerCenter Client Connectivity
The PowerCenter Client uses ODBC drivers and native database client connectivity software to communicate with databases. It uses TCP/IP to communicate with the Integration Service and with the repository.
The following table describes the connectivity types required to connect the PowerCenter Client to the Integration Service, repository, and source and target databases:
PowerCenter Client Connection | Connectivity Requirement |
|---|
Integration Service | TCP/IP |
Repository Service | TCP/IP |
Databases | ODBC connection for each database |
Connecting to the Repository
You can connect to the repository using the PowerCenter Client tools. All PowerCenter Client tools use TCP/IP to connect to the repository through the Repository Service each time you access the repository to perform tasks such as connecting to the repository, creating repository objects, and running object queries.
Connecting to Databases
To connect to databases from the Designer, use the Windows ODBC Data Source Administrator to create a data source for each database you want to access. Select the data source names in the Designer when you perform the following tasks:
- •Import a table or a stored procedure definition from a database. Use the Source Analyzer or Target Designer to import the table from a database. Use the Transformation Developer, Mapplet Designer, or Mapping Designer to import a stored procedure or a table for a Lookup transformation.
To connect to the database, you must also provide your database user name, password, and table or stored procedure owner name.
- •Preview data. You can select the data source name when you preview data in the Source Analyzer or Target Designer. You must also provide your database user name, password, and table owner name.
Connecting to the Integration Service
The Workflow Manager and Workflow Monitor communicate directly with the Integration Service over TCP/IP each time you perform session and workflow-related tasks, such as running a workflow. When you log in to a repository through the Workflow Manager or Workflow Monitor, the client application lists the Integration Services that are configured for that repository in Informatica Administrator.
Metadata Manager Service Connectivity
To connect to a Metadata Manager repository, the Metadata Manager Service requires a JDBC driver. The Custom Metadata Configurator uses a JDBC driver to connect to the Metadata Manager repository.
JDBC drivers are installed with the Informatica services and the Informatica clients. You can use the installed JDBC drivers to connect to the Metadata Manager repository.
The Informatica installers do not install ODBC drivers or the JDBC-ODBC bridge for the Metadata Manager Service.
