Hello Experts,
Need your inputs for the below scenario.
Scenario: SAP BI Platform having hundreds of CR2016 Reports. 70% of the CR2016 reports are based of oracle database 'XYZ'. Management decided to copy the data from database 'XYZ' to 'ABC' for different reasons. In order to accommodate this change in database, I plan to change the database connection of the Crystal Reports from the Crystal Designer and then export the same to BI Launch Pad. Once exporting to CMS, will ask BI Administrator to update the credentials in Database configuration property of the Report from CMC.
Challenge: As we have hundreds of such reports, need to know if there is any automated/easy way to update the database of CR2016 reports from Crystal Designer an CMC.
Assumption1: Considering no change in the table names when copied from database 'XYZ' to 'ABC'
Assumption2: Considering there is change in the table names when copied from database 'XYZ' to 'ABC'.
Environment Details: SAP BI 4.2 SP3; CR2016; Oracle Database
Let me know if you have any questions.
Regards,
Samraj