Not Found
English

Page Not Found

The page or file you are looking for has been moved or no longer exists.

The following links might help you find the content you need:


You can also search the Documentation Portal or visit the home page.

English
  • Metadata Manager 10.5.5
  • All Products

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

Back Next

Organization of Objects in the Metadata Catalog

Organization of Objects in the Metadata Catalog

When you load an SQL Server Integration Services resource, Metadata Manager organizes SQL Server Integration Services objects in the metadata catalog according to the connections in which the objects are used. To select an object such as a column in the metadata catalog, navigate to the object through the source or target connection in which the object is used.
For example, package HypoStores_HR contains a data flow that reads data from the EMPLOYEE table in a relational database. The OLE DB source connection object HR_DB contains the connection to the database that contains the EMPLOYEE table. To navigate to the EMPLOYEE table in the metadata catalog, expand the HR_DB source connection in the Connections group.
The following example shows the metadata catalog hierarchy for a data attribute such as a column: 
<Packages>
    Connections
        <Source/Target> 
            <Package> (schema, directory, etc.)
                <Data Set> (table, file, etc.)
                    <Data Attribute>
    <Summary Content>
        <Summary Model>
            Connections
                <Source/Target>
                    <Package>
                        <Data Set>
                            <Data Attribute>
            Task Variables Store (Connection class)
                …
0 COMMENTS
We’d like to hear from you!