Report Bursting using Jaspersoft ETL

Issue Description:

You can first try the following method that you might find on the internet for report bursting using Jaspersoft ETL with JasperReports Server.

• http://www.talendforge.org/exchange/tos/extension_view.php?eid=253&rid=380
• tJasperserverExec

This method uses the tJasperServerExec component which is a component contributed from the community. In general, community contributed components are not supported officially by Jaspersoft Technical Support. However, there is another method that is fully supported. It uses the tHttpRequest component that is included with Jaspersoft ETL out of the box.

Attached is an example that you can use to get started.

See attached screenshots showing the three components involved in the example.

1. prod family - it retrieves a column of values from the sample foodmart database using the query of,

   select distinct product_family from product_class

   The product families are Drink, Food and Non-Consumable.

2. tFlowToIterate_1 - It iterates all the values in the column

3. tHttpRequest - It issues the http REST_V2 request to the repository to run each report and generate pdf output to be saved in a directory on the local file system

   URI

   "http://localhost:8080/jasperserver-pro/rest_v2/reports/public/Samples/Reports/08.UnitSalesDetailReport.pdf?ProductFamily=" + ((String)globalMap.get("row1.product_family"))+ "&j_username=superuser&j_password=superuser"

Write Response content to file:

"C:/temp2/" + ((String)globalMap.get("row1.product_family")) + ".pdf"

You should end up with 3 pdf files in C:/temp2 for this example. See reports attached.

Please note:  j_username and j_password are included in the URI. Normally, you should be able to just check "Need Authentication" in order for the authentication to work. Depending on your implementation, including them in the URI may be the most suitable method that works for most environments.

This sample requires installation of the sample database foodmart on a system.  You can change the ip address, port number, user name and password so that it will work with your installation.  Or, you can simply use a column of values from your own database by modifying the sample accordingly.

Addendum: As of Release 8.1, Jaspersoft Studio and JasperReports Server support report bursting,  See this WIKI article:: https://community.jaspersoft.com/wiki/report-bursting-using-jaspersoft-studio-81

Resolution:

tHttpRequest method is included in Jaspersoft ETL out of the box. This component is fully supported by Jaspersoft.

Ref. Case #00043492

burstingexample2.zip

drink.pdf

food.pdf

non-consumable.pdf