Regular backup of BOE

Sometimes the only thing people do to backup BusinessObjects Enterprise server data is to backup CMS database. Unfortunately CMS database does not contain universes, documents and other stuff, it has only metadata about them (ids, descriptions etc). Backup of CMS database is not enough to restore the system from the scratch. Complete BIAR is often sufficient to restore the server.

The complete BIAR can be build from Import Wizard or using BIAR command line tool (biarengine.jar). The purpose of the command line tool is to automate importing and exporting of BIARs.

Simplest solution (example)

1. Create file export.properties in D:\Backup on the server with the following content:

action = exportXML
exportBiarLocation = complete.biar
userName = Administrator
password =
authentication = secEnterprise
CMS = localhost
exportDependencies = true
includeSecurity = true
exportQueriesTotal = 3
exportQuery1 = select * from CI_INFOOBJECTS
exportQuery2 = select * from CI_SYSTEMOBJECTS
exportQuery3 = select * from CI_APPOBJECTS

2. Create batch D:\Backup\backupBOE.bat executing the BIAR command line tool with the properties file.

java -jar "D:\Business Objects\common\4.0\java\lib\biarengine.jar" export.properties

3. Schedule the backupBOE.bat to run regularly in Windows scheduler.

Note that to import the BIAR you will have to use biarengine.jar and not Import Wizard. Import and export of BIAR files is not supported across tools. However it usually works if you export and import only universes and documents. I.e. when export.properties is:

action = exportXML
exportBiarLocation = complete.biar
userName = Administrator
password =
authentication = secEnterprise
CMS = localhost
exportDependencies = true
includeSecurity = true
exportQueriesTotal = 2 
exportQuery1 = select * from CI_INFOOBJECTS 
exportQuery2 = select * from CI_APPOBJECTS

Further information

3 thoughts on “Regular backup of BOE

  1. Salil Verma

    I want to develop an export import customized tool in java using import wizard sdk.
    Can you please suggest from where can I get import wizard sdk and corresponding jars?

    Like

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s