Extract Webi & Crystal Reports with Universe/DB used in it from SAP BusinessObjects 4.1/4.2 & 4.2 SP7 Upgrade

Business Objects Administrators can use this Utility to extract Webi and the universe used in it, and Crystal Reports with DB tables used in it from BOBJ Public folders in CSV format. This utility uses BOBJ SDK programming.

The existing jar file has been updated for BI 4.2 SP7 upgrade which extracts type Webi; Crystal Reports; Hyperlink; Excel; Object Package; ProgramObjects; Shortcuts; Publication; Word and Excel.

How to Run it :

• Make sure you have JAVA installed on the machine and BOBJ client tools are installed. If you are running on BOBJ server you don’t need any client tools.
• Create “Temp” folder under C:\ . Utility genrates output CSV to C:\Temp folder .
• Open Command prompt as Administrator . Run the tool using below command

Java -jar FoldersExtraction.jar

In my case JAR file located in C:\Temp

• A .CSV file will be generated into Temp folder.

Output Format :

Output will have:

• Report Name
• Report CUID
• Last Modified Date
• Report Type
• Tables/View used
• Folder Location

In case of multiple tables in report, utility will add the additional columns with the table names.

The utility for the older version (4.1/4.2 SP1/2/3) can be downloaded here.

The utility for the older version (4.2 SP7+) can be downloaded here.