Configuring SFTP Connections in PowerCenter®

Back Next

Configuring Source File Properties

If you access source files with SFTP, configure the source file properties after you choose the SFTP connection for the source instance. The source file properties determine the source file type and the staging location. You can configure source file properties in the Properties settings on the Mapping tab.

If you want to stage the source file, select the source file name, directory, and file type.

If you do not want to stage the source file, specify the source file type. The PowerCenter Integration Service uses the remote file name and directory from the FTP connection object and ignores the source file name and directory.

In the Workflow Manager, open the Task Developer and click

Tasks

Create

Select Session for the task type.

Enter a name for the session task. Do not use the period character (.) in task names. Workflow Manager does not allow a task name with the period character.

Click

Create

The Task Developer creates the session task.

In the

Mappings

dialog box, select the mapping you want to use in the Session task and click

Click

Done

Open the session properties by double-clicking the icon in the workspace.

The

Edit Tasks

dialog box appears.

Configure the following source file properties in the Properties settings of the Sources node on the

Mapping

tab:

Attribute	Description
Source File Type	Indicates whether the source file contains the source data or a list of files with the same file properties. Choose Direct if the source file contains the source data. Choose Indirect if the source file contains a list of files.
Source File Directory	Name and path of the local source file directory used to stage the source data. By default, the PowerCenter Integration Service uses the service process variable directory, $PMSourceFileDir, for file sources. The PowerCenter Integration Service concatenates this field with the Source file name field when it runs the session. If you do not stage the source file, the PowerCenter Integration Service uses the file name and directory from the FTP connection object configured for SFTP. The PowerCenter Integration Service ignores this field if you enter a fully qualified file name in the Source file name field.
Source File Name	Name of the local source file used to stage the source data. You can enter the file name or the file name and path. If you enter a fully qualified file name, the PowerCenter Integration Service ignores the Source file directory field. If you do not stage the source file, the PowerCenter Integration Service uses the remote file name and default directory from the FTP connection object configured for SFTP.