Sometime back, I have posted on creating Catalog Metadata (GUI) and Repository Metadata (again GUI)
What if we have a way to automate this metadata. We code some lines, schedule it – simple!
The trick lies in using the /command switch of the AdminTool to run a script of commands.
Create a command script: BiCoach_RPDMetadata.build and put in the following few lines:
Create a command script: BiCoach_RPDMetadata.build and put in the following few lines:
Replace MWHOME with local OBIEE installed path, BiCoach_repository with your own and the repository password with your own.
—-
OpenOffline
—-
OpenOffline
<MWHOME>\instances\instance1\bifoundation\OracleBIServerComponennt\coreapplication_obis1\repository\BiCoach_repository.rpd <repository password>
DescribeRepository D:\scriptoutput\BiCoachrepository_report.csv UTF-8
Close
Exit
—-
Now since we have to automate, lets create a script to run the AdminTool and pass in the script file created above.
—-
@echo off
—-
Now since we have to automate, lets create a script to run the AdminTool and pass in the script file created above.
—-
@echo off
set ORACLE_BI_APPLICATION=coreapplication
set JAVA_HOME=<MWHOME>\Oracle_BI1\jdk
set ORACLE_HOME=<MWHOME>\Oracle_BI
set ORACLE_INSTANCE=<MWHOME>\instances\instance1
call %ORACLE_INSTANCE%\bifoundation\OracleBIApplication\%ORACLE_BI_APPLICATION%\setup\user.cmd
set PATH=%ORACLE_HOME%\common\ODBC\Merant\5.3\Drivers;%ORACLE_HOME%\bifoundation\server\bin;%ORACLE_HOME%\bifoundation\web\bin;%ORACLE_HOME%\bin;%PATH%
<MWHOME>\Oracle_BI1\bifoundation\server\bin\AdminTool.exe /command d:\scripts\BiCoach_RPDMetadata.build
—-
Generated CSV file is what we are looking for. Go ahead and schedule this script in Windows Explorer.
—-
Generated CSV file is what we are looking for. Go ahead and schedule this script in Windows Explorer.
