Skip to Content

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.

 

image

 

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.

Downloadconnections.java:Java class to extract connection details from UAT server.

Downloadconnections.xml:XML file for storing connection details from UAT.

Mapxml.java:Java class for mapping UAT connections to Production using the properties file.

Database.properties:Properties file where UAT to Production connection detail mappings are stored.

Updateconnections.xml:XML file having the connection details for Production server.

Updateconnections.java:Java class used for updating the connection details in Production server.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply