top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

FTP Connection Parametrization Technique

+2 votes
4,879 views

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 in 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

Configuring Remote Filename
enter image description here

Multiple Source files read using single FTP Server by parametrization technique
If we want to read multiple source files using single FTP server connection using Informatica parametrization technique as shown below.

Source File1
enter image description here

Source File2
enter image description here

Define variables in the Parameter file as below:
$FTPConnection_CMS=FTP_RTK123
$FTPConnection2_CMS=FTP_RTK123

$Param_FTPConnection_CMS_Remote_Filename=abc123d.2
$Param_FTPConnection2_CMS_Remote_Filename=abc123d.2

posted Apr 26, 2014 by Shatark Bajpai

  Promote This Article
Facebook Share Button Twitter Share Button LinkedIn Share Button
How can I stage the file(take backup) before its been ftped to remote server. I am actually parameterizing the ftp connection and the remote filename.
I dont see stage file option in session properties when I parameterize the ftp connection.
Please help me on this


Related Articles

Informatica parameter file is a text file which contains 1) Parameter values 2) Variable values for mapping, session and workflows

* Develop environment independent code.
* Control data processing without changing the code in PROD environment
* Easy deployment to production server
* Provide Flexibility to run sessions for different files and databases
READ MORE
...