AnalytiX Data Services
This presentation is the property of its rightful owner.
Sponsored Links
1 / 56

AnalytiX DS – Master Deck PowerPoint PPT Presentation


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

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Analytix ds master deck

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 [email protected] 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


Analytix ds master deck

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)


Analytix ds master deck

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


Analytix ds master deck

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


Analytix ds master deck

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.


Analytix ds master deck

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


Analytix ds master deck

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


Analytix ds master deck

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)


Analytix ds master deck

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


Analytix ds master deck

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


Analytix ds master deck

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.


Analytix ds master deck

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


Analytix ds master deck

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


Analytix ds master deck

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


Analytix ds master deck

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.


Analytix ds master deck

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


Analytix ds master deck

Over 1,000 Customers and growing….

Large International Customer Base


Analytix ds master deck

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.


Analytix ds master deck

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.


Analytix ds master deck

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.


Analytix ds master deck

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.


Analytix ds master deck

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)


Analytix ds master deck

Hubs

Links

PIT

Bridge

Satellites

Data Storage

Layer


Analytix ds master deck

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


Analytix ds master deck

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.


Analytix ds master deck

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.


Analytix ds master deck

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


Analytix ds master deck

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


Analytix ds master deck

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.


Analytix ds master deck

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


Analytix ds master deck

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


Analytix ds master deck

CATfX Automation Framework

CATfX Automation Framework(CATfX IDE)

Compile & Preview

Results

Integrated

Debugger

Scripting

Languages

Code Editor

w/ versioning


Analytix ds master deck

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


Analytix ds master deck

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


Analytix ds master deck

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


Analytix ds master deck

UNIFIED PLATFORM MODULE OVERVIEW

Key Features and Benefits


Analytix ds master deck

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


Analytix ds master deck

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


Analytix ds master deck

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


Analytix ds master deck

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


Analytix ds master deck

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


Analytix ds master deck

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


Analytix ds master deck

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


Analytix ds master deck

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


Analytix ds master deck

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


Analytix ds master deck

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


Analytix ds master deck

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!


Analytix ds master deck

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


Analytix ds master deck

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)


Analytix ds master deck

Mapping Manager

Mapping Manager (reverse Lineage view)


Analytix ds master deck

Mapping Manager

Mapping Manager – – Integration Library

Integration Library

(CATfX Published re

(CATfX Published re- -usable automation templates)

usable automation templates)

Click the Integration

Library icon

Integration categories


Analytix ds master deck

Release Manager

Release Manager – – Gain Control of Release Schedules and Release Objects

Gain Control of Release Schedules and Release Objects


Analytix ds master deck

Work Smart.

Save Big


Analytix ds master deck

AUTOMATION MADE EASY.

We create re-usable automation solutions to your most complex and expensive processes

Any Volume

Idea Concept

Library Metadata

Before you think about writing code for

weeks and months on end – think about

how the code can be automatically

generated. Then contact the experts at

AnalytiX DS to for

automation expert.

The larger the coding task – the better! We can

create a reusable automation template that can

save hundreds of man hours and hundreds of

thousands of dollars by addressing the manual

coding effort with automation techniques made

possible with our CATfX Automation Framework.

We

templates in our library which will work for your or

can be customized to fit your exact automation

requirement.

have

an

extensive

library

of

automation

review with an


Analytix ds master deck

AnalytiX Data Services Inc.

Governance

Automation

Enterprise Data Mapping


Analytix ds master deck

Contact Us

SALES

For Sales - Please call (800)-603-4790 (9am-5pm EST) or Email: [email protected]

SUPPORT

For Product Support - Please call (800)-617-9620 or Email: [email protected]

Community & Social Media

Phone & Email

Corporate HQ

www.analytixds.com/community

www.youtube.com/user/AnalytiXDS

Facebook.com/analytixds

LinkedIn.com/analytixds

[email protected]

[email protected]

(800) 656-9860

Http://www.analytixds.com

14175 SullyfieldCircle

Suite 500

Chantilly, VA 20151


  • Login