Jump to content
We've recently updated our Privacy Statement, available here ×
  • Exporting a report on an SFTP server using a scheduler


    Prasad B
    • Features: Scheduler Product: JasperReports® Server

    Users are facing an issue while exporting a report on an SFTP server with a private key.

     

    The following are the steps to creating a private key:

    1) Start the PuTTY Key Generator program.
    2) Select the key type to generate as RSA because open SSH keys are not supported by Jaspersoft due to Jsch Library.
    3) Click on Generate. Please refer (PuTTY_key_generation.jpg) for more details.
    4) Click on "Save Public Key."
    5) For the private key, define a passphrase for it, then save your private key.

    Upload an RSA key file to the repository:
    1. You have to upload this RSA key file to the Jaspersoft repository to create a schedule.
    2. The steps to upload this RSA key file to the repository are as follows:
        i.Log into JasperReports Server as an administrator.
        ii. Click View > Repository and expand the folder tree.
        iii.Browse to the folder where you want to save the RSA key.
        iv.Right-click the folder and select Add Resource > File > Secure File from the context menu.
        v.Click Choose File to locate and upload the RSA key file.
        vi.Enter a name and resource ID for the file.
        vii.Click Submit to save the file to the repository.

    As keys are uploaded to the repository, we now have to create a schedule.

    Steps to create a schedule:
    1. Go to the JasperReports server repository.
    2. Right-click on any report and select the "Create Schedule" option.
    3. Select the Output Options Tab. In this tab, define the required file name, description, time zone, and required format.
    4. Now, define output destination options:
        i. Select Output to FTP Server and select Transfer Protocol as SFTP. Please refer(Create_Schedule_using_SFTP.jpg) for more detais
        ii. Define a server's internal IP address.
        iii. Define the directory path where you want to export the file.
        iv. Define an RSA private key for authentication, which we have already stored in the repository.
        v. Write Username and Password.
        vi. Click on "Test Connection,"
        vii. Once connection has been tested successfully, click on save to create a schedule successfully.

     


    User Feedback

    Recommended Comments

    There are no comments to display.



    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...