This Java application can extract the universe metadata into a json file from SAP BusinessObjects.
To run the application your system should satisfy the following requirements:
- Install Java Development Kit 32-bit version.
- Download and install SAP BO Client tools 4.1 from SAP Marketplace (Make sure to select SemanticLayer SDK from the Developer components during the installation process. This is not selected by default). An installation guide is available here.
- Download the Log4j2 library and put the jar file in the
lib/
folder. - Download the Gson library and put the jar file in the
lib/
folder.
The application is configurable through an external XML file. For the detailed explanation of the structure of the config see the BOT_Configuration.docx
document and the default configuration file in the repository. At default the application uses the BOTConfig.xml
file from the same folder where the script is placed into. If you wish to use an other configuration file set the CONFIG_FILE
environmental variable to contain the path of it. The java application will receive the path as a command line argument.
Starting the application is very easy using the BOMetadataExtraction.bat
file. You only need the set two environmental variables:
JAVA_HOME
Set the path of your installed JDK for example:SET JAVA_HOME=C:\Program Files (x86)\Java\jdk1.8.0_65
BO_HOME
Set the path of your installed BO Client library for example:SET BO_HOME=C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0
After setting the variables you only start theBOMetadataExtraction.bat
file. The result will be available in the same folder where the script was running from.