Using the FTP Distribution Option
This section provides information about distributing scheduled output using File Transfer Protocol (FTP). FTP distribution options can be accessed by clicking the FTP Server button in the Options group on the ribbon. The FTP Distribution Options dialog box is shown in the following image.
- You must be authorized to distribute by FTP in order to create a schedule that uses FTP distribution.
- Credentials for FTP servers are stored on a user level when a schedule is created in the same way that Reporting Server credentials are stored. The user needs to enter credentials only once for each FTP server. Those credentials will be available in the Basic Scheduling tool each subsequent time that the user creates a new schedule that utilizes that FTP server for distribution.
If the FTP Server requires SFTP, select the This server requires a secure SSH File Transfer Protocol (SFTP) check box. Select one of the following options to specify an authentication method:
- Select Password if the server requires authentication with a user ID and password.
- Select Public Key to authenticate against the server using Public Key Authentication.
- Select Public Key and Password (Multi-factor) to authenticate using Public Key Authentication and indicate that the server requires authentication with a user ID and password.
- There is more than one format for the Public and Private key pair used for authentication to an SFTP Server. If the Public and Private key pair used by your SFTP server is in a format that is not recognized by the Distribution server, you can generate keys in the appropriate format with the sshkeygen utility on the Distribution server.
- The Private Key for the server using Public Key Authentication must be added to the sftp_private_key.txt file, which is located in the \cfg directory on the Distribution Server.
- If the FTP Server requires FTPS, select the This server requires a secure File Transfer Protocol over TLS/SSL (FTPS) check box. Options include:
- Security Mode. Options include Explicit and Implicit mode.
- Protocol. Options include Transport Layer Security (TLS) and Secure Socket Layer (SSL).
- Data Connection Security. Options include Clear security (neither Integrity nor Privacy) and Private security (Integrity and Privacy).
Styling options include:
- Accordion reports
- Table of Contents (TOC) reports
- Peer Graphics/Data Visualization graphical reporting
- Multi-drill reports
- HFREEZE options
Procedure: How to Use the FTP Distribution Option
Note: You can use parameters (amper variables) when specifying values in the FTP settings of a schedule. These parameters can be system variables, such as &YYMD, or any amper variable for which a value is returned by the Reporting Server when the scheduled procedure is executed. To use the dot file extension separator after a variable, terminate the variable with the '|' character (for example, &YYMD|.htm). Similarly, to use the ampersand character itself, follow the ampersand with the '|' character (for example, Smith&|Jones). If a value for a parameter specified in a schedule is not returned by the Reporting Server when the procedure executes, the schedule will fail with a "No report to distribute" error. If the scheduled task is burst, you can also use the '%BURST' symbol to include the burst value. If the multiple reports are distributed in one archive file, the burst value will not be substituted in the Zip filename.
- Right-click a report procedure (FEX), point to Schedule, and then click FTP.
The Basic Scheduling tool appears.
- Click the Properties tab.
- Enter a title in the Title box or leave the default. Optionally, enter a summary in the Summary box.
- Click the Distribution tab.
- From the Type drop-down menu, select the method in which you will provide the file names to distribute to the FTP server. The options are:
Distribution List. The report will be sent to all FTP addresses in the selected Distribution List.
- Distribution File. Type the full path and file name of the external distribution file you want to use for this schedule. ReportCaster cannot validate the file existence. The path and file must be accessible to the ReportCaster Distribution Server.
- Single File. Type the name and file extension of the file you will distribute. The value contained in the Save Report As field of the schedule will automatically populate the Name field. When you burst the scheduled report, ReportCaster automatically adds the burst value to the end of the file name for each burst file. Optionally, you can add the '%BURST' syntax to the beginning of the file name, add a directory to the beginning of the file name, or both at the same time.
- In order for the report to distribute correctly, you must add a file extension to the Name value. By default, the Single File Name value does not include a file extension. To add a file extension, you can select the Override the Format Specified in the Procedure check box and select a report format in the Task tab or type the file extension manually.
- ReportCaster does not validate the location of the file path or whether the specified file already exists.
- The maximum length of this field is 800 characters.
- Dynamic Distribution List. A Dynamic Distribution List enables you to return in memory either a list of burst values and destinations, or a list of only destinations from a data source (for example, a flat file, SQL database, FOCUS data source, or LDAP).
- In the Report Compression section, specify options by which to compress the report. Select Create an archive file (.zip), Create compressed file(s)(.zip), Create compressed file(s)(.gz), or accept the default, None.
- The default setting for Report Compression is derived from the configuration settings.
- Support of Unicode characters in a Zip file name and content within a Zip file on Windows 7 and Windows 2008 Server R2 requires the following hotfix from Microsoft: http://support.microsoft.com/kb/2704299/en-us
Without this hotfix, file names are corrupted after you decompress a .zip file in Windows 7 or in Windows Server 2008 R2.
- Select the Notification tab to specify whether to send an email notification of the schedule job status. If you select Always or On Error, you must specify the Reply Address, Subject, Brief Message To, and Full Message To.
- Select the Properties tab to specify the Title, Priority, whether to delete the schedule if it will not run again, and whether the schedule is enabled to run. For more information, see About Properties in the Basic Scheduling Tool.
- Select the Recurrence tab to specify how often to run the schedule. If you want the schedule to run on the current day, set the Start Date and Start Time to values later than the current time.
- Select the FTP Server and specify the FTP Server Name, Account Name, and Password for the FTP Server. Optionally, select the SFTP and FTPS preferences.
- Click the Save & Close button.