Table of Contents

Search

  1. Preface
  2. Using Metadata Manager
  3. Configuring Metadata Manager
  4. Application Resources
  5. Business Glossary Resources
  6. Business Intelligence Resources
  7. Custom Resources
  8. Data Integration Resources
  9. Data Modeling Resources
  10. Database Management Resources
  11. Universal Resources
  12. Managing Resources
  13. Loading and Monitoring Resources
  14. Managing Permissions
  15. Resource Migration
  16. Repository Migration
  17. Appendix A: Metadata Manager Login
  18. Appendix B: Metadata Manager Properties Files
  19. Appendix C: Resource Configuration Files
  20. Appendix D: Glossary

Metadata Manager Administrator Guide

Metadata Manager Administrator Guide

Configuring the Schema Inclusion List

Configuring the Schema Inclusion List

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:
The Parameters tab for a relational resource lists the available schemas on the left and the selected schemas on the right. Metadata Manager loads the schemas in the “Selected Schemas” list that are selected for refresh.
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.

0 COMMENTS

We’d like to hear from you!