Preface
Using Metadata Manager
- Using Metadata Manager Overview
  - Resource Types
- Metadata Manager Architecture
- Metadata Integration Process
- Working with Metadata Manager
- Metadata Manager Interface
  - Load Tab
  - Permissions Tab
Configuring Metadata Manager
- Configuring Metadata Manager Overview
- Step 1. Create and Configure the Metadata Manager Service
- Step 2. Install the Metadata Manager Agent
Application Resources
- SAP R/3 Resource Overview
- Configuring SAP R/3
- Creating an SAP R/3 Resource
  - SAP R/3 Configuration Properties
- Configuring the Component Inclusion List
- Reference
Business Glossary Resources
- Business Glossary Resources Overview
- Application Services Verification
- Creating a Business Glossary Resource
  - Business Glossary Connection Properties
- Business Glossary Objects Extracted
- Business Glossary Objects Not Extracted
Business Intelligence Resources
- Business Objects
- Cognos
- Microsoft Analysis and Reporting Services
- Microstrategy
- Oracle Business Intelligence Enterprise Edition
- Tableau
- Incremental Metadata Load
- Adding or Removing Metadata Files for a Resource
Custom Resources
- Configuring Custom Metadata Sources
- Creating a Custom Resource
- Configuring the Template Name
- Adding or Removing Metadata Files for a Resource
Data Integration Resources
- Informatica Platform Resources
- Microsoft SQL Server Integration Services Resources
- PowerCenter Resources
Data Modeling Resources
- Embarcadero ERStudio
- ERwin
- SAP PowerDesigner
- Adding or Removing Metadata Files for a Resource
- Reference for Data Modeling Resources
Database Management Resources
- Cloudera Navigator
- IBM DB2 for LUW
- IBM Db2 for z/OS
- IBM Informix
- JDBC
- Microsoft SQL Server
- Netezza
- Oracle
- Sybase ASE
- Teradata
- Configuring the Schema Inclusion List
- Data Lineage for Database Management Resources
  - Tables in Join Statements
  - SQL Inline Views
Universal Resources
- Universal Resources Overview
- Available Metadata Sources
- XConnect Creation
- Resource Creation
  - Step 1. Configure the Metadata Source
  - Step 2. Create the Resource
    - Metadata Extraction from a Source File
Managing Resources
- Managing Resources Overview
- Configure Connection Assignments
- Upload Rule Sets
  - Linking Rules Files
  - Uploading a Rule Set
- Purging Metadata
- Refreshing the Resources Panel
- Updating the Search Index
- Customizing the List of Words to Ignore in Searches
Loading and Monitoring Resources
- Loading and Monitoring Resources Overview
- Loading Resources
- Linking Objects Across Resources
- Monitoring Resources
- Logs and Log Files
- Troubleshooting Resource Loads
- Scheduling Resource Loads
Managing Permissions
- Managing Permissions Overview
- Configuring Permissions for Users and Groups
- Configuring Permissions on the Metadata Catalog
Resource Migration
- Resource Migration Overview
- Resource Migration Steps
- Step 1. Copy the Plug-in for a Universal XConnect
- Step 2. Migrate the Model
  - Exporting a Packaged or Universal Model
  - Importing a Packaged or Universal Model
- Step 3. Migrate the Resource Configuration
  - Exporting a Resource Configuration
  - Importing a Resource Configuration
- Step 4. Load the Resource
- Step 5. Migrate Resource Metadata
  - Exporting Resource Metadata
  - Importing Resource Metadata
Repository Migration
- Repository Migration Overview
- Migrating the Repository when Domain Names and Encryption Keys are the Same
- Migrating the Repository when Domain Names or Encryption Keys Differ
Appendix A: Metadata Manager Login
- Metadata Manager Login Overview
- Cookies
- Logging in to Metadata Manager
- Changing a Password
Appendix B: Metadata Manager Properties Files
- imm.properties
  - Metadata Manager Application Properties
  - Data Lineage Properties
