About Mapping Manager
Mapping Manager is the flagship product of AnalytiX DS – with a broad range of uses, its primary function is to facilitate better and faster delivery of projects and monthly releases through efficient ETL source to target mappings.
Mapping Manager automates the Pre-ETL data mapping process. Mapping Manager manages the data mappings through the entire life-cycle process (from start to production and through the release and maintenance process). We define the “Pre-ETL Data Mapping” process as the deliverables (commonly referred to as: Source to target mappings (STM), Interface control documents (ICD), Technical Requirements Documents) and the internal processes which manage the data mapping requirements process.
Mapping Manager is an automated framework with “bolt-on” add-on on modules and a customization framework which extends the tools capabilities above and beyond management of the data mapping process. With add-ons for:
Mapping Manager allows you to scan and import all source and target databases in just about any file format (XML, XSD, Excel, Flat Files, etc.), so that you can quickly understand the metadata, and begin to build your ‘Pre-ETL’ source to target data mapping designs using drag and drop features, and reusable business and transformation rules. We save you 50 to 70% of the time you would spend when compared to traditional means (spreadsheets) – above and beyond that, we also take your designs and generate code for all major ETL brands such as Informatica PowerCenter, Microsoft SSIS, SAP BODS, Talend, Oracle, etc. saving you time in the ETL processes as well! Our custom code-generation templates are widely used in populating industry standard models for Financial Services and Health Care / Life Sciences.
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 work-flows, increase productivity (especially over geographically dispersed teams) and give project teams, IT leadership, and management visibility into the ‘real’ status of integration and ETL migration projects across the enterprise.
ETL Documentation: Looking for easy way to document all your complex ETL jobs and ETL job Logic? Look no further. Mapping Manager is purpose built to document and manage all your complex ETL logic. Mapping Manager can create your ETL requirements documents or reverse engineer existing ETL jobs and auto-document existing ETL job logic within Mapping Manager built in web based repository or alternatively utilizing CATfX automation we can integrate the metadata with third party or custom built in-house applications.
- Auto-Mapping of Source to Target Columns
- Impact Analysis and Data Lineage
- easy-to-use drag and drop GUI interface
- Versioning of the data mappings & Metadata.
- Scan & Import System Metadata
- Dynamically scan-in the metadata into the repository
- Auto Generate ETL jobs for leading ETL Tools
- Define, share and reuse enterprise Transformations
- Easily Import your Legacy Spreadsheets
- Preview data Capabilities from Metadata Browser
- Role Based Security
- Supports many to many relationships
- Track the status of mapping specifications
- Manage Enterprise Transformations at a governance level
- Built in Metadata scanners for all major database vendors
- Reuse and share routine transformation logic
- Improve your data governance & transformation processes
Mapping Manager Big Data Edition enables organizations to reduce costs & accelerate project delivery by automating the big data mapping process thereby making it faster, more manageable & collaborative while auto-generating ETL jobs for leading ETL tool providers. Mapping Manager for Big Data bridging the structured and unstructured data sources to meet your big data challenge.