DataFlux Data Management Studio 2.5: User Guide

Email and FTP Node

You can add an Email and FTP Node node to a data job to add a step to e-mail and FTP files that sends the output from a DataFlux Data Management Studio job to one or more recipients.

Note: You must first download the freeware NcFTP Client (NcFTPGet and NcFTPPut) from NcFTP Software (http://www.ncftp.com/download/) to use this node. Once the NcFTP Client has been downloaded and installed, you must add the following keys to the app.cfg file.

FTPGETCMD="C:\Program Files\NcFTP\ncftpget.exe" -d %L -u %U -p %P %S %T %F
FTPPUTCMD="C:\Program Files\NcFTP\ncftpput.exe" -d %L -u %U -p %P %S %T %F

Next, you must add the following to your app.cfg file (located in the etc folder of your installation, C:\Program Files (x86)\DataFlux\DataFlux Data Management Studio\[instance_name]\etc) for the Email command:

EMAILCMD=cscript -nologo "C:\Program Files (x86)\DataFlux\DataFlux Data Management Studio\[instance name]\bin\mail.vbs" -s servername %T < "%B"

where servername is the name of your mail server.

Add the Email and FTP node to a separate page of your data job. This node should be the only node on the page and does not include parent or child nodes.

Once you have added the node, you can double-click it to open its properties dialog. The properties dialog includes the following elements:

Name - Specifies a name for the node.

Notes - Enables you to open the Notes dialog. You use the dialog to enter optional details or any other relevant information for the input.

The Commands section of the dialog includes the following elements:

Commands table - Displays the commands that control e-mail and FTP processing. The table includes fields for Type, Arguments, Ignore Errors, and Skip.

Add - Enables you to select, configure, and add an e-mail or FTP command to the Commands table. The following commands are available:

• Add send Email command - Enables you to add a command to send e-mail. Includes standard e-mail and attachment fields.
• Add FTP Get command - Enables you to add an FTP Get command. Includes standard FTP server, user and password, and file download fields.
• Add FTP Put command - Enables you to add an FTP Put command. Includes standard FTP server, user and password, and file upload fields.
• Add custom command - Enables you to create a custom command with appropriate arguments.

Note that the server name that you specify in the send email command or the FTP command cannot require authentication.

Edit - Enables you to modify a selected command.

You can access the following advanced property by right-clicking the Email and FTP node:

• Commands