Analytix: Mapping Manager
 |
Our Mapping Manager is the first enterprise software in the integration industry which brings standards, management, and collaboration to one of the remaining areas in the industry which is untouched by product: pre-ETL Data Mapping Specifications. ETL, QA, profiling and requirements phases all have their tools, but there are none of any consequence in the mission-critical, error-prone pre-ETL data spec/mapping phase of large implementations. MS Excel currently occupies the space, but does it very poorly and the Mapping Specs cannot be managed or versioned appropriately for system integration projects. With the onslaught of products servicing integration, it's hard to understand why this gap persists, but it does. We see it as the Achilles Heel of integration and the last area of the ETL Suite of tools that is not yet integrated with the ETL tool vendors.
|
Analytix: Mapping Manager brings standards, control, auditability, traceability and versioning across all integration projects at the enterprise level. The 3.0 planned release is targeting the integration of the Mapping Specs directly with the market leaders in ETL to provide a direct integration point with the mapping specification requirements to the ETL jobs.
Detailed Description
Mapping Manager is 100% metadata driven and is used to define and drive standards across integration projects within an enterprise, enable data & process audits, improve data quality, streamline downstream workflows, increase productivity (especially over geographically dispersed teams) and give project teams, IT leadership, and management visibility into the 'real' status of integration projects across the enterprise.
Mapping Manager is a complement to existing products and allows the business analyst to dynamically build mapping specifications (via drag and dropping of metadata from the metadata browser) which become clean, approved requirements/ inputs to ETL developers. These specifications are then versionable, trackable, auditable, and repeatable throughout the lifecycle of integration projects.
Mapping manager is rich in function. Its advanced built include Impact analysis and data lineage views across the enterprise, upload client SDM and other documentation ( at the project, system and individual mapping specification levels for compliance and tracking), defines mapping rules & standards, analyzes upstream and downstream system impacts, and features a metadata browser which enables uploading of source system data tables from all DB platforms (at the catalog and metadata level). In addition, the tool carries special handling instructions for sensitive data requiring encryption such as SOX, HIPPA, GOV etc.
The development platform is 100% web enabled (no fat client) Java Eclipse based and the GUI features a full range of excel like features and drag and drop functionality. Mapping Manager complements existing integration products and vendors, and is non disruptive to existing team structures, role or responsibilities. Analytix Mapping Manager was born out of systems integration specialists and their direct culumalitve 15 years of experience working with ETL Tools and the gaps and weaknesses in the data mapping specification area and seeing many full lifecycle integrations projects through to completion. The product was designed and developed to not only fill the GAP of having the ability to manage and version mapping specifications, but to also streamline and improve current process and drive standards around the entire process and across the enterprise for all integration projects.
