Publishing a data adapter from TIBCO Jaspersoft® Studio into TIBCO JasperReports® Server

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

  1. Create a data adapter in TIBCO Jaspersoft® Studio.

  2. Create a report using this data adapter.

  3. Test the report in the Jaspersoft® Studio to make sure it works.

  4. Export the data adapter from Jaspersoft® Studio. 

  5. Deploy this data adapter into TIBCO JasperReports® Server repository as XML file. (Right click on the folder in JasperReports® Server,  Select "Add Resource", "File". "XML File", "Choose File", 

  6. In Jaspersoft® Studio, add the following property to the report template:
    <property name="net.sf.jasperreports.data.adapter" value="repo:{path to the data adapter done in step 5}"/>
    To get the "repo:... value, Go to the "Properties" of the XML file you added in JasperReports® Server. Review data source properties to determine the repository path to the data adapter:
    Use that information to set "repo:..." value.
    This property should replace the existing dataadapter property (com.jaspersoft.studio.data.defaultdataadapter).

  7. Test the modified report in the Studio to make sure it works.

  8. Publish the modified Jaspersoft® Studio report into JasperReports® Server repository without a data source.

  9. Test the report in JasperReports® Server.

(Note, this is an update to WIKI article https://community.jaspersoft.com/wiki/how-deploy-and-use-data-adapter-jasperreports-server-v56, tested on Jaspersoft® Studio 7.5 and JasperReports® Server 7.5. )

Comments

Is there a way to encrypt the password?

Feedback
randomness