Table of Contents

Search

  1. Preface
  2. Understanding Domains
  3. Managing Your Account
  4. Using Informatica Administrator
  5. Using the Domain View
  6. Domain Management
  7. Nodes
  8. High Availability
  9. Connections
  10. Connection Properties
  11. Schedules
  12. Domain Object Export and Import
  13. License Management
  14. Monitoring
  15. Log Management
  16. Domain Reports
  17. Node Diagnostics
  18. Understanding Globalization
  19. Managing Distribution Packages
  20. Appendix A: Code Pages
  21. Appendix B: Custom Roles
  22. Appendix C: Informatica Platform Connectivity
  23. Appendix D: Configure the Web Browser

Administrator Guide

Administrator Guide

PowerCenter Connectivity

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 figure contains a PowerCenter client, a repository database, and a domain with two nodes. The Integration Service is on Node 1 and the Repository Service is on Node 2.
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

0 COMMENTS

We’d like to hear from you!