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

Objects Extracted

Objects Extracted

Metadata Manager extracts metadata for different SQL Server Integration Services objects.
Metadata Manager extracts the following objects from a Microsoft SQL Server Integration Services resource:
  • Function
  • Macro
  • Namespace
  • Parameter
  • Parameters
  • Result Column
  • Result Set
  • Stored Procedure

Connection Manager Types

Metadata Manager extracts metadata for the following connection manager types:
  • OLEDB
  • FLATFILE

Control Flow Tasks

Metadata Manager extracts metadata for the following tasks in a control flow:
Data Flow
Metadata Manager displays a summary of each data flow that a package contains.
Execute SQL
If the SQL statement creates or truncates a table, Metadata Manager displays the table structure. However, Metadata Manager does not display data lineage for the table.

Transformations in a Data Flow

Metadata Manager can display a summary of the data flow when the data flow contains any of the following transformations:
  • Aggregate
  • Audit
  • Character Map
  • Conditional Split
  • Copy Column
  • Data Conversion
  • Derived Column
  • Export Column
  • Fuzzy Grouping
  • Fuzzy Lookup
  • Import Column
  • Lookup
  • Merge
  • Merge Join
  • Multicast
  • Percentage Sampling
  • Pivot
  • Row Count
  • Row Sampling
  • Script Component
  • Slowly Changing Dimension
  • Sort
  • Term Extraction
  • Term Lookup
  • Union All
  • Unpivot
Metadata Manager does not display individual transformations in the metadata catalog or in the data lineage diagram.

0 COMMENTS

We’d like to hear from you!