Install CA Business Intelligence Reports and Dashboards
The following procedures apply to configuring the standalone CABI integration and the Unified Dashboards and Reporting for Infrastructure Management solution. For more information, see Unified Dashboards and Reporting for Infrastructure Management.
capm370
The following procedures apply to configuring the standalone CABI integration and the Unified Dashboards and Reporting for Infrastructure Management solution. For more information, see Unified Dashboards and Reporting for Infrastructure Management.
After you install the
CA Business Intelligence
JasperReports Server, use the following procedures to set up and run CA Business Intelligence
reports in CA Performance Center
.2
Install Reports on the
CA Business Intelligence
JasperReports ServerTo make
CA Business Intelligence
reports that use CA Performance Management
data available, install them on the CA Business Intelligence
JasperReports Server. The capm_reports-xxxx.zip package (where "xxxx" is the package version) is located in the
Installation_Directory/
PerformanceCenter/cabi folder after the CA Performance Management
installation.For
CA Business Intelligence
on Windows, before you install the reports, Powershell must be enabled.The installation script can be used for a fresh installation or an upgrade. The script covers the following items:
- Data source connector files
- Data source connector configuration
- CA Performance Centerhost name, port, and schema definition
- Report files
- Dasboard/dashlets files
- Common folder structure to use in Shared CABI environment
User administration and authentication setting updates are excluded from the script and must be configured manually.
Follow these steps:
- Verify that theCA Business IntelligenceJasperReports Server is available.
- Copy the capm_reports-xxxx.zip file to theCA Business IntelligenceJasperReports Server host and unpack it into a folder for the reports.Ensure the report archive (capm_topn-x.x.x.zip) and the data source archive (capm_da-x.x.x.zip) are in the same folder onCA Business IntelligenceJasperReports Server as the installation scripts.
- Run the Install.bat (Windows) or Install.sh (Unix) installation script.TheCA Performance ManagementCA Business Intelligencecontent installation requires aCA Business Intelligencetomcat instance restart. TheCA Business Intelligenceweb interface is unavailable for approximately 10-15 minutes after the installation start. Ensure that the installation process is done during an appropriate maintenance window.
- Complete the following prompts:
- Input a CA PC target hostSpecify theCA Performance Centerhost name. Do not specify the Data Aggregator host name.
- Input theCA Performance CenterGUIDThis prompt appears only when the installer cannot connect to theCA Performance Centerserver and get GUID automatically.TheCA Performance CenterGUID (unique) is used as the default password, and must be configured correctly. The GUID passes to the Data Aggregator to ensure that the request is going to the correctCA Performance Centerinstance.The following web service call on theCA Performance Centerhost retrieves this information:http://PC_host:8181/pc/center/webservice/datasources/performanceCenterGUIDExample Response:<dataSourceGUID name="CA Performance Center" guid="66750a6b-57f6-440e-b501-d79134d9bb61"/>
- Input a target CA PC port [8181]Specify theCA Performance Centerport.Default:8181
- Input a target schema http/https [http]Specify http or https.Default:http
- CA PC admin user [admin]Specify theCA Performance Centeradmin user.Default:admin
- CA PC admin user password [admin]Specify the password for theCA Performance Centeradmin user.Default:admin
- To configure the values that are required for generating the OpenAPI token, go to the following location:CABIJasperReportsServer/WEB-INF/bundles
- Edit the capc_config.properties file.The OpenAPI token setting values must match the parameter values on the Data Aggregator for (cookieName,tokenEncryptionDecryptionKey, andtokenTimeoutInMinutes) in the following location:/opt/IMDataAggregator/apache-karaf-2.4.3/etc/com.ca.im.odata.authservice.impl.AuthenticationService.cfg
- openAPIcookieNameThe name of the cookie containing the token. This value should match thecookieNamevalue.
- encryptionKeyThe key that is used to decrypt incoming tokens. This value should match thetokenEncryptionDecryptionKeyvalue.
- tokenTimeoutThe length of time, after which, the token is invalidated. This value should match thetokenTimeoutInMinutesvalue.
Configure User Synchronization
When
CA Performance Management
integrates with CA Business Intelligence
, you create and manage users in CA CA Performance Center
. The users that you create in CA CA Performance Center
are replicated in CA Business Intelligence
. Replicated users can access reports and dashboards without having to log in to CABI.Note the following:
- User names that contain the following special characters are not synchronized with the CABI Server:
- , \ | ` " ' ~ ! # $ % ^ & [ ] * + = ; : ? < > } { ) ( /
- Spaces
- Synchronization betweenCA Performance ManagementandCA Business Intelligenceoccurs every 5 minutes. Users that you create in CACA Performance Centermay take up to 5 minutes to appear inCA Business Intelligence.
LDAP support is planned for a future
CA Performance Management
release.Follow these steps:
- On theCA Business Intelligencesystem, copy the following files in<CA Business Intelligence>/apache-tomcat/webapps/jasperserver-pro/WEB-INF/config:
- capm.properties
- capm.jks
- Add the copied files in the following location on the system where CACA Performance Centeris installed:<CA/PC/webapps/pc/WEB-INF/CABIKeystoreCA Performance Center>
Add a Certificate for SSL-Enabled
CA Performance Center
For reporting to work in an SSL-Enabled
CA Performance Center
instance, you must add the appropriate certificates to the CA Business Intelligence
trust store. The appropriate certificates are the root or intermediate certificates comprising the chain of trust for the CA Performance Center
public certificate. For more information, see Set Up SSL Certificates for Performance Center.Follow these steps:
- On theCA Business Intelligenceserver, enter the following URL in a browser to open CACA Performance Center:https://<capc_hostname>:8182A warning about an un-trusted certificate appears in the browser.The browser prompts you to get the certificate.
- Save the certificate with the following name in a local folder:capc_cert.cerThe certificate that you saved is the CACA Performance Centerpublic certificate.If the CACA Performance Centerpublic certificate is not self-signed, you must import the root and intermediate certificates used for signing the CACA Performance Centerpublic certificate.To save the certificate:
- Click the certificate warning button near the URL.
- Click Details, Copy to File.
- Select (DER encoded binary X.509 (.CER)).
- Open the command line by enteringcmd.
- Do one of the following procedures:Linux and all versions of CABI, or Windows and CABI 6 and lower:
- CD to the folder<CABI_INSTALL_FOLDER>/java/lib/securityThe folder should contain the cacerts file. The cacerts file is theCA Business Intelligencetrust store file.If the cacerts file is not in the security folder, search for the folder under the <CABI_INSTALL_FOLDER>.
- Run the following command:<PATH_TO_JAVA>/bin/keytool -importcert -alias ALIAS -keystore cacerts -file <path>/capc_cert.cerIn the -file parameter, <path> indicates the full path to the capc_cert.cer file.
- Enter the password for the cacerts trust store. The default password is "changeit." Then, enter Yes.
- CD to the folder<CABI_INSTALL_FOLDER>/jre/lib/securityThe folder should contain the cacerts file. The cacerts file is theCA Business Intelligencetrust store file.If the cacerts file is not in the security folder, search for the folder under the <CABI_INSTALL_FOLDER>.
- Run the following command:<PATH_TO_JAVA>/bin/keytool -importcert -alias ALIAS -keystore cacerts -file <path>/capc_cert.cerIn the -file parameter, <path> indicates the full path to the capc_cert.cer file.
- Enter the password for the cacerts trust store. The default password is "changeit." Then, enter Yes.
- Restart theCA Business Intelligenceservice.
Windows and CABI 7.1.1 and higher: - CD to the folder<CABI_INSTALL_FOLDER>/java/jre/lib/securityThe folder should contain the cacerts file. The cacerts file is theCA Business Intelligencetrust store file.If the cacerts file is not in the security folder, search for the folder under the <CABI_INSTALL_FOLDER>.
- Run the following command:<PATH_TO_JAVA>/bin/keytool -importcert -alias ALIAS -keystore cacerts -file <path>/capc_cert.cerIn the -file parameter, <path> indicates the full path to the capc_cert.cer file.
- Enter the password for the cacerts trust store. The default password is "changeit." Then, enter Yes.
- CD to the folder<CABI_INSTALL_FOLDER>/jre/lib/securityThe folder should contain the cacerts file. The cacerts file is theCA Business Intelligencetrust store file.If the cacerts file is not in the security folder, search for the folder under the <CABI_INSTALL_FOLDER>.
- Run the following command:<PATH_TO_JAVA>/bin/keytool -importcert -alias ALIAS -keystore cacerts -file <path>/capc_cert.cerIn the -file parameter, <path> indicates the full path to the capc_cert.cer file.
- Enter the password for the cacerts trust store. The default password is "changeit." Then, enter Yes.
- Restart theCA Business Intelligenceservice.
Configure the CA Business Intelligence Authentication
The following OpenAPI configuration file is available on the Data Aggregator in the /opt/IMDataAggregator/apache-karaf-2.4.3/etc directory:
- com.ca.im.odata.authservice.impl.AuthenticationService.cfg
Customize the following parameters to match the configuration on the
CA Business Intelligence
server:- cookieNameThe name of the cookie containing the token. This value should match theopenAPIcookieNamevalue.
- tokenEncryptionDecryptionKeyThe key that is used to decrypt incoming tokens. This value should match theencryptionKeyvalue.
- tokenTimeoutInMinutesThe length of time, after which, the token is invalidated. This value should match thetokenTimeoutvalue.
Verify Time Synchronization
Date and time settings in CA
CA Performance Center
and CA Business Intelligence
must be synchronized. If the date and time settings are not synchronized, an error can occur when users access reports. The error occurs when the difference in time exceeds the Cookies Expiration Timeout set in CA CA Performance Center
(Default: 20 minutes).