GT Datamaker

1
GT Datamaker

• A complete test data suite in one

2
Wide Spread Test Data
Most Data is the Same!
Less Data more variety!
3
Datamaker the new wave!

• Create accurate development and testing data
• Centralize, standardize and reuse data
• Accelerate development - dont delay project
  components
• Use data descriptions as part of your end to end
  development lifecycle
• Manage and integrate capture replay data tables
• Reduce time testing SOA end to end processes
• Most bugs that reach production are due to poor
  testing data

4
Standard Developmentt
Sequential Delivery
Debit Card Development Project - sQuid
DatabaseDesign
MerchantPortal
Card Portal
Transactions
Settlements
Payments
Banking
Changes Errors
5
Accelerated Parallel Development
Parallel Delivery
Debit Card Development Project - sQuid
MerchantPortal
Demos
Card Portal
Transactions
DatabaseDesign
Datamaker
TestingTraining
Settlements
Payments
Implement
Banking
6
End to End Testing
ERP
Database
Database
Interface
API
XML
BACS
Forecast Studio
Test Data Warehouse
Data Explosion
Data Functions
Data Inheritance
Mass Edits
Version Management
7
Datamaker a complete test data management suite
Subsetting
Subset
PRODUCTION Database
Data Scrambling
Scrambled
Created
Generated Data
Data Sampling
Test Automation Data
8
What are your pain points?

• Test Data management Access to clients
  data Preparing Test development
  environments Data Quality Code coverage
• Test Case Preparation - e.g. for QTP 2.17
  cases p/person, p/hour
• How to deal with end to end process
• Complex, laborious, time consuming

9
Datamaker - Implementation
Versioning
Register Data
Default Values
Data Quality
Data Relationships
Data Differences
Transaction Types
Data Sampling
Data Functions
Datamaker
Seed Data
Data Cubes
Control
Parameters
Lists of Values
Test Data Warehouse
10
Datamaker the new wave!

• Used worldwide to improve development
• Used in Centres of Excellence to improve testing
• Used to increase code coverage
• Used to protect sensitive data
• Theres nothing else like it!

11
The Datamaker Steps
Seed Data
Data Explosion
Register Tables
Data Relationships
Data Inheritance
Versioning
Mass Edits
Default Values
Data Validation
Data Functions
Data Sampling
Data Cubes
Control Variables
Data Differences
Lists of Values
12
Introducing GT G-T Datamaker

• COMPANY OVERVIEW
• Introduction and experience
• DATAMAKER OVERVIEW
• THE WORLDS MOST POWERFUL TEST DATA GENERATOR
  Allowing you to create test data from scratch
  with all the relationships and characteristics of
  production data
• ANONYMISE SENSITIVE DATA - Protecting
  confidential details and ensuring legal
  compliance is essential. The data is filtered
  preventing any live information being released
  unchanged.
• SUBSET EXISTING DATA - Automatically extract and
  break down existing data into manageable sets for
  testing.
• SET UP A TEST DATA WAREHOUSE So that you can
  re-use test standard cases saving time and
  increasing the richness of your test data. 
• GET TEST-DATA ON DEMAND This is a very new
  feature in the testing market where you can let
  your users request test data as and when they
  need it, obtaining good quality conditioned data
  almost instantly.  Visit the website for a
  working demo of this facility

13
Powerful Test Data Warehouse End to End
Processes
Stage 2
Stage 3
Stage 1
Stage 4
Flat File
XML
CSV
Quality Centre
Test Data Warehouse
Control
Reusability
Structure
Best Practice
14
Types of testing
PRODUCTION Database
STRESS TESTING
UAT
REGRESSION TESTING
END TO END TESTING
DATE SHIFTED
DEV
DEV
DEV
New Releases
Offsite Development
FUNCTIONAL TESTING
SYSTEM TESTING
DEV
DEV
DEV
15
Datamaker a complete test data management suite
Development
Pass Through
Functional Testing
PRODUCTION Database
User Acceptance
Light Conditioned
Stress Testing
Offsite Development
Conditioned
System Testing
Data Sampling
Date Shifted
End to End Testing
Regression Testing
16
Understand the scale of the problem

• Poor testing can cause a number of problems..
• - Production failures
• - Performance issues
• - Reliability issues
• - Time lost repairing data
• The Quality of your test data and the types of
  testing you do directly effect your bottom line
• Some Statistics from Gartner...
• - 80 of business applications are not tested
  properly before being released into production
•   - 40 of unplanned downtime is caused by
  application failures, costing an average of 100k
  per hour for mission-critical applications
•   - 50 of deployed applications need to be
  rolled back to Development

17
Data Sampling
PRODUCTION Database
TESTING Database
TESTING Database
TESTING Databases
18
Role specific Use

• Designed to be adaptable...
• To suit your specific need for testing
• Work on a specific area
• Establish a complete structure for all your
  testing
• To suit your required level of expertise
• Three levels of experience
• User Friendly and Secure

19
Adapt Datamaker to suit your needs
Level 1 Entry Level Testers
20
Adapt Datamaker to suit your needs
Level 2 Intermediate Developers Use
Standard data Apply local edits
21
Adapt Datamaker to suit your needs
Level 3 Advanced Users Sample Production
Build Standard Test Cases
22
Data Protection Issues
23
Test Data Tools Notes and Thoughts

• BUGS ESCAPE INTO PRODUCTION EVEN WITH GOOD
  PROCEDURES
• TEST DATA TOOLS ARE POOR
• DATABASE
• SCREEN CAPTURE AND REPLAY
• DATA QUALITY IS POOR
• DATA CENTRIC TESTING
• DATA MODEL DRIVEN TESTING
• IDENTIFY A TRANSACTION
• COMPANIES ARE REACTIVE NOT PROACTIVE
• DATA SENSITIVITY IS A DRIVER BUT IS VERY POOR

24
Data Events
PROCESS
DATABASE START
DATABASE END
ACTUAL DIFS
ERRORS 1
ERRORS 2
EXPECTED DIFS
25
Data Events
DATABASE START
DATABASE END
ACTUAL DIFS
ERRORS 1
ERRORS 2
EXPECTED DIFS
26
Data Events
DATABASE START
DATABASE END
ACTUAL DIFS
ERRORS START
ERRORS END
EXPECTED DIFS
27
Stage 2
Stage 3
Stage 1
Stage 4
Flat File
XML
CSV
Forecast Studio
Test Data Warehouse
Data Explosion
Data Functions
Data Inheritance
Mass Edits
Version Management
Reference Data
Data Objects
Data Model
Data Characteri-stics
Random Data
Data Samples
28
Subsetting
PRODUCTION Database
Subset
Data Scrambling
Scrambled
Created
Generated Data
Data Sampling
Test Automation Data
29
PRODUCTION Database
TESTING Database
TESTING Database
TESTING Databases
30
PRODUCTION Database
Subset
Subsetting
Data Scrambling
Scrambled
Generated Data
Created
Data Sampling
Test Automation Data
31
(No Transcript)