erwin Mapping Manager

Automated metadata-driven mapping and code generation

Here’s to data visibility, lineage and governance throughout the data integration lifecycle. Oh, and did we mention eliminating manual work and costly errors along the way? With erwin MM, you can automate enterprise data mapping and code generation for faster time-to-value and greater accuracy when it comes to data movement projects, as well as synchronize “data in motion” with your data management and governance efforts. Map data elements to their sources within a single repository to determine data lineage, deploy data warehouses and other Big Data solutions, and harmonize data integration across platforms. The web-based solution reduces the need for specialized, technical resources with knowledge of ETL and database procedural code, while making it easy for business analysts, data architects, ETL developers, testers and project managers to collaborate for faster decision-making.

Automate, Automate, Automate

Drag-and-Drop Mapping

Use source and target system metadata to accelerate the creation of source-to-target, metadata-driven mapping. This drag-and-drop approach eliminates manual work and costly errors as usually seen with a traditional Excel approach.

Universal Code Generation

With plug-in SDKs, code generation is automated and can be customized to meet customer-specific requirements, accelerating delivery and reducing rework. This includes code generation of data integration components; data vault hub, link and satellite; and SQL code, stored procedures and DDLs to build warehouses and marts; and reverse-engineering of ETL/ELT components into mapping and lineage documentation.

Impact Analysis, Version Management & Change Control

Instantly identify the impact of change on an attribute or table across the warehouse, saving valuable time and resources. With built-in versioning, baseline and archive all mapping documentation and view change comparison reports over time.

Upstream & Downstream Data Lineage

Generate end-to-end lineage between repositories and view data flows from source systems all the way to the reporting layers. This includes all intermediate transformation and business logic so stakeholders have the information they need to make swift decisions.