Jasper Reports Support Platform with MYSQL database

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

When integrating Jasper reports using MYSQL database with SOI using SQL database, you have the install Jasper reports using CABI process as documented in  https://docops.ca.com/ca-service-operations-insight/4-0-cu1-sp2/en/installing/installation/how-to-perform-a-full-ca-soi-deployment/install-cabi-jasperreports-server#InstallCABI(JasperReportsServer)-InstallSOIReportswithorwithoutCABIJasperReportsServer and On the SOI Report installation, select the option - "Without CABI JasperReports Server".

 

Question:

We are running a CA SOI 4,0 CU 1 over Windows and SQL Database. I am planning to install SOI Reports and CABI JasperReport 6.1.0 on Windows 2012 R2 with MYSQL database. In this scenario that I have SOI running over a SQL server, can I have a server running JasperReport AND SOI Report running over a MySQL DB? If I decide to go through this scenario, in what order should I install the components?

Environment:
CA SOI 4,0 CUM 1 SP2, JasperReport 6.1.0, Windows 2012 R2
Answer:

1. Install Jasper - https://docops.ca.com/ca-business-intelligence/6-1-0/en/installing/cabi-installation-on-windows 

Use this link to install(https://docops.ca.com/ca-business-intelligence/6-1-0/en/installing/cabi-installation-on-windows/installing-cabi ) the CABI JasperReport Server. This is manual step so you have to install the MySQL server DB, Java and Apache tomcat, set JAVA_HOME path etc. as mention the prerequisite phase. and provide the details in sample.properties file of MYSQL DB details. 

2. Install SOI Report - https://docops.ca.com/ca-service-operations-insight/4-0-cu1-sp2/en/installing/installation/how-to-perform-a-full-ca-soi-deployment/install-cabi-jasperreports-server#InstallCABI(JasperReportsServer)-InstallSOIReportswithorwithoutCABIJasperReportsServer 

3. On the SOI Report installation, select the option - Without CABI JasperReports Server - in order to install only the SOI Report. 

Additional Information:

https://docops.ca.com/ca-business-intelligence/6-1-0/en/installing/cabi-installation-on-windows 

https://docops.ca.com/ca-service-operations-insight/4-0-cu1-sp2/en/installing/installation/how-to-perform-a-full-ca-soi-deployment/install-cabi-jasperreports-server#InstallCABI(JasperReportsServer)-InstallSOIReportswithorwithoutCABIJasperReportsServer