Latest News

Thursday, April 5, 2018

Export and Import BAR files in OBIEE 12C


What is BAR?

BI Application Archive (BAR) files are zipped-up copies of the RPD, Catalog and Security model metadata from a Service Instance.
When deploying your BI application from one server to another you can now use these BAR files to transfer your metadata rather than
transferring the RPD, catalog and security model separately.

It’s also a simple method of taking point in time backups of your application.

Steps to export and import BAR files in OBIEE 12C

Step 1:

Go to C:\Oracle\Middleware\Oracle_Home\oracle_common\common\bin
Run wslt.sh script



Step 2:

To view   List of serviceinstaces use the wslt command listBIServiceInstances(domainhome)
Run listBIServiceInstances('C:/Oracle/Middleware/Oracle_Home/user_projects/domains/bi')
wls:/offline> listBIServiceInstances('C:/Oracle/Middleware/Oracle_Home/user_projects/domains/bi')




Exporting BAR files

Note:

4 main Parameters for exporting and importing bar files

1.DOMAIN_HOME                                          (<obiee_home>/user_projects/domains/bi)
2.Serive Instance                                             key the instance key of the BI service you are intercating with
3.Working directory                                        Where export command will store files temporarily while  exexutingth eprocess
4.Export directory                                            Is the directory where BAR files will be stored

Step 3:

Create working directory and export directory
My working directory is: /C:/workDir
My export directory is: /C:/exportDir
Service instance key: ssi
Run below command:
exportServiceInstance(domainhome,service_instance key, working dir path, export dir path)
exportServiceInstance('C:/Oracle/Middleware/Oracle_Home/user_projects/domains/bi','ssi','/C:/workDir','/C:/exportDir')

Step 4:

Verify exportDir


Importing of BAR files

While importing BAR files we can choose whether to import all three components (RPD,Catalog,Security model) or just selected elements.

importServiceInstance  command Parameters:

  • ·         DomainHome
  • ·         Service instance key
  • ·         BAR file to import
  • ·         IMPORT THE rpd
  • ·         Import the webcat
  • ·         import the security model
  • ·         Include credentials (This is passowrd used to encrypt the  database connectioncredentials in the RPD.

 Note:
 First 3 parameerts are mandatory
😉
Command :

importServiceInstance(DomainHome,Service Instance Key,BAR file to import)

Run below command:

importServiceInstance('/u01/app/obiee/user_projects/domains/bi','ssi','/u01/importDir/ssi.bar')

Above command  import the RPD, catalog and security model, but not the user runtime info. The connection credentials would not be imported(if they are even in the file)

importServiceInstance('/u01/app/obiee/user_projects/domains/bi','ssi','/u01/importDir/ssi.bar',true,true,true,'Password')

Above command will import RPD,Catalog an dsecurity model and run time user information also. This is the best command while deploying from development to Production environment.

importServiceInstance('/u01/app/obiee/user_projects/domains/bi','ssi','/u01/importDir/ssi.bar',true,true,false,'Password')

Above command will import RPD,catalog,but it will not import security model or run time user information.

                                                             ðŸ˜ŠðŸ˜ŠðŸ˜ŠðŸ˜ŠðŸ˜Š


  • Google+
  • Pinterest
« PREV
NEXT »

2 comments

  1. The effectiveness of IEEE Project Domains depends very much on the situation in which they are applied. In order to further improve IEEE Final Year Project Domains practices we need to explicitly describe and utilise our knowledge about software domains of software engineering Final Year Project Domains for CSE technologies. This paper suggests a modelling formalism for supporting systematic reuse of software engineering technologies during planning of software projects and improvement programmes in Final Year Projects for CSE.

    Software management seeks for decision support to identify technologies like JavaScript that meet best the goals and characteristics of a software project or improvement programme. JavaScript Training in Chennai Accessible experiences and repositories that effectively guide that technology selection are still lacking.

    Aim of technology domain analysis is to describe the class of context situations (e.g., kinds of JavaScript software projects) in which a software engineering technology JavaScript Training in Chennai can be applied successfully

    The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

    ReplyDelete
  2. I can’t believe focusing long enough to research; much less write this kind of article. You’ve outdone yourself with this material without a doubt. It is one of the greatest contents. Shipping Containers for sale Brisbane

    ReplyDelete