When you load a relational database source, Metadata Manager loads metadata from database schemas into the Metadata Manager warehouse. Use the Schema Inclusion List parameter to select the schemas that you want to load into the Metadata Manager warehouse.
You can configure the Schema Inclusion List parameter for the following resources:
IBM DB2 for LUW
IBM DB2 for z/OS
IBM Informix
Microsoft SQL Server
Netezza
Oracle
Sybase ASE
Teradata
To edit the parameter, select the resource in the Resources panel of the
Load
tab, click
Edit Resource
, and click the
Parameters
tab in the
Edit Resource
window.
The following image shows the
Parameters
tab for a Microsoft SQL Server resource:
Select
Refresh
for schemas that have changed since the last resource load or that you want to load for the first time. Metadata Manager loads the schemas selected for refresh. By default, all previously loaded schemas have
Refresh
selected. You can clear
Refresh
for a previously loaded schema that you do not want to reload. You can also clear or select
Refresh
for all schemas in the
Selected Schemas
list.
If you modify the schemas for Metadata Manager to extract and remove previously loaded schemas, Metadata Manager does not delete any metadata objects from the Metadata Manager warehouse. To delete metadata objects in the Metadata Manager warehouse that no longer exist in the source database, you must purge the metadata for the resource and load the schemas you want in the Metadata Manager warehouse.
If you create a resource for Microsoft SQL Server 2000, the available schemas list contains a list of users for the SQL Server database.