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:

  1. %  (any string of characters)

  2. _   (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.