Authorities and privilegesUse the Warehouse Source notebook to import definitions of tables and views to include in your warehouse source.
The Available tables and views list contains the tables and views that are retrieved from the database catalog based on the filter criteria that you specify. When you move a table, view, or individual column to the Selected tables and views list, you select it as a warehouse source. When you click OK, the newly selected table, view and column definitions are retrieved and defined in the warehouse. These new definitions will appear in this list when you reopen the Warehouse Source notebook or if you select the tables folder below the warehouse source node in the Data Warehouse Center tree.
To import source tables and views into a warehouse source:
On the Tables and Views page, expand either the Tables or Views folder depending upon which type of object you want to import. You can also right-click the whitespace of the Available tables and views list and select Refresh to import both tables and views. The Filter window opens.
In the Filter window, specify the types of objects you want to import from the database. The options available on the Filter window depend upon whether you want to import a table or a view.
Optional: Select Retrieve only those tables that can be replicated to retrieve only those tables that have been enabled for replication. This option is available if you are importing a table.
Optional: Select Retrieve only those views that can be replicated to retrieve only those views that have been enabled for replication. This option is available if you are importing a view.
Optional: Select Include system tables to retrieve system tables from the database. This option is available if you are importing a table.
Optional: In the Object schema field, type a search string, including wildcards, to define the characteristics of the schema names that contain the objects to be returned from the database. For example, XYZ* would return tables and views with schemas that start with these characters.
Optional: In the Object name field, type a search string, including wildcards, to define the characteristics of the table and view names to be returned from the database. For example, XYZ* would return tables and views that start with these characters.
Click OK to submit the filter criteria you entered. The objects that met your filter criteria are returned by the system and listed in the Available tables and views list.
From the Available tables and views list select the tables, views, or individual columns that you want to include in your warehouse source and click >. The tables, views, and columns you selected are moved to the Selected tables and views list.
To include all of the items in the Available tables and views list, click >>.
Go to the Security page if you are defining a warehouse source, or click OK to save your changes and close the Warehouse Source notebook.
Related Information
Adding information about a warehouse source
Specifying database information for a warehouse source
Authorizing warehouse groups to access a warehouse source
Specifying an agent site to access a warehouse source