Workflow Basics Guide

10.5.6
- 10.5
- 10.4.0

Back Next

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
.

Rename Saved Search

Table of Contents

Workflow Basics Guide

Workflow Basics Guide

Connection Types

Connection Types