accelerate project delivery - informatica etl tool · pdf filehealthcare services corporation...

www.analytixds.com 1

Accelerate Project Delivery Powered by: Analytix Data Services LLC


International Software and Services Technology Company

The AnalytiX: Mapping Manager solution, is the FIRST enterprise solution which comprises both a metadata & data mapping repository which solves the “Pre-ETL” Source–To–Target mapping problem and promotes better data quality surrounding the entire data mapping process to make the process faster, more collaborative and more manageable.

AnalytiX Data Services provides data integration software and technology

services to deliver data integration and business

intelligence solution to its customers.

AnalytiX Data Services

Mapping Manager

Services Accelerator (PSA)

Release Manager


Corporate Office: Washington, D.C. Metro Area

Customers: 50+ Customers WorldWide and Growing

Incorporated 2006

Headquarters: 14175 Sullyfield Circle, Suite # 400 Chantilly, VA 20151 USA Tel: +1 (703)539-2955

Development Center: Level 3, Sri Mahaan Heights, Rd. No. 12, Banjara Hills, Hyderabad, Tel: +91 40 – 4900 7777

Corporate Profile

Resellers: 10 + Resellers Worldwide and Growing Some of the largest Data Warehouses in the United States (Terabyte Data Warehouse)


Mike Boggs (Biography)

Project Portfolio Openet Telecom HealthCare Services Corporation Blue Cross Blue Shield Organizations Temple-Inland Container Corporation Ameriquest Mortgage Motorolla Nextel International WorldCom Consulted to others…..

Mr. Boggs is an accomplished Data Warehouse and Business Intelligence professional who draws from his extensive experience in Data Warehousing to deliver client projects and to design and deliver the integration industry’s first enterprise solution to the ‘Source-To-Target’ mapping and governance problem (Analytix: Mapping Manager). With more than 15 years experience dedicated to the industry Mr. Boggs is a subject matter expert in Data Warehousing and Data Integration. Mr. Boggs has architected and delivered some of the largest data warehouses in the States.

AnalytiX Data Services: Partner and Chief Technology Advisor

http://www.analytixds.com/products.html




HP and AnalytiX Data Services sign Practice

License and Reseller Agreement - 7

November 2011 • HP employees are allowed unlimited enterprise use of the AnalytiX

Mapping Manager (AMM) and the AnalytiX Release Manager (ARM) for HP

internal purposes

• HP is authorized to act as a reselling agent for AnalytiX Data Services to

market the AMM and/or the ARM to HP’s existing or potential customers

• HP may package and brand the AMM and the ARM along with HP data

integration solutions. HP may use the AnalytiX logo within HP sales

collateral and presentations

• HP may deploy the AMM and the ARM to existing and potential HP

customers for 30-day proofs of concept and evaluations and register

customers for the free license

Contractual Relationship

AnalytiX Delivers Excellence in Mapping Standards


Technology Board of Advisors Distinguished Panel of Subject Matter Experts

Dr. John R. Talburt is Professor of Information Science Program. And heads the Data Quality Program with MIT as is Executive Director of the UALR Laboratory for Advanced Research in Entity Resolution and Information Quality (ERIQ LAB).

Hewlett-Packard (HP) Enterprise Information Solutions Group Software is a Software & Solutions Reseller & Technology Contributor

AnalytiX Mapping Manager is available on Informatica’s Marketplace Community: (Forum for complementary products) https://community.informatica.com/community/marketplace/analytix


The Marketplace connects buyers and sellers to share data integration solutions within an open and comprehensive ecosystem of more than 100,000 active users : https://community.informatica.com/community/marketplace

Technology Categories: 8

Technology Solutions: 600+

Grand Prize Winner: AnalytiX MappingManager Solution

2012 Winner Marketplace MVP Contest

2012 Finalist Informatica Innovation Award

2010 Winner Marketplace Innovation Drive

AWARDS


AnalytiX™ Mapping Manager - Key Features

Data Stage

Auto-Generate ‘Pre-ETL Mappings into ETL Mappings (Agnostic approach to ETL)

SSIS Packages

Features : Mapping Manager

Manage and Reuse System Metadata View technical and business definitions from metadata browser

Import Existing Excel Mapping Specifications Role Based Security

Import/Export Mapping Specifications Reuse and share commonly used transformation logic

Store and share project management View Mapping Spec resource assignments and statuses

Store and share system documentation Track the status of mapping specifications

