Erwin Resource Configuration

Before you configure your scanner, make sure you meet the prerequisites. Read our guide on Erwin integration requirements to double-check.

Source System Properties

This configuration can be setup by creating a new connection on Admin UI > Connections tab or editing an existing connection in Admin UI / Connections / Data Integration Tools / Erwin / specific connection. New connection can also be created via Manta Orchestration API.

Property name Description Example
erwin.system.id Enter the name of a resource representing this erwin system (a set of erwin models sharing a database connection configuration, used as an input subdirectory containing the models and their connection settings) system_name

Common Scanner Properties

This configuration is common for all Erwin source systems and for all Erwin scenarios, and is configure in Admin UI / Configuration / CLI / Erwin / Erwin Common. It can be overridden on individual connection level.

Property name

Description

Example

erwin.input.dir

Directory with manually provided erwin systems

${manta.dir.input}/erwin/${erwin.system.id}

i.e. \mantaflow\cli\input\erwin\system_name\models

erwin.models

Subfolder of ${erwin.input.dir} containing erwin models to extract

models

erwin.connections.ini

The .INI file in ${ erwin.input.dir} where the connections to databases that correspond to physical models are defined.

The format of the .INI file and the processing of the specific connection are described in (Manual) Connection Mappings Explained.

The name of a physical model is specified in the XML model file under the the EMX:Model/ModelProps/Name property.

An example of a defined connection in the .INI file is:

[Erwin_Model_Example_1]

Connection_String=jdbc:db2://192.168.26.1:1000/DB

Type=DB2

Server_Name=

Database_Name=

Schema_Name=

User_Name=

connections.ini

erwin.files.encoding

Encoding of the input erwin XML-based model files See Encodings for applicable values.

UTF-8

filepath.lowercase

Whether paths to files should be lowercase (false for case sensitive file systems, true otherwise)

true

Dataflow Generation

To generate lineage over erwin objects, Open Manta Interpolation needs to be configured and executed. This configuration is independent of the erwin configuration. For a detailed description, see Open Manta Interpolation Configuration.