Adding an FTP Server

You can add an FTP server from the Administration page.

Note:

If the destination file name supplied to the BI Publisher scheduler contains non-ascii characters, BI Publisher will use UTF-8 encoding to specify the file name to the destination FTP server. Your FTP server must support UTF-8 encoding or the job delivery will fail with "Delivery Failed" error message.

To add an FTP server:

1. From the Administration page, under Delivery, click FTP to display the list of servers that have been added.
2. Click Add Server.
3. Enter the following fields for the FTP server:

   • Server Name — example: myFTPserver

   • Host — example: myhost.company.com

   • Port — the default for FTP is 21.

     The default for Secure FTP (SFTP), is 22.

     If you wish to use the defaults at run time, you can leave this field empty, BI Publisher automatically uses 21 for FTP and 22 for SFTP.

     However, if you wish to use the Test Connection option from the UI, you must supply the correct port number in this field 21 for FTP or 22 for SFTP.

   • Use Secure FTP — Select this box to enable Secure FTP (SFTP). Ensure to set the correct Port as described above.

   • Use Passive Mode — Passive mode is recommended when the FTP server is behind a firewall.

   • Host Key Fingerprint — Host key verification is a key security feature. If <hostKeyFingerprint> value is set, the value must match the fingerprint calculated from server's host key at runtime. If it does not match, an exception error is thrown. When you connect the first time, the Delivery Manager API allows you to retrieve the server key fingerprint.

   • Filter Command (optional) — You can use a custom filter to apply file conversion such as encryption. To specify a custom filter, pass the native Operating System command string with the two placeholders for the input and output filename, {infile} and {outfile}.

     For example, to set up PGP encryption of the file using a Filter Command, enter the following:

     gpg -e -r myKey -o {outfile} {infile}

     where

     myKey is the ID to gpg key (such as real name, email address, or fingerprint).

     Note:

     The Filter command field does not support quotes. Therefore you cannot use certain valid gpg formats that include spaces, for example: "myname <[e-mail]>"). You must specify the ID in a single string with no spaces.

   • Create files with Part extension when copy is in process — select this box if you want BI Publisher to create the file on the FTP sever with a .part extension while the file is transferring. The .part extension indicates that the file transfer is not complete. When the file transfer is complete, the file is renamed without the .part extension. If the file transfer does not complete, the file with the .part extension remains on the server.

4. Enter a username and Password for the server if required.
5. Enter Proxy Server information — Host, Port, Username, Password, Authentication type

The following figure shows a sample SFTP delivery server setup:

Description of the illustration GUID-92F99DB3-7BC4-4836-BE7F-97E4517A64CD-default.gif