You can integrate Oracle Administration Tool with third-party source control management systems such as Subversion, Rational ClearCase, or Git, during your repository development process.
This feature is centered around the following integration points:
Converting your binary RPD file to a set of MDS XML documents. Rather than using a single large binary repository file, you can save your repository in MDS XML format. In this format, each repository object, such as a connection pool, physical table, or business model, is represented in its own XML file. The set of XML files that make up your repository can then be managed in your source control management system.
Setting up a Source Control Management (SCM) configuration file. You can use the SCM Configuration Editor in the Administration Tool to specify commands specific to your SCM system, such as Add File, Delete, and Check Out, as well as environment variables required by your SCM system.
Designating your repository as under source control. The first time you open your MDS XML repository in the Administration Tool, you are prompted to specify whether the repository is a standalone MDS XML repository, or whether it is under source control. Choose Use Source Control to enable SCM integration for this repository in the Administration Tool.
MDS XML format is typically used for repositories under source control.
MDS XML represents the Oracle BI Repository across a set of XML files, rather than in a single file.
MDS XML is not the same XML format that was used in previous releases to represent the Oracle BI Repository in XML format. The previous Oracle BI Server XML schema, based on the xudml1.xsd XML schema file in
ORACLE_HOME/bi/bifoundation/server/bin, represents the Oracle BI Repository in one large XML file.
For example, each repository connection pool is stored in its own file, with an XML representation like the following:
<?xml version="1.0" encoding="UTF-8" ?> <ConnectionPool mdsid="m80ca62c5-0bd5-0000-714b-e31d00000000" name="SampleApp_Lite_Xml" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.oracle.com/obis/repository/" password="94F9321C85340FC48E4D9093AA941FF28844074B88D5AA6364E4815DEED7F9B 8792EF452219C2155DB68F61EE1555B4FA886F77E060E2E17F45AD8D18CAB2E4D3EFA15B75E 30D8B4BFA8C7B2D70552BD" timeout="4294967295" maxConnDiff="10" maxConn="10" dataSource="VALUEOF(BI_EE_HOME)/sample/SampleAppFiles/Data" type="Default" reqQualifedTableName="false" isSharedLogin="false" isConcurrentQueriesInConnection="false" isCloseAfterEveryRequest="true" xmlRefreshInterval="2147483647" outputType="xml" ignoreFirstLine="false" bulkInsertBufferSize="0" transactionBoundary="0" xmlaUseSession="false" multiThreaded="false" supportParams="false" isSiebelJDBSecured="false" databaseRef="/oracle/bi/server/base/Database/Sample App Lite Data_80ca62c4 -0bcf-0000-714b-e31d00000000.xml#m80ca62c4-0bcf-0000-714b-e31d00000000" > <Description> <![CDATA[ SampleAppLite connection pool to XML datasource. This connection pool points the database to the location where physical XML files are stored. The location uses the value of an RPD variable : BI_EE_HOME. This variable needs to be correctly set in order for the server to connect to the files. ]]> </Description> </ConnectionPool>
The SampleAppLite repository will generate MDS XML files in a structure like the following:
There is not a one-to-one relationship between repository objects in the Administration Tool and the set of files produced as XML output. For example, physical columns appear as independent objects in the Administration Tool, but in MDS XML they are considered part of the Physical Table object.
See “About the Oracle BI Server MDS XML API” in XML Schema Reference for Oracle Business Intelligence Enterprise Edition for full information about the MDS XML schema representation of repository objects.