how to create FTP datasource. I do not see it in the dropdown Type list

[nothingfree00]

I am trying to output the report export to FTP server. i want to create a FTP datasource so that user can select FTP datasource to export the report in Excel.

I could not find any FTP related drivers to create FTP source  OR  Ways to save FTP connection details without entering  each time a schedule created.

 

 

 

[anish.rai]

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.

[Jitendra Mandalia]

To clarify your question, I assume you want to use FTP/SFTP as an option to schedule a report and export that out in Excel format at a defined scheduled. Is that correct? Not sure what do you mean by datasource. As Datasource is defined for a database to connect to retrieve the data and run a report, whether it's at defined schedule or on demand basis. Datasource is not used for export location.

[Jitendra Mandalia]

To export out a report to FTP/SFTP server, you need to schedule a report to run at desired schedule and choose the "Output Destination" as FTP/SFTP server. There you will need to specify the SFTP/FTP server address and credentials for each schedule you define for any report. As of now there is no out of the box support to store a FTP/SFTP details and reuse the same for different schedule.

While the data source is used to connect to specific database using a database specific driver to pull the data for the reporting purpose. It's not related to export options.