Data Profiling Connectivity
Power Center Data Profiling uses the following types of connectivity:
TCP/IP. The PowerCenter Client and the Integration Service use native protocol to communicate with the Repository Service.
Native. The Integration Service uses native database connectivity to connect to the Data Profiling warehouse when it loads target data from the profiling sessions.
ODBC. The PowerCenter Client uses ODBC to connect to the Data Profiling warehouse when you run data profiling reports from the Profile Manager.
JDBC. Data Analyzer uses JDBC to connect to the Data Profiling warehouse when you run data profiling reports.