Is there a way to manually create the datasource in JasperServer Reports 7.9 that points to SDM 17.3 RU 10 or later?
Release : 17.3 RU 10 and later
1. Ensure the steps under "Move the configuration and authentication files" from the following link have been implemented:
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.