Skip to Content

Automation for updating the custom logon details for Crystal Reports

Imagine, you have more than 500 connection details to be configured as a part of deployment activity from UAT to the production server. In such situations, you will curse yourself by measuring the amount of manual intervention in your hands. As the number of report increases, this activity will become more disruptive. So what is the solution for this? Automation!

Here the automation for updating the connection details is achieved with the help of Business Objects Java SDK. Below is the diagram showing the process flow.




Below cases need to be checked before considering this approach.


1) The Cluster Unique Identifier (CUID) should be the same for a single Crystal Report in both the production and UAT server.


2) Have a proper understanding of the kind of databases, the report is connecting to. My code snippet is based on Oracle database configuration. If the database differs, then minor changes should be made to the code before going for this approach.


Below are the Java code snippet and xml files used for this automation. class to extract connection details from UAT server.

Downloadconnections.xml:XML file for storing connection details from UAT. class for mapping UAT connections to Production using the properties file. file where UAT to Production connection detail mappings are stored.

Updateconnections.xml:XML file having the connection details for Production server. class used for updating the connection details in Production server.

Be the first to leave a comment
You must be Logged on to comment or reply to a post.