Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Change database password for multiple reports

Hi,

We have hundreds of crystal reports scheduled in Enterprise XI(Infoview). For business reasons, we are planning to change the Oracle database password. I looked at the schedule manager for changing the Oracle database access for set of reports. When I changed the password, it affects the reports I scheduled afresh but not the already existing recurring instances.

I browsed through the forums and I see that infoview - CMC and Scheduled Manager does not allow a bulk database update(update of login/password for recurring instances). Forums suggest writing a SDK application or buying universe or Object manager to achieve the same. Is there any other way to accomplish this with the existing setup?

As the jobs are scheduled, I think there must be some files holding those information. If so, where can I find those files to change the database access for the existing recurring instances on the crystal server?

Any suggestion is appreciated.

Thanks in advance.

Sai

Former Member
Former Member replied

This has been a real limitation for us as well. While we were not able to bulk-apply the report credentials, we were able to lessen the pain by using a desktop automation tool called AutoHotKey (AHK). Using AHK we recorded our steps in applying the new credentials in a script which we could then execute with a hot key (example: Ctrl-Y). This sped up the process of manually applying new database credentials to 200+ reports.

AHK is free and can be found via Google. Google knows all.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question