How to configure Jasper Studio for editing existing reports and creating new reports for CA Service Desk Manager data on Jasper Server.

Document ID : KB000010048
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

You can use Jasper Studio Professional to edit existing reports that are delivered with the CA Service Management content for CABI-Jasper, or to design new reports to view your CA Service Desk Manager data.  To edit or copy existing reports, and then publish them to Jasper Server for use, it will require you to configure Jasper Studio to connect to your Jasper Server instance where the CA Service Management content was imported.  To design/create new reports, it will also require you to create a Data Adapter in Jasper Studio to connect to the CA Service Desk Manager object layer.  This document will explain the steps to configure Jasper Studio properly, enabling you to edit existing reports, create new reports and publish reports to Jasper Server.

Environment:
CA Service Desk Manager 14.1.03 and upJasper Reports Server 6.2.0 and higher
Instructions:

First, you must download and install Jasper Studio Professional. This can be downloaded from Tibco's website which can be found here: https://www.jaspersoft.com/download-jaspersoft-bi-software

Next, follow these steps to connect your Jasper Studio installation to your Jasper Server Instance:

In Jasper Studio, right click on "Servers" and select "Create JasperReports Server Connection":

1.PNG

 

Then enter the information for your jasper server hostname, and the admin username and password for Jaspersoft (which by default is superuser/superuser), then click "Test Connection":

2.PNG

 

A successful connection will show as follows:

3.PNG

 

Now you will see your JasperReports Server connection in the Servers list in Jasper Studio.

Next, you need to create the data adapter to connect to the object layer of CA Service Desk Manager so you can create and run reports against Service Desk data.

First, you need to copy the custom driver (.jar file) from the Jasper Server install media, to the machine where you have Jasper Studio installed - follow these steps:

1. navigate to the directory where Jasper Server is installed, such as: C:\Program Files\TIBCO\Jaspersoft Studio Professional-6.3.0.final, and create a new folder called "ca_driver"

2. copy the oajc.jar file from the Jasper Server (NOT JASPER STUDIO!) install media, to the "ca_driver" folder that you created on the machine where Jasper Studio is installed.  The file is located in:

{JasperServer_Install_Media}\overlay\CA_SDM\webapps\WEB-INF\lib

Copy it to:

C:\Program Files\TIBCO\Jaspersoft Studio Professional-6.3.0.final\ca_driver\oajc.jar

3. in Jasper Studio, right click on Data Adapters and select "Create Data Adapter"

4. Select "Database JDBC Connection":

4.PNG

 

5. Fill in the fields as follows with the appropriate information for your environment:

 

5.PNG

6. Click on the "Driver Classpath" tab on the bottom, then click the "Add" button and browse to the directory where you copied the oajc.jar file, and select that file:

6.PNG

7. Next click the "Test" button and ensure it tests successfully:

7.PNG

You are now finished and can use Jasper Studio to create custom reports. Once the reports are complete, you will export them to your Jasper Server instance via the server connection you created in the first part.

Additional Information:

For additional information on creating reports using Jasper Studio, please refer to the Tibco documentation and community site found here:

http://community.jaspersoft.com/documentation?version=29351