Search This Blog

Friday 4 December 2020

Exporting and Importing BAR file OBIEE 12.2.1.4.x

We have an utility to export OBIEE Catalog, RPD, security model and all other relevant objects to be exported into a .bar file and the same could be imported if we have to migrate to any other environment or as a backup. Please follow the below steps for the same.

Upto 12.2.1.3, We have export_service_instance and import_service_instance command but 12.2.1.4 those commands are deprecated and introduced exportarchive and importarchive.

Exporting BAR File in OBIEE 12c:

 ***********************************************************

1. Make sure that the below environment variables are set:

BI_PRODUCT_HOME=$ORACLE_HOME/bi
ORACLE_HOME=/obiee12c (where OBIEE installed)
DOMAIN_HOME=/obiee12c/user_projects/domains (Where domain is located)

2. Run the below command with exportarchive.sh

Syntax:

[DOMAIN_HOME]/bitools/bin/exportarchive.sh ssi <Bar file name>.bar encryptionpassword=<password>

Example:

[DOMAIN_HOME]/bitools/bin/exporarchive.sh ssi /obiee12c/backup/obitest.bar encryptionpassword='Admin123'

Note: 

Encryption password is optional. If you are chosen with password, you have to use the same while importing

Importing BAR File in OBIEE 12c:

 ***********************************************************

The import_bar.sh |. cmd command is deprecated in OBI 12.2.1.4. 

With 12.2.1.4, use the importarchive.sh (Linux) | importarchive.cmd (for windows) command.

You may use the -h switch for syntax

[DOMAIN_HOME]/bi/bitools/bin/importarchive.sh -h

USAGE : <service instance key> <location of bar file to import> [nodatamodel] [nocontent] [noauthorization] [nodatasets] [nosearch] [noaction] [encryptionpassword=<encryption password for connections>]
 Description         : Import bar as a service instance
 Mandatory Arguments : service instance key and location of bar file
 Optional Arguments  : exclude list of values:nodatamodel nocontent                        noauthorization nodatasets nosearch
  nodatamodel        : Do not import RPD metadata content
  nocontent          : Do not import WEBCAT metadata content
  noauthorization    : Do not import JAZN metadata content
  nodatasets         : Do not import DSS metadata content
  nosearch           : Do not import Search metadata content
  noaction           : Do not import Action metadata content
  encryptionpassword : Encryption password for connections if any 

Syntax:

./importarchive.sh ssi /obiee12c/backup/obitest.bar                  encryptionpassword=<password>                                        

Example:                                                            ./importarchive.sh ssi /obiee12c/backup/obitest.bar encryptionpassword=Admin123

Cheers!

Bose

10 comments:

  1. Thanks buddy, this was very helpful to me.

    ReplyDelete
  2. what is the difference between exportarchive and export service instance

    ReplyDelete
  3. This is such a great resource that you are providing and you give it away for free.

    ReplyDelete
  4. keep going its really helpful keep sharing your information

    ReplyDelete
  5. This comment has been removed by a blog administrator.

    ReplyDelete
  6. whoah, this weblog is excellent I like reading your articles.

    ReplyDelete
  7. Hello ,

    Thanks much for sharing this content, this worked but we see the below error. Can you please help us on this.

    Execution of operation exportArchive FAILED for RPD_Offline_FSS_Content_Plugin Status object: false

    Thanks

    ReplyDelete

OBIEE 12c to OAS Migration

 Hi All, I have migrated successfully few projects from BI 12c to OAS 6.4. If  anyone wants help then please reach Me! Cheers! Bose

Recent Posts