Blog Network Home > Informatica Way > Configuring Informatica File Transfer Protocol

Configuring Informatica File Transfer Protocol

by Gowri Shankar K on March 15, 2011 in Informatica Way

Informatica File Transfer Protocol can be used to transfer/move files from different environment into our pre-defined Landing Zone. It can also be used to transfer file to the destination folder/directories.   The Integration Service can use FTP to access any machine it can connect to, including mainframes.

Configuring FTP in Informatica Workflow

To use FTP file sources and targets in a session,

  • Create an FTP connection object in the Workflow Manager and configure the connection attributes
  • Configure the session to use the FTP connection object in the session properties.
  • Specify the Remote filename in the connection value of the Session properties.

Guidelines

  • Specify the source or target output directory in the session properties. If not specified, the Integration Service stage the file in the directory where the Integration Service runs on UNIX or in the Windows System directory.

  • Session cannot run concurrently if the same FTP source file or target file located on a mainframe.

  • If a workflow containing a session that stages an FTP source or target from a mainframe is aborted, then the same workflow cannot be run until it’s timed out.

  • Configure an FTP connection to use SSH File Transfer Protocol (SFTP) while connecting to an SFTP server. SFTP enables file transfer over a secure data stream. The Integration Service creates an SSH2 transport layer that enables a secure connection and access to the files on an SFTP server.

  • To run a session using an FTP connection for an SFTP server that requires public key authentication, the public key and private key files must be accessible on nodes where the session will run.

Configuring Remote Filename

Attribute Description
Remote Filename The remote file name for the source or target.  Indirect source file name to be entered, in case of indirect source file is sent.

Use 7-bit ASCII characters for the file name. The session fails if it encounters a remote file name with Unicode characters.

If the path name is provided with the source file name, the Integration Service ignores the path entered in the Default Remote Directory field. The session will fail if the File name with path is provided with single or double quotation marks.

Is Staged Stages the source or target file on the Integration Service. Default is “Not staged”.
Is Transfer Mode ASCII Changes the transfer mode.

When enabled, the Integration Service uses ASCII transfer mode.

-           Use ASCII mode when transferring files on Windows machines to ensure that the end of line character is translated properly in text files. When disabled, the Integration Service uses Binary Transfer mode.

-          Use Binary Transfer mode when transferring files on UNIX machines. Default is disabled.

You might want to read these awesome related posts


{ 1 comment }

1 venkatesh May 26, 2011 at 11:01 am

Specify the Remote filename in the connection value of the Session properties.

Can u elaborate more on this point. I need to know where to specify in the session properties and what the remote filename would be like…

Comments on this entry are closed.