1 / 56

AnalytiX DS – Master Deck

AnalytiX DS Unified Software Platform for enterprise data mapping, governance and code automation manage data, metadata, data mappings and integration processes through the system development life-cycle (SDLC) process, enabling governance, automation transparency and lineage of the data in a single unified platform for data integration professionals

AnalytiXDS
Download Presentation

AnalytiX DS – Master Deck

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. AnalytiX Data Services October 2016 Unified Platform Introduction and Overview Governance Automation Enterprise Data Mapping For any questions regarding the contents of this presentation please contact us at info@AnalytiXds.com and we will assist you as soon as possible. The contents of this presentation are protected under NDA. All rights reserved by AnalytiX DS 2016

  2. Standard Agenda Standard Agenda • Introductions • Company & Unified Platform Introduction (15)Mins 1. AnalytiX DS Unified platform – governance & lifecycle management of the data mapping process • Capabilities Demonstration of Mapping Manager and Unified Platform (30mins) 1. Governance of metadata data dictionaries & business glossaries 2. Governance and versioning of source to target mappings through the lifecycle change process 3. Governance of Data Lineage, Impact Analysis and Business Rules Repository. 4. Code Generation - Generate Big Data & ETL Jobs and other types of CODE automatically from the tool. 5. Test Automation and Data Quality – Integration with HP ALM (Quality Center) Modified Agenda • Deeper Dive into LifeCycle Management Add-On Modules • Code Set Manager, Reference Data Manager, Test Manager, Release Manager, Data Quality Assessment Manager and Metadata Connectors • Deep Dive Into Automation Platform CATfX Automation Modules • CATfX Automation Platform & Code-Generator ETL Platforms & Other Technologies • Automation JumpStart Program • ETL Platform Conversion (LiteSpeed Conversion & Autonomy)

  3. Mapping Manager Big Data Edition The integration industry’s premier enterprise data mapping & automation platform AnalytiX Mapping Manager:  Create Mapping designs using scanned metadata and group  Categorize and Auto-Generate your ETL jobs  Maintain Version Control, Auditability, Impact Analysis & Lineage

  4. Snap Shot Founded 2006 Company Overview Offices HQ: Chantilly, VA USA USA: Development Center: Dallas, TX Global Delivery Center: Hyderabad, India Leadership 50+ years experience in Integration Partners/ Resellers Relations with Top 5 System Integrators and Off-shore Integrators 20+ Resellers Globally (HP Global Reseller) Market Leader Enterprise Data Mapping & Automation ETL Conversion Technology Employees More than 200 More than 1000 Customers Nearly 50% of Fortune 1000 Global Customer Base Global Government Install Base Innovation Award 20 Most Promising Productivity Tools Informatica, 2010, 2012 Winner CIO REVIEW –2015 Bloor Research, 2012 Informatica, 2012 “A Must Have Tool” Honorable Mention Most Valuable Partner

  5. AnalytiX DS Product Leadership Team Over 100 years of combined experience Madan Kalakuntla Managing Partner, Global Delivery Center Michael Boggs CTO and Founder • 20+ years experience in services delivery and off-shore operations • Invented the integration industry’s first enterprise data mapping tool, The Mapping Manager and the universal Code Automation Platform – CATfX • Responsible for global delivery center operations and services. 20+ years experience in Data Integration, Data Warehousing and BI Technologies • Responsible for all Aspects of Technology Innovation across AnalytiXDS software products • John Carter Director of Professional Services Sam Benedict VP of Strategic Accounts • 15+ years experience in Data Integration and Automation Services • 20+ years experience as a Data Integration Manager • Responsible for all aspects of Service Delivery and Conversion Technologies • Responsible for all sales and marketing for strategic customer accounts.

  6. Corporate Vision Corporate Vision Manage data, metadata, data mappings and integration processes through the system development life-cycle (SDLC) process, enabling governance, automation transparency and lineage of the data in a single unified platform for data integration professionals Process Driven Solutions for Integration Professionals Innovate, Automate, Accelerate

  7. AnalytiX DS Unified Software Platform Enterprise Data Mapping, Governance and Automation. Modules Add-on Modules 1. Business Glossary 2. Requirements Manager 3. Reference Data Manager 4. Test Manager 5. Data Quality Assessment Manager (DQAM) 6. Release Manager 7. Report Manager 8. Plug-Ins for metadata tools 1. CATfX Automation 2. CATfX Global Marketplace 3. Packaged Automation Bundles Big Data ETL, ELT Data Vault Mapping Manager (flagship product) 4. LiteSpeed Conversion Automated ETL platform conversion AnalytiX Mapping Manager Metadata Management Enterprise Data Mapping Add-on Modules SDLC Governance Open Automation Framework

  8. Unified Platform Product Product Summary Key Capabilities 8      Universal Platform for scanning, consolidating and managing Metadata across the organization. View Data Lineage and Impact Analysis across the organization while meeting regulatory compliance with industry regulators involving data mapping and lineage. Metadata Scanners for just about everything Capability to build custom scanners Govern and enrich Data Dictionary definitions End to End Lineage – view lineage across all hops across the data management architecture Impact Analysis across tables, columns, systems, business rules, projects, mappings & ETLprocesses Mapping Manager Metadata Management (AMM)  Mapping Manager Integration Industry’s first patented “Pre-ETL” enterprise data mapping solution. Enables organizations to create, version and manage source to target mappings (STM) through the change process and view end to end data lineage across the data mapping process and information management architecture. Scan, Drag, Drop, Build and version data mappings across the life-cycle processes. Export Mappings and Auto-generate ETLjobs for leading ETLTool providers and Hadoop Enterprise Data Mapping (AMM)   Enterprise Business Glossary Enables business users IT to create, manage and collaborate on common business vocabulary across the organization Supports regulatory compliance, data governance, and data stewardship initiatives by governing business vocabulary terms and enabling lineage maps showing how semantic definitions are related to physical data dictionaries, data mappings, lineage of federated data in a business friendly governance platform. Manage vocabulary term owners End to End lineage. Map semantic Business glossary definitions to physical data dictionaries, functional requirements, mappings test cases and more. Support for rich media such as: sound, video, and images files     Requirements Manger An agile and collaborative platform to standardize the functional requirements documentation process using a customizable template driven approach. Easily, create and customize requirements templates to standardize the capture, trace, and requirements definition process for integration projects. Rich features allow for management of functional requirements and how they “link” to data mappings, test cases, testresults to promote greater transparency and visibility of requirements process and downstream impacts. Capture, trace and analyse functional requirements Traceability matrix maps functional requirements to data mappings in mapping manager Reverse engineer requirements from MS Word | Export requirements to MS Word and other formats  Reference Data Manager Enables business and IT users to scan, manage, validate and version govern code-sets and reference data across the organization. Perform validation, link to mappings and integrate with ETLProcesses to ensure consistency across governed reference data. . Govern user defined reference data and code-sets in a single platform and link to requirements and data mappings. Integrate with ETLProcesses to standardize Lookup values , code crosswalks , ref data and more…     Enables Program and Project Managers to create, validate and manage releases, release calendars and release artefacts such as ETL Jobs, Data Mappings, Database Objects, Server objects, release notes and more to standardize all release processes and documentations standards around the release process. Create and Manage Releases, release schedules Audit and govern releases Edit, View and manage Enterprise Release calendars Release Manager (ARM)     Test Manager enables Test Cases and Test SQL generation to be managed in a purpose built module for testing data mappings and ETL processes. There are over 15+ built-in automation CATS which enable immediate creation of Test Cases and TEST SQL to accelerate the testing phase of integration projects. Create and Manage TestCases and Test SQL for Data Mappings and ETL Processes Auto-Generate TestCases & SQL from Data Mappings Create testcases at the column level of mappings or target tables Integrates with HP ALM (formerly HP Quality Center) Test Manager (TCM)     Data Quality Assessment Manager Enables organizations to standardize and execute a formal data quality assessment methodology by selecting the objects which should be assessed, scheduling the assessments, manage the data quality scores and workflow review process. Governance features manage data steward and stakeholder accountability for the quality reviews and sign-off. Govern valid values, invalid values, remediation rules and generate scripts to “fix/repair” invalid data values. Standardize and Execute a formal Data Quality Assessment methodology Select which columns and objects should be assessed Schedule the automated assessment of the objects Track reviews and approvals of accountable stakeholders (DQAM)  Metadata ManagementPlug-ins Metadata plug-in are available for Informatica Metadata Manager, IBM Metadata Workbench/GDC, DAG metacentre and Rochade. This enables all the metadata in Mapping Manager Unified Platform to be ported into third party metadata environments. Metadata connectors for all ETLTools, Java Scripts, Cobol copybooks, Cobol Programs,Sales Force.com and more. All the metadata from Data Dictionaries, Data Mappings, Reference Data, CodeSets and Data Quality Assessments are synchronized in metadata management environments. Plugins exist for major third party systems Customization and support services are available   Code automation Templates (CAT’s) are pre-built to automate the code-generation for the Data Vault EDW methodology for Source to Stage, HUB, LINK, Satellites and Data Marts. The complete data vault bundle contains CATs to generate DDL, Data Mappings, ETL Jobs and processes for all major ETL tools including Hadoop and Standard SQL as well at Testing Cats to automate the testing process and data quality of the Data Vault. Code Automation templates are available to generate the following…  Data Vault tables structures  Data Vault data mappings in Mapping Manager  Data Vault ETLProcesses  Data Vault DBMS Views  Data Vault testcases Data Vault Code-Automation (DV CATS)     The integration Industry’s first Automation Platform for Data Integration Professionals. CATfX Defines Work Smarter. Save Big. Auto- generate ETL Jobs, Build Custom Adaptors and Connectors to anything, Scan Metadata and Generate code for anything using a 100% metadata driven approach to automation. The automation marketplace is a global marketplace for automation developers to post automation CATsfor the global community to browse buy, sell and download to automate manual process. Create or use templates to auto-generate ETLJobs Create or use templates generate DDL for table structures Create Custom Connectors to Scan metadata Create code generation templates for anything. Code AutomationTemplate Framework (CATfX) www.analytixds.com 10/18/2016 © 2014 Analytix Data Services. All Rights Reserved. © 2014 AnalytiX Data Services 8   The integration industry’s first ETL Conversion platform enabling a fast and automated way of converting from customer legacy ETL tools to the TALENDPlatform. Supports Customization to create “custom” conversion templates to customer needs/requirements Use built in re-useable conversion templates to convert to new ETLPlatforms LiteSpeedConversion (ALC)

  9. Where does AnalytiX DS fit in the ecosphere of software Where does AnalytiX DS fit in the ecosphere of software tools? tools? AUTOMATION TOOLS GOVERNANCE TOOLS

  10. Mapping Management & Governance of the SDLC process Integration with leading tool platforms • ETL Tool & Big Data Code Generation ETL • • • Compliments Testing Tools Generate Test SQL Sync Test Cases and Results ALM Center of the Universe Governance of the mapping process • Metadata Plug-in for Metadata Mgmt Tools IMM • Compliment & Integrates w/ MDM & DQ Tools • Identify Valid & Invalid Data • Design Cleansing Rules & Gen Code to Remediate IDQ

  11. By Project, By Team Role Use Cases for the unified platform By Project By Resource Role 1. 2. 3. Data Warehouse Big Data Application Consolidation and Migration 1. App Retirement 2. Mergers and Acquisitions 3. DBMS Conversion 4. Data Migration 5. ETL Platform conversion 6. Application Modernization & Tools Replatform 7. Cloud migration Regulatory Compliance & Mapping Standards Data Governance Data Quality Assessment Testing & Quality Assurance Metadata Management Master Data Management 10. Code Parsers to quickly document code 1. 2. 3. 4. 5. 6. 7. 8. Data Modelers (mapping data elements) Data Analyst, Mapping Analyst, Business Analyst Data Stewards & Data Governance Data Quality Analyst ETL and Big Data Developers QA Testers Release Manager & Project Managers Information Management Executives 4. 5. 6. 7. 8. 9.

  12. Information Governance Component Reference Model Compliance Regulatory Audit (mm) Data Quality Audit (dqam) IT Security Audit (mm) Information Governance – Component Reference Model Reference Data & Code-set Management (rdm) (mm) Data Steward & Workflow Management (mm) Data Dictionaries / Business Glossary (mm) Governance of Testing & Data Quality (tm) / (dqam) Data Lineage & Impact Analysis Governance of Mapping Specifications (mm) Governance of Releases (rm) Governance across the Systems Development Life-Cycle (SDLC) Process Data Mapping Rules (SDLC) Requirements Design Build Test Assess Data Quality Deploy Maintenance Business Mapping Analyst Developers Testers Data Stewards Release Managers Architect / Lead Developer Developers Testers Data Stewards / Quality Analyst Release Managers / Project Manager Business Analyst Mapping Analyst / Business Analyst Mapping Manager CATfX Automation Test Manager Release Manager DQAM Application Mapping Manager (mm) CATfX Automation (catfx) Test Manager (tm) Data Quality (dqam) Release Manager (rm) CATfX Automation (catfx) Reqts Manager (rqm) optional optional Reference Data Manager test automation via CATfX

  13. Compliance Regulatory Audit (mm) Data Quality Audit (dqam) IT Security Audit (mm) Information Governance – Component Reference Model Reference Data & Code-set Management (rdm) (mm) Data Steward & Workflow Management (mm) Data Dictionaries / Business Glossary (mm) Governance of Testing & Data Quality (tm) / (dqam) Data Lineage & Impact Analysis Governance of Mapping Specifications (mm) Governance of Releases (rm) Governance across the Systems Development Life-Cycle (SDLC) Process Data Mapping Rules (SDLC) Requirements Design Build Test Assess Data Quality Deploy Maintenance Business Mapping Analyst Developers Testers Data Stewards Release Managers Architect / Lead Developer Developers Testers Data Stewards / Quality Analyst Release Managers / Project Manager Business Analyst Mapping Analyst / Business Analyst Mapping Manager CATfX Automation Test Manager Release Manager DQAM Application Mapping Manager (mm) Mapping Manager (mm) CATfX Automation (catfx) CATfX Automation (catfx) Test Manager (tm) Data Quality (dqam) Release Manager (rm) optional optional Reference Data Manager test automation via CATfX Identify data source requirements Identify target definitions Scan and manage metadata definitions and dictionaries Manage or integrate with business glossaries Drag, drop build, version data mapping rules and transformations Govern re-usable transformation rules Manage reference data and code-set Mappings View data lineage and impact Analysis Data steward and workflow management Use, modify or create CAT templates Existing Big Data CATs Types of CATs ETL/ELT Jobs Generate DDL Parse files Read/Write to ESB Custom API connectors Metadata plug-ins Cobol Programs Java Programs Data Vault Bundles More… Click CATs & generate code from metadata  Generate DDL  Generate and unit test generated ETL/ELT Jobs  Generate and Test Big Data processes  Any code based on CAT template… Associate re-usable test cases to mappings and target tables Generate test SQL and comparative source and target SQL statements (19 test automation CATs) Create new test cases and link to mappings Execute test cases and capture test results Create new test automation (CATfX) Sync with industry standard test tools such as HP ALM and IBM Doors Manage data quality for high value and governed data values. Automatically scan and detect sensitive data. Assign data stewards & track DQ goals Create data quality schedules to profile data and conduct “value level” assessments Manage and maintain data quality scores Identify valid values for master data management Identify values which require remediation Create, govern and audit the release management process Manage data mappings and release objects for every release Customize release objects forms to your internal standards Audit release approvals and validation checkouts Yearly, monthly, weekly and daily release calendar views Mapping Maintenance. As new columns, tables, data source are added the mappings can be versioned,. maintained, compared to previous versions Code Changes. Regenerate Code for New Mappings Regression Unit Test. Regenerate Test Cases/Test SQL Release Management. Manage releases and release Objects Continuous Data Quality Monitoring of scores        Capability                       Data Vault Template  STAGE/HUB/LINK/SAT/ ESB     Data Mart Template SCD1,2,3 FACT Load   

  14. Accelerate Timelines Unified platform offers accelerated timelines and governance of the across the SDLC Timeline SDLC Requirements - Requirements and Data Manual with Mapping Manager 50% Faster Mapping Design - Creating & Enforcing ETL/ELT and Big Data Job Design Standards with Mapping Manager + CATfX 60% Faster Manual Manual with Mapping Manager + CATs 60% Faster Build - DDL, ETL/ELT and Big Data Integration Jobs Test – Construct Test Cases, Comparative Test SQL, Execute & Manage test runs Manual with Test Manager 50% Faster Data Quality - Assess and Manage Data Manual with DQAM 50% Faster Quality Manual with Reference Data Manager 50% Faster Data Quality – manage enterprise reference data, codesets and validation rules Deploy – Manage releases and release Manual with Release Manager 30% Faster objects Data warehouse modernization – platform migrations Database Platform Migration Manual with unified platform 50% Faster ETL Platform Migration Manual with unified platform 50% Faster Data Vault Platform Migrations Data Lake Automation Manual with unified platform 50% Faster

  15. Benefits of the Platform Benefits of the Platform Enterprise Data Mapping, Governance and Automation Platform 15 Key Benefits of the Platform 50% Faster 5X Better Results 60% Faster 50% Faster Improved Governance & Data Quality Test & Data Quality Standardization & Acceleration Development Standardization & Acceleration Design Standardization & Acceleration Test Manager CATfX Automation Standardization using CAT Code-Gen templates Mapping Manager Enterprise Data Mapping Platform DQAM Standardization using CAT code- gen templates (19 test automation templates Data Quality Assessment Manager Reference Data Manager Reference Data, CodeSets Mgmt, Validation Rules Flexibility and Adaptability – Create a Code Automation Template for Virtually ANY Process Integration with HP ALM & IBM Doors Release Manager Data Quality Assessment Manager Any Technology Platform ETL Tools platforms, Big Data, ANSI SQL Etc Improved governance and control of managing release approvals and release objects Perform Data Quality Assessment and govern data quality scores Big Data SPARK SCOOP PIG PYTHON HSQL MAP REDUCE Standardization Metadata X-Connects Plug-ins for Metadata Management Tools Scan data objects and identify and govern sensitive and protected data based on customizable pattern analysis Mapping Manager Governance of Mapping Designs Data Lineage Impact Analysis www.analytixds.com © 2014 Analytix Data Services. All Rights Reserved.

  16. Benefits • Deliver faster & better with higher quality deliverables • Reduce project risks and big data management costs • Deliver instant business value and improve Governance Across the SDLC process • Standardize and accelerate ETL processes with reusable templates • Standardize and accelerate Testing processes with reusable templates • Global visibility into enterprise projects • Improve performance by adopting and generating Hadoop Scripts • Generate Code and deliver faster with built-in design standards • Focus on standards and process improvements • Meet regulatory, compliance and process audit • Build repeatable processes and solutions • Assess & Govern Data Quality Scores • Transform Big Data into useful data • Gain Better Control and Management of data glossaries and the data mapping process

  17. Over 1,000 Customers and growing…. Large International Customer Base

  18. What are our referenceable customers are saying about AnalytiX DS? With AMM and CATfX Automation, we were able to reduce overall project duration by close to 25% and cost by close to 35%.Our deliverables have also improved considerably due to fact project resources now have a common interface to a centralized metadata repository which provides us with complete process, flow and version control capability. AnalytiX DS have been extremely responsive to our enhancement requests and have one of the best turnaround times in the industry. This was best demonstrated in the manner in which AnalytiX DS built a custom plugin that integrated with one of our critical MDM solutions. We have successfully completed and delivered various project initiatives using the AnalytiX Mapping Manager. The Data Lineage and Impact Analysis have been our biggest challenges over the years and Mapping Manager helped us close this gap instantly. We now have wider and accurate visibility into the upstream and downstream dependencies thus helping us make quicker business decisions. Mapping Manager has provided us with a platform to use our intellectual property more effectively and provide greater visibility to the business across the Organization and the response of the support has been the best we have seen in the industry.

  19. What are our referenceable customers are saying about AnalytiX DS? (Contd.) Mapping Manager has been the most widely accepted tool and the fastest tool that we have rolled out to our internal IT and business users. The AnalytiX toolset is an accelerator for data integration projects involving metadata and data mapping. The tool makes a valuable contribution in managing enterprise metadata and data mappings and facilitates the efficient turn-over of project deliverables to our clients. The Lineage Analyzer and Impact Analysis features have been key features that have helped us realize instant ROI on the product. We have found this to be the only product in the market that caters widely to the Mortgage and Financial sectors and MISMO in particular. The tool provides an array of features that create and govern the data flow and help maintain the mappings and lineage between different MISMO releases. The mappings standards help newer model versions to be easily integrated into the tool and maintain the new changes with greater visibility across the organization. We use the product to Map hundreds of data sources and generate informatica jobs to accelerate our delivery process.

  20. What are our referenceable customers are saying about AnalytiX DS? (Contd.) Featured Government Customers Mapping Manger has helped us govern our mapping for our Enterprise Data Warehouse and alert us to impacts downstream before they occur We use the AnalytiX DS Unified platform in our Enterprise Data Warehouse to govern Source to Target Mappings, CodeSets, Reference Data and integration test management. We are able to view complete end to end linage of all data elements across the EDW. The AnalytiX DS team has been incredible responsive and receptive to our needs. We have watched our feedback evolve into product enhancements over the past 3 years. We now have a product that governs every phase of the SDLC. We have used AnalytiX DS ETL platform conversion to convert legacy ETL jobs to new a new modern ETL platform. The platform as services offered support for all major ETL tools and a delivery guarantee with a fixed price conversion model making AnalytiX DS a one-stop-shop for our ETL platform conversion needs. We use the product to Map hundreds of data sources map and version data sources to our Enterprise Data Warehouse.

  21. 21 CATfX Automation JumpStart Program CLOUD enabled Automation Platform designed for integration Professionals Program Details 6 Week Program Software + Services Bundle Focused on-Site Automation SWAT team Guaranteed ROI ETL/ELT Standardization & Automation Governance JumpStart Decode the Past : Scan and Organize Data Dictionaries • ETL Tool Integration to Standardize design patterns • Stage load, SCD Dimensions Type 1, 2 & 3, Fact etc patterns • Big Data: Generate PIG, Scoop, MapReduce and Python scripts • Big Data: Scan Metadata from HDFS, HIVES and other Eco-sphere systems • And more … • Scan File Metadata • Scan Modeling tool Metadata • Scan SQL Procedures • Scan ETL Jobs as Mappings • Configure custom connectors • Sync with 3rdparty tools such as managed metadata tools • And more … Big Data Standardization & Automation Testing Automation • Generate Test Cases • Generate Test SQL • Generate Validation Scripts • And more … Generate a Data lake in 6 Weeks Generate a Data lake in 6 Weeks • Generate ETL Jobs in Hadoop from leading ETL tool providers • Big Data: Generate PIG, Scoop, MapReduce and Python scripts • Big Data: Scan Metadata from HDFS, HIVES and other Eco-sphere systems • And more … Custom Code Automation • Generate DDL • Generate any type of script in any language or technology • Generate any type of file • And more … www.analytixds.com © 2014 Analytix Data Services. All Rights Reserved.

  22. Code Automation Template Framework (CATfX) – How it works The universal code-generator for data integration professionals Governance and Automation Platform Universal Code Generator Code Automation Template Framework (CATfX) CATs are configured using a 100% metadata Driven Approach. Configured CAT, reads metadata from repository, infrastructure, file data, applies code-gen logic and generates code based on the logic configured in the CAT. File Export From CAT generates code in the SDK format of target System Big Data: Integrated Development Environment (IDE) Scripting language under support Java | Java Script | Jython | Groovy | XSLT Execution and Run-Time Management execution and runtime is managed within the target system as it is normally done today. Business as usual for system administrators, job monitoring, backups, code versioning systems etc. AnalytiX DS – Unified Platform for Governance Business Glossary Manager Reference Data Manager Data Quality Manager Any Code Any Platform Mapping Manager Metadata Manager Customer Infrastructure Layer (DBMS, Files, System, Code, ETL Tools, ESB, Hadoop etc)

  23. Hubs Links PIT Bridge Satellites Data Storage Layer

  24. Mapping Management & Automation using CATfX Automation Bundles Big Data – Data Lake ETL, ELT Integration Data Vault Hub SPARK Gen Stage DDL Integration Bundles Link Scoop Source 2 Stage Satellite PIG Stage 2 Data Mart Universal Code-Generation using CATs Import generated code into the respective technology platforms

  25. FAQ on CATfX Automation 25 What types of things can be automated using CATs? • Dynamically Create Mappings in Mapping Manager Dynamically Create Mappings in Mapping Manager – – Save time of Mapping Designer (Auto • Dynamically generates metadata sources and connections in Mapping Manager Dynamically generates metadata sources and connections in Mapping Manager • Generate DDL for the target DBMS Generate DDL for the target DBMS • Generate ETL Jobs to Standardize job design patterns and standards and accelerate ETL Generate ETL Jobs to Standardize job design patterns and standards and accelerate ETL • Standardize Job Design Standards: ESB and message Queues, Stage load, SCD Dimensions Type 1, 2 & 3, Fact etc patterns • Big Data: Generate PIG, Scoop, MapReduce and Python scripts • Generate Test SQL (Test Manager) • Generate Data Profile Scripts/Reports • Generate Data Quality Scripts/Reports (DQAM) • Generate data validation Scripts/Reports • SQL parsing and Conversion • Shell Script Parsing and Conversion • Cobol Copybooks and Program conversions • More…. Save time of Mapping Designer (Auto- -map) map) What is the Quality of the Code Generated? • High quality – your architects and SME’s review and approve the CAT designs • CATs have standardization designed into them – they are TEMPLATES What is the level of Acceleration? • It depends on the CAT and the process we are automating. Certain CATs will have a higher Rate of return on Acceleration Who Creates CATs and What Skills are needed? • Your developers who are skilled in scripting languages or ETL tools can create CATs • AnalytiX DS – Offers CAT developers as a service, 3mos of automation CAT services is bundled with the automation package pricing designed to train and accelerate and jumpstart your integration project. www.analytixds.com © 2014 Analytix Data Services. All Rights Reserved.

  26. Mapping Management & Automation using CATfX Automation 26 Information Management Job Step Architecture Data Sources Support for any source Accelerate and Standardize development process for every job step of the architecture and accelerate downstream process. Report Layer Outbound Data Files ESB Other EDW 3NF Data Marts Stage/IDL landing Facts Dimensions SDLC Workflow Acceleration SOA/ESB Developers < XML > Mapping Analyst Hadoop Developers - Gen DDL - Generate Mappings Testers JSON - Gen ETL Jobs - Version & Maintain Mappings Data Stewards WORFLOW ACCELERATION - Gen Big Data Jobs - Gen Test Cases IoT - Gen Test SQL - Manage Data Quality Scores - Unit Test Jobs - Analyze Lineage & Impact Analysis - Manage Test Results - Manage Data Quality Rules - Govern Business Glossaries and Definitions www.analytixds.com © 2014 Analytix Data Services. All Rights Reserved.

  27. Data Vault Automation Platform A complete platform to universally generate any code and accelerate each phase of the SDLC process UNIFIED PLATFORM Governance and Compliance Mapping & Metadata Management (MM) Enterprise Business Glossary (EBG) Manage Reference Data ---- Reference Data Manager (RDM) Manage Test Results ---- Test Manager (TM) Manage Requirements ---- Requirements Manager (RQM) Manage Codesets ---- CodeSet Manager (CSM) Manage Release ---- Release Manager (RM) Manage Quality Scores ---- Data Quality Assessment Manager (DQAM) DATA VAULT AUTOMATION Data Vault Automation Bundle (10 CATs) Design Accelerators (4) ---- DDL & Mapping Generators Build Accelerators (6) ---- ETL/ELT Generators Test Accelerators (15+) ---- Test SQL Generators ETL Code Generation is avail for all ETL platforms and standard SQL to automate the Data Vault 1. Source 2 Stage 2. Hub Generator 3. Link Generator 4. Satellite Generator 5. Point in Time (PIT) Generator 6. Bridge Generator Over 15 test automation CATs available in Test Manager to automate and accelerate testing phase 1. Metadata Structure Testing 2. Data Completeness Testing DDL generation and Mapping generation CATs are available to automate the design phase 1. Generate Stage DDL 2. Automap Source to Data Vault ------------------------------ 3. *RapidVaultModel 4. *RapidSQLViews METADATA LAYER 100% Metadata Driven Approach to Automation

  28. Data Vault Load Process Architecture Code Generation: 5 Step Process for loading Raw Vault, Business Vault and Data Marts Data Sources Data Vault Load Process Architecture 4 3 2 1 Process Groups: Source 2 Landing | Landing 2 Stage | Stage to Raw DV | Raw DV 2 Business DV LANDING STAGE 5 DM1 Raw Business Data Vault Bus DV 2 DM2 DM2 Data Vault any Hub / Link / Satellites Pit / Bridge DM3 DBMS

  29. Governance & Automation enabled across phase of the SDLC process CATfX Data Vault Automation Bundle 29 Data Vault Automation Data Sources Support for any source Accelerate and Standardize development process for Data Vault and accelerate downstream process. Report Layer Outbound Data Files ESB Other Data Vault RAW DataMarts Business Stage Hub Link Satelite SOA/ESB SDLC Workflow Acceleration Designer / Developers < XML > Mapping Analyst Hadoop Developers - Gen DDL - Generate Mappings JSON Testers - Gen ETL Jobs - Version & Maintain Mappings WORFLOW ACCELERATION Data Stewards - Gen Big Data Jobs - Gen Test Cases IoT - Gen Test SQL - Manage Data Quality Scores - Unit Test Jobs - Analyze Lineage & Impact Analysis - Manage Test Results - Manage Data Quality Rules - Govern Business Glossaries and Definitions www.analytixds.com © 2014 Analytix Data Services. All Rights Reserved.

  30. Automation JumpStart Program Sprint week 1 week 1 week 2 week 5 1-4 Discovery Build Plan Requirements Production Rollout  Create Road-Map  Build detailed requirements for prioritized roadmap items  Discovery & Analysis  Review Information Management Architecture - Tools - Technologies - Infrastructure  Establish Success Criteria & ROI  Install and configure Mapping Manager + CATfX Automation Framework. (cloud/local)  Implement Roadmap  Test & Review automation CAT outputs and measure against success criteria. - CAT 1 - CAT 2 - CAT 3  Determine metadata sources required to meet automation  Automation RoadMap. Establish roadmap and LOE/ROI/Success Criteria  Obtain Design Approval for CATs  Review architecture diagrams - ODS /EDW/DatMarts/EDW - Testing - Profiling - Conversion Projects - BigData - Data Virtualization - Etc.  Identify candidate opportunities for automation  Prioritize areas based on ROI (Delivery Guarantee – ROI by end of work effort)  Obtain architectural endorsement of application.  Calculate Time Savings  Examples: - Define ETL patterns to Standardize ETL jobs auto- generate ETL Jobs - BIG DATA - Define repeatable test cases and scripts. - Utilise CATfX to push field / table definitions into STAGE/EDW - Integrate with Metadata Mgmt tools - Utilise CATfX to maintain/integrate reference data  Obtain Approval on Prioritized CATs  Establish connectivity to required systems: - ETL Repository - ERwin - DBMS - EDW Glossary - Metadata Manager  Identify Metadata / Reference data requirements (table / field level). Activity  Calculate Cost Savings  Calculate ROI  Seek GO/NO GO Approval for next phase of automation RoadMap  (1) Automation Expert  (1) Automation Expert  (1) Automation Expert  (1) CAT Developer  (.5) ETL Expert  (1) Automation Expert  (1) CAT Developer  (.5) ETL Expert Resourcing Effort 3 days 2 days 5-20 days 5 days 10/18/2016 30 © 2014 AnalytiX Data Services

  31. CAT CAT Name: SSIS CDC Stage CAT CAT Objective: Automate the Source to STAGE ETL Process using CDC logic with SSIS CAT Description: Create a reusable cat to automatically point to Source, read tables and generate SSIS jobs with CDC component and error handling configured. Measure Success criteria CATfX JumpStart Automation SUMMARY Capability Evaluation Criteria Actual Measurement Criteria CAT 1: Standardize ETL Processes   ACTUAL ROI: ________3month _______6month _________12month There expected costssavings for the CAT is expected to be: ESTIMATED ROI: ________3month _______6month _________12month Appropriate ROI period. ( GOAL Immediately at Production) Tangible reduction in SI design / build effort; agreed by vendor . Cost Savings Across the following Projects: XX XX XX Across the following Projects: XX XX XX  The estimated time savings is expected to be : ______________. The actual time savings is : ______________ Time Savings ETL Jobs: The CAT is expected to automate the following ETL jobs acrossthe following systems: • System 1: 200 tables/Jobs • System 2: 300 Tables/jobs • Total 500:Jobs to automate (phase 1) The Automation template will be re-usable for ongoing development and other projects. Scope of Automation  Suitability of this approach for a significant proportion of EDW/DataMigration loads. Evaluate fit for EDW, DataMigration, DataConversion, other Integration Projects Coverage    Adherence to EDW standards and guidelines within automation scripts / output. Naming standards. Datatypes. Loadpattern. Standards    The solution is able to be supported and maintained going forward. Defined and accepted support model. Support / maintenance costs included in ROI calculation. Stakeholder agreement on any additional or changed processes, Support  Able to be incorporated into the existing EDW environment and processes without requiring additional operational overhead. Should not radically change existing processes. Simplicity  Ensure the benefits provided by the automation can be fully leveraged within the design patterns and operating model. Solution should be easily applied and adoptable by integration and business users Operating Model            Able to perform the technical functions expected of the tool. Tool installed and accessible by project team. Mapping template able to cater for SI transformations / derivations. Mapping template able to be used to produce interface specifications. Mapping template able to capture metadata. Metadata able to be propagated to downstream systems: Template able to reflect SI load pattern. CATfXable to reduce the build time for each table. Unit tests able to be generated via AMM. Integrates with existing tools and processes. Workflow / collaboration tools able to reduce time to review / signoff. One touch generation -> jobs and workflows, unit tests, imported into repository. Functionality 10/18/2016 31 © 2014 AnalytiX Data Services

  32. CATfX Automation Framework CATfX Automation Framework(CATfX IDE) Compile & Preview Results Integrated Debugger Scripting Languages Code Editor w/ versioning

  33. MAP & AUTOMATE the Data Migration PROCESS MAP & AUTOMATE the Data Migration PROCESS Create Mappings & use the universal code Create Mappings & use the universal code- -generator to Generate Code and accelerate the data integration process for complex data generator to Generate Code and accelerate the data integration process for complex data migrations migrations Code Generation More… Extract Map & Transform Generate Code Scan Sources & Targets Create or Upload Mappings Generate ETL Jobs From Mappings System Metadata • Stored Mappings Data Set files back to the legacy source are stored Defined Properties ERwin files. Export PRODUCTION READY ETL Jobs and Generate Mapping & Transform Logic • Mapping logic between Source Data Set and Legacy Schema are stored in .xls mapping files in ERwin from files. Source systems in User of

  34. Proof of Concept Process Getting Started is FREE Getting Started is FREE - - Evaluation License and a supported Proof Evaluation License and a supported Proof- -of of- -Concept! Concept! View, Edit and Manage Mappings OUT OF SCOPE CAT Configuration Recommendations SME sends examples of mappingsAnalytiX DS Automation Assessment Engine POC Team AnalytiX DS +1 Customer SME IN SCOPE Unit Test ETL Jobs and Run Test Automation Customizing CATs “Requires Paid POC” Auto-Generate ETL UAT 34 www.analytixds.com

  35. Data Vault Recommended Proof of Concept Process Getting Started requires a dedicated support team to ensure success of all deliverables and answering of all questions Getting Started requires a dedicated support team to ensure success of all deliverables and answering of all questions Setup Metadata Scans, Generate DV Model Generate and Create DV Mappings NO Modify DV Automation CATs POC Kickoff Planning POC Team Customer Sponsor +1 Agree on Scope (recommended 25 Source Tables) Architecture Review (Assess modification to CATs) AnalytiX DS (4) Data Vault Sme + 1 Mapping Analyst +1 ETL Developer +1 CAT Developer +1 YES 1. Dan Linstedt Certification of DV CATs 2. Unit Test ETL Jobs and Run Test Automation Implement Data Vault (Generate Code Deliverables and schedule loads) Data Vault DDL Data Vault Mappings ETL Processes for: Source to Stage, Hub, Links, Satellites Generate Test Cases in Test Manager Auto-Generate Code UAT www.analytixds.com 35

  36. UNIFIED PLATFORM MODULE OVERVIEW Key Features and Benefits

  37. Enterprise Business Glossary Enables business users IT to create, manage and collaborate on common business vocabulary across the organization Supports regulatory compliance, data governance, and data stewardship initiatives by governing business vocabulary terms and enabling lineage maps showing how semantic definitions are related to physical data dictionaries, data mappings, lineage of federated data in a business friendly governance platform. BENEFITS KEY FEATURES Promotes data quality and governance participation and collaboration in a web based business friendly platform Collaborate and manage business terms, acronyms definitions and enrich with rich media definitions such as images, videos, sound-files and more Map semantic business definitions to physical data dictionaries and view relationships and lineage Enables greater control and visibility for all major stakeholders and the business though an integrated workflow process Manage Data Stewardship Roles, Responsibilities, Assignments, goals Promotes collaboration and establishes relationships between semantic business terms and physical data dictionaries Associate Business Terms to Technical Metadata, requirements, mappings, test cases, KPI’s and more via integrated relationship manager Manage your Data Stewardship Program Roles, Responsibilities, goals and ownership Publish Business Terms to the business community Integrated Project Management & Workflow capabilities Assign Roles and Responsibilities to data stewards and business users Generate end to end semantic and data lineage views Helps promote a robust Data Governance and Stewardship program through organizational collaboration between data stewards and the business. Integrated collaboration center enables enterprise collaboration and promotes data governance programs Integrated Reporting and Import/Export Features Business friendly web user interface

  38. Requirements Manager An agile and collaborative platform to standardize the functional requirements documentation process using a customizable template driven approach. Easily, create and customize requirements templates to standardize the capture, trace, and requirements definition process for integration projects. Rich features allow for management of functional requirements and how they “link” to data mappings, test cases, test results to promote greater transparency and visibility of requirements process and downstream impacts. BENEFITS KEY FEATURES Build Repeatable Requirements Documentation processes based on your best practices Standardize the requirements documentation process using customizable “requirements template” to capturing requirements Helps capture and standardize rapidly changing requirements Capture various Artifacts/Specifications beyond Requirements Link Requirements to Mappings. Test Cases and Test Results Promotes greater visibility and collaboration surrounding the requirements management process and downstream SDLC processes Integrated Workflow & Approval Management Process Enterprise Level Traceability between Requirements, Mappings, Test Cases and Test Results Dynamic association of KPIs around Requirements Create and Publish an reusable enterprise Requirement Specification template for the business Users to fill the requirements Integrates with the AnalytiX DS Unified Platform bringing together an efficient SDLC process Integrates with third party SDLC tools Import and Export feature for MS Word and MS Excel Files Integrated reporting and Requirement Traceability Matrix

  39. Mapping Manager Integration Industry’s leading “Pre-ETL” enterprise data mapping solution. Enables organizations to create, version and manage source to target mappings (STM) through the change process and view end to end data lineage across the data mapping process and information management architecture. BENEFITS KEY FEATURES Gain better control and management of enterprise data glossaries and the data mapping process Metadata driven approach to Source to Target Mapping Management and Code Generation Meet regulatory and compliance standards Data Lineage and Impact Analysis capability Seamless integration with your Organization’s methodology toolsets Version Management & Change Control Web based User interface. no hassles of deploying any software on the end user’s machine Collaboration and Workflow Management Accelerate the Pre-ETL mapping process by using the drag/drop feature to create mapping specifications. Using the metadata driven Drag/Drop approach eliminates scope for any human errors Reduce project risks and lower cost Enterprise wide visibility into Integration Projects Code Generation for Big Data & leading ETL/ELT Tools Deliver faster and better with higher quality deliverables Create reusable mapping templates to standardize the mapping process Robust automation framework to build repeatable processes and standards Code Generation for Data Vault Methodology Easily import Legacy Mappings Support for Agile and Iterative development Web user interface and roles based security to govern metadata, data dictionaries and govern Mappings, Codesets, Code Crosswalks and Reference Tables Eliminate duplicate efforts from silo project teams and loss of knowledge capital due to attrition

  40. Reference Data Manager Enables business and IT users to scan, manage, validate and version govern code-sets and reference data across the organization. Perform validation, link to mappings and integrate with ETL Processes to ensure consistency across governed reference data. BENEFITS KEY FEATURES Standardize and collaborate Codeset & Reference Data Management across the Enterprise Centralized Repository to create, version and maintain Codesets and Reference Data in a business friendly interface Manually add new codes and/or Import Codes and Reference Data directly out of databases or files Streamline Conversion between legacy and enterprise Codesets Gain better control and management over Codesets and Code Crosswalks Tightly govern the addition of new codes using the workflow management process Integrated Versioning and Publishing to handle the change management and parallel deployment processes Gain better governance, control and manageability of enterprise reference data Change Comparison Reports to identify changes between different versions of Codesets/Reference Tables Meet regulatory, compliance and process audit Auto Mapping Capabilities to accelerate the development of Code Crosswalks Build repeatable processes and solutions Compliance to healthcare standards like HIPAA, SOX etc. Validation Rules Engine - Define and Execute SQL Queries on Reference Tables to identify duplicate rows, integrity violations, nulls etc. Improve Data Quality confidence Deploy Reference Tables and Codesets to various environments using the publishing capabilities Restricted User Access to tightly manager and govern Codesets, Code Crosswalks and Reference Tables

  41. Release Manager Enables Program and Project Managers to create, validate and manage releases, release calendars and release artefacts such as ETL Jobs, Data Mappings, Database Objects, Server objects, release notes and more to standardize all release processes and documentations standards around the release process. BENEFITS KEY FEATURES Empowers release managers to define and promote best practices and standards Centralized repository to manage and govern releases and all release artifacts Integrated Release Plans and enterprise Calendar views Streamline, collaborate and every aspect of the release management process Reduce risk and meet corporate compliance standards Integrated Workflow Management & Approval process Standardize and govern all documentation surrounding the release management process Detailed change and audit tracking Easy to use UI to collaborate and standardize the release processes Global visibility into the release process and release objects Automatic promotion of mappings and tight alignment with releases when used in conjunction with Mapping Manager Release management audit-trail tracking and support Increased productivity and improved organizational autonomy via shared and collaborative release management environment Quickly view and generate release plans and other release reports Integration with Third party configuration management tools through CATfX Streamline communication and collaboration

  42. Test Manager Test Manager enables Test Cases and Test SQL generation to be managed in a purpose built module for testing data mappings and ETL processes. There are over 15+ built-in automationCATSwhichenableimmediatecreationofTestCases andTESTSQLtoacceleratethetesting phases of integrationprojects. BENEFITS KEY FEATURES Centralized Repository to manage Test Cases and other test artifacts Comprehensive Test Case Management Capabilities Integrated Test Case Repository to manage reusable test cases, test SQL and governance of the the entire testing process Improves testing efficiency by enhancing collaboration between testers and developers Promotes the reusability and accessibility of test cases Customizable and Scalable Automation Testing Framework Increases visibility so all stakeholders can monitor test processes and gauge application readiness Test SQL Generation and documentation of Testing Results Testing Automation and Customization with the CATfX Framework Integration with leading Testing Tools like HP-ALM Supports connectivity to any Database and big data systems Testing Automation for Data Vault Methodology Auto Generation of reusable Test Cases based on source and target metadata Manage data migration projects and reconcile old and new system for data correctness Testing Report Summaries Streamline communication and collaboration

  43. Data Quality Assessment Manager (DQAM) Enables organizations to standardize and execute a formal data quality assessment methodology by selecting the objects which should be assessed, scheduling the assessments, manage the data quality scores and workflow review process. Governance features manage data steward and stakeholder accountability for the quality reviews and sign-off. Govern valid values, invalid values, remediation rules and generate scripts to “fix/repair” invalid data values. BENEFITS KEY FEATURES Enterprise data quality management. Take advantage of the data quality console for an enterprise view of your data quality scores and programs Engage Business Users and standard and execute a formal Data Quality Assessment Methodology Easily Manage Data Quality Scores (A,B,C,D, and F) and enable governance and stewardship programs Assign and track data quality tasks to completion using the integrated project management capability Govern valid and Invalid values and categories data quality issues Enables ability to measure effectiveness of data quality and stewardship programs by trending quality scores Remediate invalid values and create data repair scripts Collaborative review and integrated workflow process Business-friendly interfaces and workflow. The workflow separates the technical and analysis functions supporting business-friendly interfaces for end-users Define monitoring and remediation rules to correct and improve data Meet compliance and Data Quality standards Publish Data Quality Assessment & Six Sigma Category Scores Compliments existing DQ and MDM tools available on the market Schedule assessments, monitoring rules and trend DQ scores

  44. Reporting Manager Enables IT teams to quickly build and configure reports and dashboards from AnalytiX DS repository to manage their teams workflow status and cross team communication by creating and publishing reports and dashboards to streamline communications across the data management process. The easy to use interface enables reporting 10 times faster without all the training hassles required by larger BI reporting platforms. BENEFITS KEY FEATURES Helps improve decision making and promotes cross- team collaboration across the SDLC process Flexible Reporting Bring in greater control and visibility for all major stakeholders through the integrated reporting portal Build Charts and Dashboards Customized Reporting and publishing Capabilities Business friendly user interface, enables team dashboards and reports to be published Connectors to leading databases and third party apps Ability to report on internal and external repositories Schedulers to automate report generation to key stakeholders Helps build a robust Reporting Portal specifically around the data management and SDLC process to promote more efficient status and workflow management reporting. Role based security to govern access and publishing controls

  45. Metadata Management Plug-ins Metadata plug-in are available for Informatica Metadata Manager, IBM Metadata Workbench/GDC, DAG metacentre and Rochade. This enables all the metadata in Mapping Manager Unified Platform to be ported into third party metadata environments. Metadata connectors for all ETL Tools, Java Scripts, Cobol copybooks, Cobol Programs, Sales Force.comandmore. BENEFITS KEY FEATURES Maximizes the investment of existing metadata management platforms Sync AnalytiX DS metadata repositories to third party metadata management tool platforms Extends capabilities of existing metadata management platforms using AnalytiX DS plug-ins for unsupported data sources Compliments external metadata repositories by leverage a rich set of pre-built “connectors” others tools to do not support (e.g. Cobol Programs, Reverse Engineer ETL jobs, code Parsers, Data Mappings and more) Enables End to End Lineage and greater support of data sources Ability to customize existing connectors via CATfX Ability to sync business oriented data mappings and view data mappings alongside of ETL jobs Schedulers to automate synch processes Ability to consolidate business reference data and codeset standards within the enterprise metadata repository. Role based security to govern access and publishing controls Global community of automation developers and connectors available via AnalytiX DS automation marketplace

  46. Code Automation Template Framework (CATfX) The integration Industry’s first Automation Platform for Data Integration Professionals. CATfX Defines Work Smarter. Save Big. Create, version and publish re-usable code automation templates (CATS) to generate code for Big Data, ETL/ELT Tools, Code Parsers, SQL generation or Custom Adaptors and Connectors to anything by Scanning metadata and Generate code for anything using a 100% metadata driven approach to automation. The automation marketplace is a global marketplace for automation developers to post automation CATs for the global community to browse buy, sell and download to automate manual process. BENEFITS KEY FEATURES Multitude of scripting language support for the developer community (JavaScript, JRuby, Groovy, J-Python, R & XSLT) Enterprise Code management Drastically increases developer productivity with reusable code automation templates(CATs) Create and version Re-usable code automation templates (CAT) Fits seamlessly into Agile Development methodologies ensuring rapid development to quickly changing requirements End to End Automation Framework Developer Friendly Integrated Development Environment Reduce repetitive and time consuming manual tasks Automation for ETL, SQL, Big Data and much more… Increase quality, standards & time to value Drastically reduce costs ETL/ELT Standardization and Automation Generate re-usable templates based on Job design best practices Testing and Custom Code Generation Wider adaptability due to amount of supported scripting languages Code Gen for Data Vault Methodology Workflow Management for Sequential Execution of Automated Tasks

  47. Available Services Services Categories • Mapping Manager Jumpstart Installation, training, and services to get stared quickly. Team Enablement Services AnalytiX DS certified resources can augment your team and accelerate Mapping, ETL, Testing and Big Data. ETL Center of Excellence AnalytiX DS can assist enabling your best practices and generate code-automation templates to drive standards and perform production monitoring of ETL Processes. Data Quality & Testing Automation Jumpstart program around Data Quality and Testing Are available with Test Manager & Data Quality Manager Modules. LiteSpeed Conversion Services Quickly convert between one legacy ETL Platform to another using software driven automation & our conversion methodology. LiteSpeed Conversion & Autonomy. Automation Jumpstart (CATfX) Jumpstart program is intended to analyze manual integration processes and build ‘reusable’ CATs to automate, standardize and accelerate the process. QA Mission Statement: We are driven by our relentless focus on the “pursuit of Excellence”, we will constantly strive to implement the critical initiatives required to achieve our vision. In doing this, we will deliver operational & innovation excellence in every corner of the Company and meet or exceed our commitments to our customers, our employees and our partners. All of our long-term strategies and short-term actions will be molded by a set of core values that are shared by each and every associate aimed at ensuring customer success and innovating the Data Integration industry and remaining a leader in enterprise data mapping, governance and automation. We strive for Excellence in everything we do!

  48. Service Program Offerings Available Services Programs • Ask about our team enablement services and discount schedules for Big Data support Services ETL/ ELT Center of Excellence Production Support & Monitoring support services Automation support services Governance & Data Quality support services Data Mapping support services

  49. Mapping Manager Mapping Manager Module (Screen Orientation) Enterprise Data Mapping, Governance & Enterprise Data Mapping, Governance & Automation Automation Module Build Mappings using Drag n Drop Auto-Generate ETL Jobs S2T Mapping Specifications Project & Mapping Browser Previously Versioned Mappings Metadata Browser (Manage Data Dictionaries) Business Glossaries RDBMS Metadata Data Models File Data Internet of Things (IoT) JSON Hadoop HDFS HIVE Ecosphere DBMS More Mapping Details (Customizable)

  50. Mapping Manager Mapping Manager (reverse Lineage view)

More Related