Architecture

To get you started with erwin Data Intelligence Suite (DI Suite), this topic gives you an overview of erwin DI Suite architecture and its modules. The following diagram shows a high-level architecture and data flow.

The following sequence gives a high-level understanding of how the modules interact in a typical data integration project:

  1. Scan metadata from data sources.
  2. Create business assets and associate them with technical assets.
  3. Create source data to target data maps, and track data flow and transformations.
  4. Capture functional requirements.
  5. Associate requirements with mappings.
  6. Define codesets and perform code crosswalks (mappings).
  7. Associate code crosswalks with mappings.
  8. Validate and manage reference data.
  9. Associate reference data with Mappings.
  10. Generate code for:
    • ETL jobs
    • SQL scripts
    • Python code
    • Spark code
    • DDL scripts
    • Stored procedures

erwin DI Suite consists of 11 modules that are categorized as core and add-on modules.

  • Core modules perform the major functions of erwin DI Suite offering.
  • Add-on modules offer additional functions on top of the core functions.
    The availability of add-on modules is subject to licensing.

The following table gives an overview of modules and their functions.

Module

Type

Function

Resource Manager

Core

Use the Resource Manager to add application users and create roles for them here. You can also manage access-level permissions.

Metadata Manager

Core

Use the Metadata Manager to harvest source or target metadata from a data source. You can run impact and lineage analysis to have better control on a data integration project.

Mapping Manager

Core

Use the Mapping Manager to perform source to target mappings. You can also link code mapping objects, reference data objects, and requirements to the mappings.

Codeset Manager

Add-On

Use the Codeset Manager to manage your enterprise and legacy codesets. You can perform code mappings (crosswalks) and manage them.

Reference Data Manager

Add-On

Use the Reference Data Manager to manage your reference data (tables). You can run validation rules on the reference data and perform data quality checks. Further, you can associate codesets with the reference data.

Business Glossary Manager

Add-On

Use the Business Glossary Manager to create, manage, and collaborate on common business vocabulary across the organization. You can also view lineage maps to understand how semantic definitions are related to physical data dictionaries, data mappings, and data lineages.

Requirements Manager

Add-On

Use the Requirements Manager to standardize functional requirements documentation. Further, you can link requirements with data mappings.

Test Manager

Add-On

Use the Test Manager to manage test specifications created under Metadata Manager and Mapping Manager.

Release Manager

Add-On

Use the Release Manager to release data mappings, database objects, and release notes to standardize the release process.

Reports Manager

Add-On

Use the Reports Manager to create statistical reports and evaluate your team's productivity.

Workflow Manager

Add-On

Use the Workflow Manager to manage Business Glossary Manager, Metadata Manager, and Mapping Manager workflows. You can also create custom workflows and monitor their execution.

For more information on erwin DI Suite's user interface, refer to the User Interface topic.