Transform Your Business with Data Mapping, Governance & Automation Tool
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.
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.
Mapping Manager brings out-of-box features that offer incredible value to any data management organization. Key Features of Mapping Manager
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.
20 to 50% savings on ETL with code-gen templates: Our out of the box code generation will save up to 20% in the process by automatically creating your job layouts –take that number higher with custom templates that take your jobs to 70% complete and beyond.
Versioning is the one which differentiates between maps. It offers versioning at mapping level and at project level something impossible with spreadsheets.