Oracle BAM report and DO migrate from one environment to other

Oracle provided an in-built tool (i-command) which is used to import and export the report/data objects from one environment to other environments.

This utility will be available under <Middleware>/Oracle_SOA1/bam/bin

In order to export BAM report artifacts from one environment to other environment, we have to first execute the setDomainEnv.sh to set the domain environment variables.

Navigate to /oracle/user_projects/domains/dev_soa_domain/bin and run setDomainEnv.sh file with below command

. ./setDomainEnv.sh

Now since the environment variable are set,

Navigate to <MW Home>/Oracle_SOA1/bam/bin
where we have i-command utility available.

Execute the below command to export the data objects.
Execute the icommand in below format.

./icommand -CMD EXPORT -NAME “/<DO folder>/<DO Name>” -file <DO name>.xml

Example:-

./icommand -CMD EXPORT -NAME “/TestReport/Test_Report” file  Test_Report_DO.xml

Execute the below command to export the reports available under my shared reports
./icommand -cmd export -name “/public/Report/<Folder>/Test_Report” -type report -file Test_Report.xml

Now you will be having the exported DO and report in BIN folder. Move these files to new environment and execute below command.

Note: – Make sure you execute . ./setDomainEnv.sh script before running icommand utility.

Execute the below command to impot the data objects and reports
./icommand -CMD IMPORT -file <file location>/ Test_Report_DO.xml

Update Existing Report

./icommand -cmd import -mode overwrite -file Test_Report.xml

Update existing Dataobject

./icommand -cmd import -mode update -file Test_Report_DO.xml

Advertisements
This entry was posted in BAM and tagged , , . Bookmark the permalink.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s