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

SQL Server Integration Services Repository Configuration Properties

SQL Server Integration Services Repository Configuration Properties

Update the configuration properties when you create or edit an SQL Server Integration Services resource from one or more packages in a Microsoft SQL Server repository.
The following table describes the configuration properties:
Property
Description
Agent URL
Host name and port number of the Metadata Manager Agent.
To extract metadata from the SQL Server repository, the Metadata Manager Agent must be on the same machine as the SQL Server Client components.
Source system version
Name and version of the metadata source. Select
Microsoft SQL Server Integration Services (Repository)
.
SQL Server version
Microsoft SQL Server version.
Host
Host name or IP address of the machine where SQL Server Integration Services run.
Password
Password for the package. If you include multiple packages in a resource, the packages must use the same password.
Required if the packages are encrypted with a password. If you do not enter the password, the Metadata Manager Agent cannot extract metadata from the packages.
Optional if the values of sensitive properties in the packages are encrypted with a password. Metadata is not a sensitive property. Therefore, the Metadata Manager Agent can extract metadata whether or not you specify the password.
Variable values file
File that defines the values for the user-defined variables in the package. Specify a variable values file when variables in the package do not have values or when you want to override the variable values defined in the package.
The location of the variable values file must be accessible from the machine where the Metadata Manager Service runs. When SQL Server Integration Services is not on the same machine as the Metadata Manager Service, ensure that the variable values file is in a location that both SQL Server Integration Services and the Metadata Manager Service can access.
Hide transformation scripts
Controls how Metadata Manager displays lineage for Script components that are used as transformations.
If you set this property to true, Metadata Manager does not display input or output ports for any transformation script. The data lineage diagram shows links between all columns in the source object and all columns in the target object.
If you set this property to false, Metadata Manager creates a separate object in the lineage diagram for each transformation script.
Default is true.
Auto assign connections
Metadata Manager configures connection assignments to relational database resource types during the resource load. If you disable this option, configure connection assignments in the resource properties after you create the resource.
Package
Names of the SQL Server Integration Services packages from which you want to extract metadata. Click
Select
to select one or more packages.

0 COMMENTS

We’d like to hear from you!