Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Session Properties Reference
  17. Workflow Properties Reference

Connection Types

Connection Types

When you create a connection object, choose the connection type in the Connection Browser. Some connection types also have connection subtypes. For example, a relational connection type has subtypes such as Oracle and Microsoft SQL Server. Define the values for the connection based on the connection type and subtype.
When you configure a session, you can choose the connection type and select a connection to use. You can also override the connection attributes for the session or create a connection. Set the connection type on the mapping tab for each object.
The following table describes the connection types that you can create or choose when you configure a session:
Connection Types
Connection Types
Description
Relational
Relational connection to source, target, lookup, or stored procedure database.
When you configure a session, you cannot change the relational connection type.
FTP
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.
Loader
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.
Queue
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.
Application
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.
None
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.
For information about connections to PowerExchange see
PowerExchange Interfaces for PowerCenter
.