Automates data mapping throughout the enterprise data integration lifecycle. Providing data visibility, lineage and governance.
erwin Mapping Manager (MM) provides data visibility, lineage and governance throughout the data integration lifecycle. Leveraging erwin MM can eliminate 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. 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.
Use Source and target systems metadata to accelerate the creation of source-target metadata-driven mapping, eliminating manual work and costly errors seen with traditional approaches
Instantly indentify the impact of change to an attribute or table across the warehouse in a matter of seconds, saving valuable time and resoruces
Using plug-in SDKs, customize code generation to meet customerspecific requirements, automating manual tasks, accelerating delivery and reducing rework.
- Automatic generation of data integration components for Informatica, DataStage, Talend, SSIS, Pentaho, ODI, OWB, BODS and others based on job design best practices.
- Reverse-engineer ETL/ELT components into mapping documents and lineage documentation.
- Automate data vault hub, link and satellite code generation.
- Generate SQL code, stored procedures and DDLs from metadata to build warehouses and marts.
Efficiently transform and move data in tight alignment with business-driven requirements from a single, unified platform.
Synchronize metadata with core data management and governance capabilities and artifacts in real time.
Reverse-engineer ELT, ETL, procedural and other code for more intuitive lineage, plus standardization, reuse and migration across the spectrum of data integration platforms.