The FlexDeploy OTBI solution allows developers to either source the WebCatalog objects from a development OTBI instance or from a source control system. To source control WebCatalog objects there are two main practices that must be followed.

First, the web catalog objects stored in source control must maintain the same directory structure as the OTBI WebCatalog. The root path in your source control repository can be anything, but the directory structure under it must exactly match that of the WebCatalog. For example, notice the WebCatalog path for the report below:

The path above must match the path in the source control system as we see below.

For above example, FlexDeploy project source configuration will be configured with "Oracle Transactional BI/shared/Custom/Financials" as the sparse folder when using Git. This would ensure that all objects under that folder will be discovered as WebCatalog objects and file path starts with /shared/Custom which matches the WebCatalog path in OTBI.

Secondly, the files stored in source control should be named with the following extensions corresponding to the object type. The extensions are important to both ensure the deployment operation is handled correctly, and to make it easier to identify and search for these objects in FlexDeploy.

OTBI Type Name	OTBI Signature / Composite Signature*	Source Control Extension
Action	action	Action
Agent	coibot1	Agent
Analysis	queryitem1	Analysis
Column	cosavedcolumn1	Column
Condition	condition1	Condition
Dashboard	dashboardfolder1	Dashboard
Data Model	.xdm *	Data Model
Dashboard Prompt	globalfilteritem1	Dashboard Prompt
Filter	filteritem1	Filter
Group	customgroup1	Group
KPI	kpi1	KPI
KPI Watchlist	scorecardkpiwatchlist1	KPI Watchlist
Report	.xdo *	Report
Scorecard	scorecard1	Scorecard
Style Template	.xss *	Style Template
Visual Analyzer Projects	projectfolder1	Visual Analyzer Projects

The OTBI signature can be viewed by hovering over the icon on the OTBI WebCatalog Manager's properties for a catalog object (see image above).

The manual process of ensuring folder structure and files extensions can be cumbersome when managed manually. See Automate check-in of development OTBI catalog items to SCM for details on more effectively manage.

Browser not supported