Enterprise Data Catalog Scanner Configuration Guide > Configuring Data Modeling Resources > Erwin
  

Erwin

Erwin is computer software for data modeling.

Objects Extracted

Enterprise Data Catalog extracts metadata from the following objects in an Erwin data source:

Resource Connection Properties

The following tables list the properties that you must configure to add an Erwin data modeling resource: The General tab includes the following properties:
Property
Description
Erwin Scanner Type
Select any of the following options to specify the erwin scanner type:
  • - Erwin 8.x File. Click Choose to upload a .xml file from which you want to extract metadata.
  • - Erwin 9.x File. Click Choose to upload a .xml file from which you want to extract metadata.
  • - Erwin 8.x Data Modeler (Single model from mart). Specify the following parameters if you select this option:
    • - Agent URL. URL to the Enterprise Data Catalog agent that runs on a Microsoft Windows Server.
      • Note: Make sure that you specify the URL in the following format: http://<hostname>:<connector_port>/MIMBWebServices
    • - Database type. Select the database server type configured for Mart Server, from the drop-down list.
    • - Database server. Specify the Mart Server to which you want to connect.
    • - Database Name. Specify the name of the database server to which you want to connect.
    • - Authentication. Select one of the following options based on the authentication mode configured to connect to the Mart Server:
      • - Server Authentication. Specify the user name and password to connect to the Mart Server.
      • - Database Authentication. Specify the database user name and password to connect to the Mart Server.
      • - Windows Authentication. Select this option to specify that the Windows authentication must be used for authentication of the database username and password to connect to the Mart Server.
    • - Model (Optional). Specify the erwin model locator string. Use the following format for specifying the locator string: mmart://<database name>/<path>/<model name>.
  • - Erwin 9.x Data Modeler (Single model from mart). Specify the following parameters if you select this option:
    • - Agent URL. URL to the Enterprise Data Catalog agent that runs on a Microsoft Windows Server.
      • Note: Make sure that you specify the URL in the following format: http://<hostname>:<connector_port>/MIMBWebServices
    • - Server Name. Specify the Mart Server to which you want to connect.
    • - Server Port. Specify the port number on the Mart Server that you can use to connect.
    • - Use IIS (Optional). Select this option if you have configured connecting to the Mart Server with Microsoft IIS Web Server. The port number is dynamically assigned for connections using an IIS Server. If an IIS Server is not used to connect, you must specify the Server Port number.
    • - Use SSL(Optional). Select this option if you have configured Secure Socket Layer (SSL) authentication to connect to the Mart Server.
    • - Application Name. Specify the name of the application to which you want to connect to on the Mart Server.
    • - Authentication. Select one of the following options to specify the authentication mode to use for the connection to the Mart Server:
      • - Server Authentication. Specify the user name and password to connect to the Mart Server.
      • - Database Authentication. Specify the database user name and password to connect to the Mart Server.
      • - Windows Authentication. Select this option to specify that the Windows authentication must be used for authentication of the database username and password to connect to the Mart Server.
    • - Model (Optional). Specify the erwin model locator string. Use the following format for specifying the locator string: mmart://<database name>/<path>/<model name>.
The Metadata Load Settings tab includes the following properties:
Property
Description
Enable Source Metadata
Select to extract metadata from the data source.
Import UDPs
Specify how you want to import property definitions and values User Defined Properties (UDP). 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 an object has no assigned value, ERwin assigns the default value of the property definition to the UDP.
You can select any of the following options:
  • - As metadata. Imports explicit values as Property Value objects. This option retains the default value on the Property Type and does not import implicit values.
  • - 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.
Default is As metadata.
Import relationship name
Specify how you want import relationship names from erwin:
  • - From relationship name. Use the relationship name property.
  • - From derived name. Use the derived name property.
Default is From relationship name.
Import column order from
Specify how you want to import the position of columns in tables:
  • - Column order. Imports the position of the columns from the order of the columns displayed in the erwin physical view.
  • - Physical order. Imports the position of the columns from the order in which the columns are stored in the database.
Default is Physical order.
Import owner schemas
Select this option if you want to import owner schemas.
Move entities to subject areas
Select this option to move entities to user-defined subject areas as conventional UML design packages with their own namespace.
Auto Assign Connections
Select this option to specify that the connection must be assigned automatically.
Memory
Specifies the memory required to run the scanner job. Select one of the following values based on the data set size imported:
  • - Low
  • - Medium
  • - High
Note: For more information about the memory values, see the Tuning Enterprise Data Catalog Performance article on How To-Library Articles tab in the Informatica Doc Portal
JVM Options
JVM parameters that you can set to configure scanner container. Use the following arguments to configure the parameters:
  • - -Dscannerloglevel=<DEBUG/INFO/ERROR>. Changes the log level of scanner to values, such as DEBUG, ERROR, or INFO. Default value is INFO.
  • - -Dscanner.container.core=<No. of core>. Increases the core for the scanner container. The value should be a number.
  • - -Dscanner.yarn.app.environment=<key=value>. Key pair value that you need to set in the Yarn environment. Use a comma to separate the key pair value.
  • - -Dscanner.pmem.enabled.container.memory.jvm.memory.ratio=<1.0/2.0>. Increases the scanner container memory when pmem is enabled. The default value is 1.