- searchpriorities.xml
  - Search Result Configuration
  - Sample searchpriorities.xml File
Appendix C: Resource Configuration Files
- Resource Configuration Files Overview
- Resource Configuration File Format
- Passwords in Resource Configuration Files
- Secure JDBC Parameters in Resource Configuration Files
- Sample Resource Configuration File
Appendix D: Glossary
- Glossary of Terms

Metadata Manager Administrator Guide

10.5.2
- 10.5.6
- 10.5.5
- 10.5.3
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

ERwin 7.x, 8.x, and 9.x (File) Configuration Properties

Update the configuration properties when you create or edit an ERwin 7.x, 8.x, or 9.x (File) resource.

The following table describes the configuration properties:

Property	Description
Agent URL	Host name and port number of the Metadata Manager Agent.
Source system version	Version of ERwin that you used to export the metadata source file or the version of the ERwin Data Modeler to which you want to connect.
Always use latest source files	The Metadata Manager Agent uses the metadata source file in the location you provide each time you load the resource. If you enable this option, the path to the file must include an absolute path that is accessible from the Metadata Manager Agent machine. If you disable this option, the Metadata Manager Agent copies the metadata source file to the Metadata Manager application directory when you finish configuring the resource. Each time you load the resource, the Metadata Manager Agent uses the copied metadata source file in the Metadata Manager application directory.
Import UDPs	Specifies how the Metadata Manager Agent imports property definitions and values for user-defined properties (UDPs) from ERwin. In ERwin, a user-defined property is a property definition object that has a default value. The object to which the UDP applies can have an explicit value or no assigned value. If it has no assigned value, ERwin assigns the default value of the property definition to the UDP. Select one of the following options to specify how to import property definitions and values: As metadata. Imports explicit values as Property Value objects. This option keeps the default value on the Property Type. Implicit values are not imported. As metadata, migrate default values. Imports explicit and implicit values as Property Value objects. In description, migrate default values. Appends the property name and value to the object description property, for explicit and implicit values. Both, migrate default values. Imports the UDP value as metadata and in the object description.
Import relationship name	Specifies how to import the relationship names from ERwin. Select one of the following options: From relationship name. Use the relationship name property. From relationship description. Use the relationship description property. Use this option to give more descriptive names to relationships. Default is from relationship name.
Import column order from	Specifies how to import the order of columns in tables. Specify one of the following values: Column order. Imports based on the order of the columns displayed in the ERwin physical view. Physical order. Imports based on the order of the columns in the database, as generated in the SQL DLL. Default is physical order.
Import owner schemas	Imports owner schemas. Specify one of the following values: True. Imports the owner schema for tables, views, and other database objects False. Ignores the owner schema for all database objects. Default is true.
Import diagrams	Specifies how the Metadata Manager Agent imports diagrams. Specify one of the following values: None. The Metadata Manager Agent imports no diagrams. Current view. The Metadata Manager Agent imports the current view of each diagram. All. The Metadata Manager Agent imports diagrams twice, once for the logical view and once for the physical view. Default is current view.
Move entities to subject areas	Specifies whether to move entities to user-defined subject areas. Set this option to true if the ERwin modeler uses subject areas as conventional (UML) design packages with their own namespace and if each entity belongs to one subject area. Specify one of the following values: True. The Metadata Manager Agent places the entities in the corresponding package. It places other entities under the model. False. The Metadata Manager Agent does not move entities to subject areas. Default is false.
Auto assign connections	The Metadata Manager Agent configures connection assignments to relational database resource types during the resource load. If you disable this option, you must configure connection assignments in the resource properties after you create the resource.
File	ERX, ER1, erwin, or XML source file you exported from ERwin. To parse the ER1 and erwin files, install ERwin on the same machine on which the Metadata Manager Agent runs.

Rename Saved Search

Table of Contents

Metadata Manager Administrator Guide

Metadata Manager Administrator Guide

ERwin 7.x, 8.x, and 9.x (File) Configuration Properties

ERwin 7.x, 8.x, and 9.x (File) Configuration Properties