Metadata Manager
- Metadata Manager 10.5
- All Products
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.
|
Database type
| Database connection type to connect to the Data Modeler.
Database can be Microsoft SQL Server (version 7, 2000, 2005, and 2008), Oracle, or Sybase ASE.
For more information about supported databases and libraries, see the ERwin documentation.
|
Database server
| Database server to which you want to connect.
For Microsoft SQL Server or Sybase ASE, specify the server DNS address. For example:
localhost . You can also specify a named Microsoft SQL Server instance like:
servername\namedinstance
For Oracle, specify the appropriate Oracle connection string you want to use. For example:
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORA90) ) )
|
Database name
| Name of the database. Not required for Oracle.
|
Authentication
| Type of authentication to use for the ERwin Data Modeler user name and password. Select one of the following options:
Default is database authentication.
|
User name
| Database user name for ERwin Data Modeler.
Leave this field blank if you use Windows authentication.
|
Password
| Password for the ERwin Data Modeler user name.
Leave this field blank if you use Windows authentication.
|
Model
| Model locator string for ERwin Data Modeler. Use the following format for Microsoft SQL Server:
mmart://<database name>/<path>/<model name>
Use the following format for Oracle:
mmart://<path>/<model name>
The model path is case sensitive. Specify the correct value based on the model path used in CA ERwin Data Modeler.
|
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:
|
Import relationship name
| Specifies how to import the relationship names from ERwin. Select one of the following options:
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:
Default is physical order.
|
Import owner schemas
| Imports owner schemas. Specify one of the following values:
Default is true.
|
Import diagrams
| Specifies how the Metadata Manager Agent imports diagrams. Specify one of the following values:
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:
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.
|