Wednesday, March 30, 2011

BAM data objects import/export

BAM comes with iCommand for admin purpose. iCommand is in $MW_HOME/ORACLE_SOA/bam/bin folder.

Follow these steps to export:
1) edit config/BAMICommandConfig.xml file. change ADCServerName and port number, where BAM server is running
2) create export.xml

<?xml version="1.0" encoding="utf-8"?>
<OracleBAMCommands continueonerror="1">
<!-- to export data-object "myDO" -->
<Export name="/operations/myProject/myDO" file="myDataObject.xml" contents="0" />
<!-- to export data-object "myDO_1" -->
<Export name="/operations/myProject/myDO_1" file="myDataObject1.xml" contents="0" />
<!-- export all reports -->
<Export type="report" all="1" file="AllReports.xml" />
<!-- export specific report -->
<Export type="report" name="/public/shared/myReport" file="myReport.xml" />
</OracleBAMCommands>

3) execute iCommand as follow

> icommand -cmdfile export.xml

Follow these steps for import
1) edit config/BAMICommandConfig.xml file. change ADCServerName and port number, where BAM server on which configuration needs to be imported.
2) execute following commands to import previously created xml files:
>icommand -cmd import -mode update -file myDataObject.xml
>icommand -cmd import -mode update -file myDataObject_1.xml
>icommand -cmd import -mode overwrite -file myReport.xml

Applies to: Oracle BAM 11.1.1.4.0
Reference: http://download.oracle.com/docs/cd/E12839_01/integration.1111/e10224/bam_app_icommand.htm

3 comments:

harikinnera said...

HI, is it possible to use icommand and clear all the contents of dataobjects but leaving 14 day of data. i.e. can we pass some parameters in Icommand to know the "n" no of days data to retain and delete the rest. Please help.

Unknown said...

Hi How Can we export Bam Reports to EXel and PDf format?

Blogger said...

According to Stanford Medical, It is really the one and ONLY reason women in this country live 10 years more and weigh 19 kilos lighter than us.

(By the way, it has absolutely NOTHING to do with genetics or some secret-exercise and really, EVERYTHING related to "how" they eat.)

P.S, What I said is "HOW", not "what"...

CLICK this link to see if this brief test can help you discover your real weight loss potential