Changing password for connections and database configuration screen for every 60 days

[former_member518509]

Hi All,

Need your expertise , We have a requirement where password in database configuration for Crystal reports and Connections passwords in Universe will be changed for every 60 days.

So is there any way apart from manually setting password for all bulk reports?

Thanks in Advance

Regards,

Sriram

[DellSC]

There are third-party tools available that can help with this. As a start, you could look at APOS (www.apos.com) or Wiisdom (www.wiisdom.com).

Or you could write code using one of the SDKs:

For Crystal connections you would use either the Java or the .NET SDK.

For universe connections, you would use a combination of the Java and Semantic Layer SDKs or there might be a way to do this using the RESTful Web Services Semantic Layer SDK.

-Dell

[former_member518509]

Thanks Dell for your response.

do you have any sources or links for this part "For Crystal connections you would use either the Java or the .NET SDK."

Thanks,

Sriram

[DellSC]

I have done similar things in the past using both the .NET and the Java SDKs and I might be able to provide some sample code - unfortunately, my code archive is on an external drive that I can't access from this computer, so it would take me a day or two to find the time to get it through my personal laptop.

Both of the SDKs can be installed from the Client Tools install.

You can find links to documentation and sample code for both here: https://archive.sap.com/documents/docs/DOC-27465

I usually take a very OO approach to my SDK work. In both C# and Java I have a class that handles all of the basic interaction with the SDK - logon, logoff, instantiating the InfoStore that is used to query the CMS for objects, etc. This way I can reuse that code as needed instead of having to update the same code in lots of places if there are changes to the SDK. If you'd like an example of what I do for this "common" class, see the BOECommon code at http://www.dellstinnett.com/sample_code. This code is older, but it should still work.

-Dell