Manage Project Resources and Users Drag and Drop user interface

Store and manage mapping Specifications versions Supports many to many relationships

Perform impact analysis of Tables, Columns and Transformations Advanced mapping specifications comparison ca[abilities

View data lineage across the enterprise Manage Enterprise Transformations at a governance level

Print ,share and collaborate on Mapping Specifications View change and version history

Automates Creation of ETL Jobs for Informatica Print Reports: Mapping Spec, Project Report & System Analysis Report

Automates import of Informatica ETL, jobs as mapping specifications Integration with Erwin

Automates Creation of ETL jobs for Datastage Supports Excel upload capabilities to store system metadata

Automates import of datastage ETL jobs as mapping specifications Built in Metadata scanners for all major database vendors

Seamless install Define, maintain and upload data dictionary for systems

No Prerequisite ETL Tool Version requirement Advanced search and filtering capabilities

Central Repository for integration project documentation Customizable integrated data grid

Import System Metadata Advanced search and filtering capabilities

Preview data Capabilities from Metadata Browser Certified on internal repository Oracle DBMS and new versions of SQLServer

Certified to run on Linux based environments (Ubuntu and Red Hat) Enhanced change log tracking other features

Power Center


Clients


Time Intensive Data mappings require multiple resources to work iteratively to define accurate mapping rules.

Cumbersome Versioning

Lack of traceability and audit controls.

Lack of Visibility No visibility into mapping assignments and statuses. Difficult for stakeholders to manage and control the mapping process

Manual Data mappings are currently 100 % manual.

Non-Standard Organizations are required to identify a mapping process every time a new project has commenced.

Error Prone Multiple resource manual entry of mapping information often leads to error prone mappings from miscommunications, overwrites, and data entry errors.

Data Mapping Challenges


Mapping manager enables system metadata lookup and transformation reuse.

Mapping manager allow many users to work and collaborate on mappings with out overwriting or confusing multiple versions.

Mapping manager contains version controls which enable better maintenance of mapping specifications.

Mapping manager leverages industry best practices and mapping standards to create a seamless process which does not require resource retraining.

Fewer mapping analysts are required to manage and control mappings due to built in automation and efficiencies.

Mapping manager enables all stakeholders access to mapping lifecycle analysis to ensure prompt visibility into data integration projects.

Enable Automation

Leverage Industry Standards

Enable Collaboration

Reduce Resources

Enable versioning

Enable Visibility

Mapping Manager Data Mapping Solution Enables


Project Planning/Requiremen

ts Database

design and modeling

Data Cleaning

and profiling

Define Mapping

SPECS

(MAPPING MANAGER

)

Define Mapping

SPECS

(MAPPING MANAGER

)

ETL

QA/TEST

Implement/Deploy

The Integration Industry’s FIRST “

Enterprise Solution” to the Data Mapping

Problem

The AnalytiX Mapping Manager Solution Product Fit in System Development Lifecycle

Automates the Data Mapping Process Metadata + Data Mapping Repository Drag n Drop, Build-n-Version data Mappings

Enables Control , Visibility & Traceability Group & Consolidated STM’s by Subject Area Mapping Comparison and Impact Analysis

Integrates with leading ETL Tools Providers Informatica | DataStage | SQL Server SSIS


INTEGRATION PROJECT

SCENE

•Data Warehouse/Data Marts •Operational Data Stores •ERP/Data Conversions (SAP,JDE, Oracle Applications, Etc.) •Data Migration/DBMS Re-Platform (SQL Server To Oracle, Etc.) •Master Data Management •Metadata Management •Data Governance & Data Quality

•Reporting Specifications •HIPAA Code Conversion (Healthcare) •ICD Code Conversion (Healthcare) •Swift/ISO Conversion (Financial) •Regulatory Compliance (SOX… etc) •Operations Consolidation •Business Process Management •Services Oriented Architecture (SOA integration) •Data Federation

Integration Project

Business projects

USE CASES: Data Movement From Point A to B

Mapping Manager

BUSINESS PROJECTS


1

2

3

4

Mapping Manager System

Manager

Resource Manager

Mapping Manager Modules Integrated suite of modules


System Manager •Define, manage and share system information and connectivity specifications •Define manage and share system documentation with multiple users (Data Dictionaries, User Guides etc). •Automatically Load, Refresh, Leverage and share metadata (technical and business) via loading directly from Erwin files or automatically loading from DBMS system catalogs. •Seamlessly manage metadata and profiling of source and target systems. •Accelerate access to source systems connectivity specifications, documentation and metadata. •Eliminate duplicate efforts from silo project teams and loss of knowledge capital due to attrition.

Resource Manager

Key Capabilities by

Module

•Add users to the system •Create Integration Project •Allocate users to projects and define roles. •Allocate Source & Target Systems to projects •Allocate project resources and define roles •Easily Load, Manage and Audit Project and SDM •Easily load and share any project level documentation at the project level (e.g. SDM, Compliance Documentations, Project Plans, Release Schedules

Mapping Manager •Dynamically create mapping specs using Metadata Browser’s Drag & Drop capabilities •Import existing Excel mapping specifications via import template/CSV files •Support one to many mapping relationships and ability to define derived columns; movement of heterogeneous data sets from /to disparate systems •Ability to attach files such as advanced detail design specifications at the mapping level. •Ability to attach and share files at the project, system, and mapping specification level. •Ability to define encryption requirements for SOX, HIPPA, & PHI sensitive data •Facilitates definition & governance of mapping standards

Mapping Manager Modules Key Capabilities by Module


ETL/ELT INTEGRATION

Mapping Manager Solution

THIRD PARTY TOOLS Requirements Testing Metadata Etc

Flat Files

Mainframe

Database

META DATA REPOSITORY

DATA MAPPING REPOSITORY

Support for any source

SOURCE DATA AnalytiX MAPPING MANAGER™ INTEGRATION WITH LEADING ETL

TOOLS

REPORTING BUSINESS INTELLIGENCE STATS

BUSINESS TRANSFORMATION

LOGIC

AUTO GENERATE ETL JOBS

REVERSE ENGINEER ETL JOBS

EXPORT


Open Repository for Analytics Dashboard Example: Dashboard Analytics from Mapping Manager Repository Solution Offering: Software as a Services (SaaS) for mapping and metadata analytics & reporting


Mapping Manager Solution Implementation Process flow

Project Sponsor

Project Manager

Mapping Analyst

Tester ETL Developer

META DATA REPOSITORY

DATA MAPPING REPOSITORY

1. Drag n Drop Build and Version Data mappings

2. Collaborate & View Data Lineage

3. Track Mapping Assignment & Status

4. Manage Enterprise Data Dictionaries

5. Auto Generate ETL /ELT Data Movement Jobs

1. Scan Metadata ( source systems & target systems)

2. Enrich Data Dictionaries

Intergration Library (Custom XML Templates) Custom XML Templates for Pattern Based Mappings

1. Data Migration Job 2. Type 1 Dimension 3. Type 2 Dimension 4. Type 3 Dimension 5. Fact Table Load 6. Multiple Target Tables Etc…

BUILT – IN REPORTING : Mapping Intelligence and Metadata Reports

MINE THE REPOSITORY FOR CUSTOM REPORTS

CANNED REPORTS (sample)

1. Project Report 2. System Analysis Report 3. # Mapping Specification

Report 4. Mapping Validation 5. Data Dictionary Reports

6. Impact Analysis Report (Table | Column | Business Rule)

Formatted Data Mapping Specification

Ap

plic

atio

ns

Un

stru

ctu

red

F

iles

Dat

abas

e M

ess

age

s Fl

at F

iles

XM

L M

ain

fram

e

| Power Center

| Data Stage / Infoserver

|SSIS Packages


CodeSet Manager (Add-On) Manage Enterprise Codeset Values and standards (Data Governance) Create Codeset Standardization and cleansing mappings


Dedicated On-Site

Dedicated Off-Shore

Dedicated Resources: On-Demand (Staff Augmentation) Resource Roles

Mapping Specialist Mapping Leads Mapping Coordinators Training Mentoring &

Best Practices

OR

Dedicated Team: Global Delivery Services (24x7)

Resource Roles Onsite Mapping Lead Off-Shore Mapping Lead **Dedicated Mapping Team

(On-Shore, Off-Shore or Hybrid)

Dedicated On-Site Lead

Dedicated Off-Shore Delivery Team

AnalytiX™ Professional Services resources can be assigned client staff to augment staffing operations

AnalytiX™ Professional Services can deploy a team capable of providing 24x7 services

Flexibility & Speed. Our skilled professionals and our On-Demand and Dedicated Team models means your project can scale up or down quickly by adding the right resources at the “right time”

Value. Utilizing offshore resources on projects generates lower costs and faster ROI for your projects. Mapping Standards and Tools. Our services team are highly skilled resources focused on quality and data mapping standards to

accelerate project delivery and quality. Global Delivery. Our on Demand and Dedicated Team models can be configured to provide 24x7 services enabling greater productivity

and accelerated project delivery.

Fixed Price Solution Offering: Legacy mapping conversions to Mapping Manager

Global Delivery Service


Next Release – Version 4.2 Scheduled Release Date : Monday, July 16

Key Features & Enhancements 1. Lineage Analyzer (new feature)

2. Advanced Impact Analysis (Options to include Business Rules, Lookups Source SQL Selects)

3. Advanced Reporting and Mapping Export Options

Planned Release Schedules: Major releases are planned every Quarter.

Priority point releases are available based on customer need and demand


Lineage Analyzer End to End Lineage analysis across all mappings, systems and projects


Advanced Impact Analysis Advanced Impact Analysis Options to expand selection criteria


Training, Mentoring and Best Practices

1. Daily, Weekly and customizable packages

2. Onsite, Offshore and Webinar Based Training

3. Previously recorded training videos available

1. Customized for your environment and standards (Internal Training Credits)

4. Professional Services – Augment your teams with onsite and remote services.

Training Options Training and Enablement Offerings – customized to fit your needs


MAPPING MANAGEMENT

• Quickly create & maintain accurate Source-To-

Target Mappings (STM)

• Analyze Data Lineage

• Quickly document GAP analysis

• Quickly define accurate data requirements

• Quickly analyze and profile data.

• Manage & collaborate upon Enterprise

Metadata (system & Database)

• Data Preview Capabilities (SQL Editor)

• Define Enterprise Reference & Code

Definitions (SOX, HIPA, SWIFT/ISO etc –

Data Quality)

• Define & Maintain Valid Values (Governance

& Data Quality)

• Create, Manage & Maintain Data

Dictionaries (Metadata Management)

• Create & manage Enterprise

Transformations (Data Quality)

• Quickly create reporting specification

METADATA MANAGEMENT

Mapping Manager Value Added Capabilities


Mapping Manager

1 Time savings from creation of all mapping specs.

2 Time savings managing mapping changes and versions

3 Time savings conducting re-work of Mapping, ETL Jobs and Test Cases

4

Time savings coordination, liason and project management of mapping and statuses (reduces burden on PM's and Coordinators)

5 Time savings with reusability of system analysis, document tracking and approvals

6 Time savings managing versions through releases

7 Time savings system access, data profiling and managing data dictionaries

8 Time savings managing transformations and code-sets at the enterprise & project level

9 Time savings resulting from standardizing upon 'industry' mappings (e.g. ISO, X.12 standards,etc.)

10 Time savings from training resources on excel based mapping spec templates

11 Reduced costs through less technical resource requirements to work in mapping

12 Reduced costs through fewer BA's and ETL Developers needed to deliver integration projects

13 Time savings resulting from automating ETL Jobs

14 Reduced project licensing costs for other tools such as: Erwin & Toad (SQL Query Tools) etc

Application Efficiencies Driving ROI


Screenshots


Mapping Manager Login Screen Web Based Java application


Sample Mapping Specification Mapping Manager Module


Mapping Manager Module Screen Orientation

Project & Mapping Browser: Group and categorize mappings

by project and subject areas.

Archive: Built –In versioning of

data mappings

Dynamic Integrated Data Grid source to target mapping

spec.

ETL Integration: Export to ETL Tools

Metadata Browser Scan & consolidate metadata

Metadata Technical & Business Properties Data Dictionary Definitions

Mapping Specification Detail Tabs Integration Details and Workflow Mgmt

Build & version mappings

using drag n drop


Manage and Maintain Shared/Reusable Transformations

Enterprise Transformations are shared, reusable across all projects and versioned and trackable throughout

the change process


System Manager Module Scan and Manage System Metadata

System Environments: Automatically scan Metadata from heterogeneous DBMS systems and flat files across

multiple development, test and production environments

System Documents: Share and collaborate

on system documentation

System Details: Manage share and collaborate upon all technical system

specifications


AnalytiX Data Services , 14175 Sullyfield Circle, Suite # 400 Chantilly, VA 20151 USA

Tel: 1+(800)-656-9860

Email: [email protected]