4.2 Connecting Jaspersoft Studio 5.6 to ZENworks Reporting

To connect Jaspersoft Studio 5.6 to ZENworks Reporting:

  1. Install the ZENworks Reporting certificate:

    1. Administrators provide the ZENworks Reporting certificate. To get the ZENworks Reporting certificate, see Section 4.2.1, Copying the ZENworks Reporting Certificate.

    2. Copy the ZENworks Reporting certificate (server.cert) on the device on which Jaspersoft Studio 5.6 is installed.

    3. Open the command prompt, then execute the following command:

      cd <studio install path>\js-studio-pro-5.6.0\features\jre.win32.win32.x86_64.feature_1.7.0.u25\jre\bin

      <studio install path> is the location where Jaspersoft Studio 5.6 is installed. For example, C:\Program Files\Jaspersoft

    4. Execute the following command:

      keytool -import -keystore <studio install path>\js-studio-pro-5.6.0\features\jre.win32.win32.x86_64.feature_1.7.0.u25\jre\lib\security\cacerts -file <certificate path>\<certificate name> -storepass changeit

      <studio install path> is the location where Jaspersoft Studio 5.6 is installed. For example, C:\Program Files\Jaspersoft

      <certificate path> is the location where the ZENworks Reporting certificate that is copied onto the device where Jaspersoft Studio 5.6 is installed. For example C:\Program Files\Certificate

      <certificate name> is the name of the ZENworks Reporting certificate. For example, zrs-appl.labs.blr.novell.com

  2. Start Jaspersoft Studio 5.6.

  3. In Jaspersoft Studio 5.6, choose Window > Show View, then click Other.

  4. In the Show View page, below the Jaspersoft Studio view, select Repository Explorer, then click OK.

  5. In the Repository view, right-click Servers, then click Create JasperReports Server Connection.

  6. In the Server profile wizard, specify the following:

    • Name: Name of the connection.

    • URL: The ZENworks Reporting URL (https://<hostname>:<port number>/jasperserver-pro/).

    • Organization: Name of the organization.

    • User: A valid ZENworks Reporting user name.

    • Password: The relevant password for the user name specified in the previous field.

  7. Click Test Connection. After a successful connection is established, the ZENworks Reporting content appears.

  8. Click Finish to save the connection.

    For more information about how to use Jaspersoft Studio 5.6, see Jaspersoft Studio 5.6.

4.2.1 Copying the ZENworks Reporting Certificate

To copy the ZENworks Reporting Certificate:

  • Windows:

  1. Log into ZENworks Reporting as an administrator.

  2. Go to %ZRS_HOME%\conf\security.

  3. Copy the server.cert file.

  • Linux:

  1. Log into ZENworks Reporting as a root user.

  2. Go to /opt/novell/zenworks-reporting/conf/security.

  3. Copy the server.cert file.