Manually create a sdm_ds datasource in JasperReports

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

Is there a way to manually create the datasource in JasperServer Reports 7.9 that points to SDM 17.3 RU 10 or later?

Environment

Release : 17.3 RU 10 and later

Resolution

1. Ensure the steps under "Move the configuration and authentication files" from the following link have been implemented:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/ca-service-management/17-3/installing/installing-ca-service-management-17-3/installing-common-components-ca-eem-cabi-jasperreports-ca-process-automation/cabi-jasperreports-server-for-ca-service-management/jasperreports-server/integrate-jasper-reports-server-79-with-casm.html#concept.dita_b3b296fc-cfa4-455e-8c05-53bb0dc80949_Integrate17.3.0.18andBefore

2. Log into JasperReports Server 7.9 as superuser

3. Click on "+ Create" button under Data Sources

4. Select/Enter the following:

4.1 Type=JDBC

4.2 JDBC: Select com.ca.sdm.dal.jdbc.driver.DalJdbcDriver

If it's not in the dropdown list, select other and in the JDBC Driver enter: com.ca.sdm.dal.jdbc.driver.DalJdbcDriver

4.3 URL: jdbc:sdm:bop:@<SDM hostname>:<slump port>;impersonateUserUuid={attribute('contactUUID')}

Example: jdbc:sdm:bop:@poyar-test7:2100;impersonateUserUuid={attribute('contactUUID')}

4.4 User name: Enter an SDM username. Example: ServiceDesk

4.5 Password: In this step, enter the encrypted password. Steps below to get the encrypted password:

4.5.1 Open CMD > Go to the path to \CASM_17.3.0.<RU version>\filestore\Jasper\Utils 

4.5.2 run: gen_passwd.bat <SDM username> <password>

If any error in this step, add the JRE\bin to the path and then close and open cmd for the changes to take effect

Example:

4.5.3 Copy the generated password (see in green in the cmd screenshot above)

4.5.4 Paste it into the new data source, password field:

Example:

4.6 Test Connection and Save changes.