Integration with CABI JasperReports Server

After installing the JasperReports Server, you need to configure the integration between JasperReports Server and DX Spectrum Report Manager. To enable this integration, provide the Jasper Server connection details on the integration page.
casp1042
This section describes the steps to integrate
DX NetOps Spectrum
with CABI Jasper server.
After installing the JasperReports Server, you need to configure the integration between JasperReports Server and
DX NetOps Spectrum
Report Manager. To enable this integration, provide the Jasper Server connection details on the integration page.
If you are using a JasperReports server that comes with a CA product other than
DX NetOps Spectrum
, then do the following before the integration:
Copy the SpectrumProxy.war file from the location $SPECROOT\Spectrum\Install-Tools\SRM-Tools\jasper\ to Japserserver\tomcat\webapps folder. Restart the Jasper Tomcat Server.
Follow these steps:
  1. Open the OneClick Administration page.
  2. Click the Report Manager tab.
  3. Select the Jasper Integration option from the Report Manager Admin Tools.
  4. Download and install the '
    Integration Components
    '. For installation instructions, see the Installing Integration Components section.
    Information!
    The 'Integration Components' is a JAR file, which consists of the necessary binaries to integrate the JasperReports Server with
    DX NetOps Spectrum
    and run reports. Installing the 'Integration Components' will deploy the binaries on the Jasper Server and helps you to generate reports.
  5. Specify the parameters that are used to communicate with the JasperReports server:
    • Jasper Server Host name
    • Specify the host name of your CABI JasperReports Server instance if it is not the same server as
      DX NetOps Spectrum
      Tomcat.
    • Jasper Tomcat Port
      Specify the port where Jasper Tomcat is running. The default port value is 8080.
      The Tomcat port cannot be the same port that
      DX NetOps Spectrum
      Tomcat uses if Jasper and OneClick are on the same server.
    • JasperServer Webapp Name
      Specify the Jasper server webapp name that is given during the installation of Jasper server. Default is 'jasperserver-pro'.
    • Jasper Admin User
    • Specify the Jasper Admin User ID.
      The default User ID is 'superuser'.
    • Jasper Admin Password
      Enter the password for the Admin User ID in Jasper. The default password is 'superuser'.
    • Jasper Integration
      Select the Enable radio button.
      If Disable is selected and saved,
      DX NetOps Spectrum
      Tomcat no longer integrates with CABI Jasper instance.
    • Enable SSO
      Select this checkbox to enable single sign-on solution(SSO) from JasperReports Server, which establishes a session between the
      DX NetOps Spectrum
      Report Manager and Jasper console. If you enable the SSO, you can open Jasper console session from a OneClick web console without providing any login credentials.
    • Use SSL with Jasper Server
      Select this checkbox to integrate with Secure Sockets Layer (SSL) enabled JasperReports Server. To know more about Secure Sockets Layer (SSL) and how to enable it on JasperReports Server, see Using SSL in the Web Server. (Supported only when the JasperReports Server runs on Windows 2012).
      SSL and Single Sign-On can both be enabled with the JasperReports Server integration.
  6. Click Save to enable the integration and refresh the page.
  7. On the OneClick home page, click 'Jasper Console' to launch the JasperReports Server.
    This process can take some time. During this process, all the
    DX NetOps Spectrum
    Report Manager report content is exported from the OneClick server into CABI JasperReports Server. Therefore, do not cancel or navigate away from this page until you get a success message.
After you configure the integration, the
DX NetOps Spectrum
Report Manager report content is installed and can connect to the CABI JasperReports Server reporting database. The menubar 'JasperConsole' link now launches the CABI JasperReports Server web applications on the CABI instance that you specified.
If you disable the integration, reporting and report administration capabilities are disabled. However, disabling the integration does not cause
DX NetOps Spectrum
Report Manager to stop collecting and managing data from the monitored SpectroSERVERs.
After successful integration, you can see the following
DX NetOps Spectrum
organization and default users in Jasper:
  • jasperadmin/jasperadmin
    ROLE_ADMINISTRATOR
  • joeuser/joeuser
    ROLE_USER
  • spectrum/spectrum
    ROLE_ADMINISTRATOR
    ROLE_USER
Redeploy
Re-deploy the reports to repair the existing report or to update to a newer version. After upgrading to a new version of
DX NetOps Spectrum
, click the Re-deploy button to sync up the Jasper reports with
DX NetOps Spectrum
upgrade fixes, enhancements, and new reports.
Features not supported in this release
Limited set of reports and custom reporting capabilities are supported in this release.
Import MySQL 8 Connector to Jasper
From 10.4.2, you can import the MySQL 8 server connector which is used as to Jasper server to run the Jasper reports. The MySQL 8 connector is used as the reporting database server.
Follow these steps:
  1. Log in to Jasper Console using admin credentials or with superuser account in OneClick SRM server.
  2. Navigate to the Folder root, Public-, ca, Spectrum, datasources.
  3. Right-click
    spectrum_ds
    and select
    edit
    .
  4. Click on the Select Driver, Choose File.
  5. Select the
    mysql-connector-java.jar
    present in $SPECROOT/tomcat/lib in Spectrum installation
  6. Once the driver is imported, under the “JDBC Driver” select “MySQL (com.mysql.jdbc.Driver)” from the dropdown list.
  7. Enter
    reporting
    as the value in the
    Database (required)
    field.
  8. Enter
    jdbc:mysql://<SRM_Hostname>:3306/reporting?tinyInt1isBit=false
    , in the
    URL (required)
    field.
    Where SRM Hostname is the hostname of OneClick Server where the SRM server is installed and used for Jasper Integration.
  9. Click on Test Connection, to ensure that the connection is successful.
  10. Save the changes.
  11. Right-click
    spectrum_domain_ds
    and select
    edit
  12. Select
    MySQL (com.mysql.jdbc.Driver)
    in the
    JDBC Driver
    dropdown list.
  13. Enter
    srmdbapi
    , in the
    Database (required)
    field.
  14. Enter
    jdbc:mysql://<SRM Hostname>:3306/srmdbapi?tinyInt1isBit=false
    , in the
    URL (required)
    field.
    Where SRM Hostname is the hostname of OneClick Server where the SRM server is installed and used for Jasper Integration.
  15. Click on Test Connection, to ensure the connection is successful.
  16. Save the changes.