Scanning and Managing Metadata

You can scan source and target metadata from different databases, data models, or flat files etc. Ensure that you create an appropriate environment depending on the database type. For example, if you want to scan metadata from SQL Server, then you should create the SQL Server environment.

The metadata scan adds data dictionary, table properties, and column properties that can be validated and updated. You can enrich your metadata by assigning codesets to columns as valid values. Tables and columns can be associated with business and technical assets and these associations can be viewed on a mind map. You can also assign workflows to tables and columns using the Workflow Manager and view workflow logs.

Scanning and managing metadata involves:

• Scanning metadata from data sources
• Adding tables
• Adding Columns
• Deleting tables and columns
• Scheduling metadata scans
• Updating table properties
• Updating column properties
• Validating data
• Assigning codesets to columns
• Viewing workflow logs of tables
• Viewing workflow logs of columns
• Associating tables
• Associating columns