- PowerCenter 10.4.0
- All Products
Relational connection to source, target, lookup, or stored procedure database.
When you configure a session, you cannot change the relational connection type.
FTP or SFTP connection to the FTP host.
When you configure a session, select an FTP connection type to access flat files or XML files through FTP. Specify the FTP connection when you configure source or target options. Select an FTP connection in the Value column.
Relational connection to the external loader for the target, such as IBM DB2 Autoloader or Teradata FastLoad.
When you configure a session, choose File as the writer type for the relational target instance. Select a Loader connection to load output files to teradata, Oracle, DB2, or Sybase IQ through an external loader. Select a loader connection in the Value column.
Database connection for message queues, such as WebSphere MQ or MSMQ.
Select a Queue connection type to access an MSMQ or WebSphere MQ source, or if you want to write messages to a WebSphere MQ message queue.
Select an MQ connection in the Value column. For static WebSphere MQ targets, set the connection type to FTP or Queue. For dynamic MQSeries targets, set the connection type to Queue.
Connection to source or target application, such as Netezza or SAP NetWeaver.
Select an Application connection type to access PowerExchange sources and targets and Teradata FastExport sources. You can also access transformations such as HTTP, Salesforce Lookup, and BAPI/RFC transformations.
Connection type not available in the Connection Browser.
When you configure a session, select None if the mapping contains a flat file or XML file source or target or an associated source for WebSphere MQ.