Part 1: Create Data Source
The Create Data Source screen is used to create a new data source.
In BI Catalog Builder, a data source is a master set of database objects, from which pertinent subsets, known as business areas, are defined.
A data source is created by providing it a name and specifying which tables/views it contains.
Screen’s Fields & Buttons
Data Source Name
Name for data source being created.
Owner
Owner of database object; after selecting relevant owner via this field, click [Query Available Tables/Views] to display all objects belonging to owner in the Available field’s list.
Filter
Used to filter results returned for selected owner. The following wildcard characters can be used:
-
% (any string of characters)
-
_ (any single character)
Click [Query Available Tables/Views] to view all objects belonging to selected owner and satisfy entered filter expression in the Available field’s list.
[Query Available Tables/Views] – Button
If values for Owner or Filter field are changed, click this button to refresh the results for the Available field’s list.
Available – List
Lists all database objects that belong to selected owner and satisfy the entered filter.
Selected – List
Lists database objects selected for data source being created; use arrow buttons to add or remove objects from this list - single arrows move one selected object, and double arrows move all objects.
[Apply] – Button
Once the new data source is defined, click [Apply] to save it, and to move to the next step, which is to create business areas for the new data source.