DTM Data Comparer

Data Comparison and Synchronization Software

Important Links

Manufacturer :

DTM soft

Search more about this tool in QATestingTools archive

Visit Website

Download HERE

Tool Support link HERE

StackOverflow Search Questions

Tool Information

Introduction

Tool Summary

DTM Data Comparer is a visual tool for data comparison and synchronization. The program successively views the rows of two tables basing on the order of ascending of primary or unique key values. If the tool cannot find two records with the same key value, it places the records to different lines and highlights in yellow. For equal key values the program places them to the same line and highlights equal fields in green and unequal fields in red. When the user define mapping the program leaves columns that don't take part in comparison white.

Last Release Year ['Active'=Current]:

Active

Since (maturity):

2005

DTM Data Comparer
	Tool Scope	Testing Utility
	Application Rights	Commercial, Demo, User license
	Since	2005
	Company	DTM soft
	Support	Tool Support link HERE
	Download	Download HERE

Features

There is five comparison modes: table to table, query to table, text file to table, Excel spreadsheet to table and database.
Compares tables in the same or in the different data sources.
Visual comparison process and comparison HTML-report
Excel comparison results to analyze differences by external tools.
Mapping feature helps to compare tables with different data and key structures.
Database independent. Allows to compare a table in Oracle database with table in MySQL as well as Interbase table with table in DB2 database. DTM Data Comparer supports all common database interfaces: ODBC, IDAPI, OLE DB and Oracle Call Interface.
A Win32 application
Supports Windows 2000, XP, Vista, Windows 7, Windows 8(desktop), Windows Server 2003, 2008, 2012. x64 version of the tool is available for registered users.

Advantages -

Easy to use interface
Custom key support feature - to compare desktop files without Primary Keys.
Compares and synchronizes millions of rows
Multivendor environment support: ODBC, OLE DB, IDAPI and Oracle Call Interface.
Customizable HTML data comparison report.
ANSI and Unicode versions available.
Console (command line) mode
Integrates with Windows Task Schedule

DTM data comparer 150.png

Getting Started

Getting Started:

How to compare data with DTM Data Comparer software?

DTM Data Comparer is a software that developed to help user to compare data easy and fast. The key product feature is database comparison results visualization. There are only three simple steps to compare data with this tool:

Connect to database for primary and secondary data sources. You can operate with single database as well as with two different databases (like DB2 and Informix).
Select two tables to be compared.
Run the compare data process.

Also, a few optional settings make compare data process more flexible. They are:

WHERE clause allows users to limit data rows to be compared
Mapping feature is an easy way to compare data with different structure.
Data compare process can produce HTML report (sample comparison report). The user can specify project level file name or product level report file.
Custom unique key specification to compare data from tables without primary key
NULL value comparison option. The user can consider all NULL values different or equal

Can DTM Data Comparer compare data in my databases?

The comparison tool must be executed at Windows system even your database is located at Linux, Solaris or even mainframe system.
You must have ODBC driver or OLE DB provider to connect your database. For Oracle the program can use native Oracle Call Interface (OCI) instead.
Both tables to be compared must have unique column or set of columns. The primary key will be recognized automatically. Otherwise you should select unique key manually.

Video

Videos

Presentation

Presentations

Click here to download the PDF file.

Files & Media

Media & Files

User Guide:

View User Guide

External Articles:

DTM Database Tools Support Forums

Article DTM Data Comparer

DTM Data Comparer Online Documentation

Price Information

DISCLAIMER

In any case of miss-information between QATestingTools and the manufacturer call-center or website, the manufacturer price is the one you should take in consideration,the QATestingTools is NOT responsible for any miss-understanding or miss-information since we are NOT always informed on prices programs updates. In all cases please get more details from manufacturer.

Contact Manufacturer for exact prices information

KickOff Pricing:

2016: DTM Data Comparer - US $159

2016: DTM Data Comparer - US $949/ 10 licenses

Specifications

Tool Specifications

Application Rights:

Commercial

Demo

User license

Tool Scope:

Testing Methods:

Tool Objectives:

Data Warehouse Testing

Databases Required:

Microsoft® SQL Server

Oracle DB

Operating Systems:

Windows Server

Windows Server 2003

Windows Server 2008

Windows

Windows Vista

Windows XP

Windows 7

Hardware Requirements:

Screen: 800x600

Hard Disk

Hard Disk: 100MB

Supported Technologies:

Database

IBM DB2

MySQL

Oracle

Win32

Data Generator Ability:

Data Manipulation ability

Data Visual Review

Automation Tool Features:

Compare Data between differ formats

User Interface Available:

Command Line

Results Presentation:

Built-in Graphs

Configurable

HTML Reports

Share Reports

Summary Results Display

Reporting Formats:

HTML

MSExcel

TXT

Training:

Blog

Documentation OnSite

FAQ

Forums

Live Chat

OnLine Help

Data Sourcing:

Excel Import/Export

Was This Helpful?:

MANUFACTURERS Wallboard

View MANUFACTURERS Wallboard

Testing tool manufacturers world-wide list
10Levels	ABID CONSULTING	AccelQ	Accord Software	ActiMind	AdaCore
AdaLog	AgileLoad	AgileWay	Agitar	Algorismi	ALL4TEC
Andreas Kleffel	Android	Apache	Apica	Apollo Systems	AppAssist.mobi
Applitools	AppPerfect	Appsee	ApTest	Assertible	Assure
Atlassian	AutoIt Consulti ..	Automation Anyw ..	Automation Cons ..	Axosoft	Aztaz Software
Backtrace I/O	Badboy	BlazeMeter	Borvid	BrowserStack	BSQUARE
BStriker Intern ..	CA Technologies	Canonical	Canoo Engineeri ..	Catch Software	CelestialTeapot
Chris Mallett	Cleanscape	ClicTest	CloudQA	Codeborne	CodeCentrix
CodePlex projec ..	Codoid	Cogitek	Compuware	Configure IT	Conflair
ConSol	Core Services	Countersoft	CresTech Softwa ..	CrossBrowserTes ..	Crosscheck Netw ..
Crowdsourced Te ..	Cucumber Ltd	Cyara	Cygnet Infotech	DareBoost	Databene
Datamatics Glob ..	DevExpress	DTM soft	Dynatrace LLC	EasyQA	Eclipse
EkaTechserv	Elvior	Emmanuel Jorge	Empirix	EPAM Systems	Equafy
Esterel Technol ..	eXept Software ..	Experitest	Finaris	Froglogic	FrontEndART Ltd
GeneXus	GitHub project	gnoso	Google Code Pro ..	GrammaTech	Gurock Software
HelpSystems	HENIX	Hewlett Packard ..	Hexawise	High-Tech Bridg ..	Hiptest
Hitex	IBM Rational	imbus Shanghai	Impetus	Inflectra	informUp
InTENSO - IT Ex ..	Ipswitch	Jamo Solutions	Janova	JAR Technologie ..	JBoss Developer
jClarity	Jellly.io	JetBrains	Jively	jQuery foundati ..	JS Foundation
Jspresso	Kanoah	KMS Technology	Kualitee	LDRA Limited	Litmus
LoadFocus	Loadster Perfor ..	MarathonITE	Marketcircle	Marketcircle	Maveryx
Meliora Ltd	Micro Focus Sof ..	Microsoft	Mobile Labs	Mobile1st	Mockaroo, LLC
Monkop	Mozila	MSys Technologi ..	Navicat	NeoTys	Neowise Softwar ..
NetCart	NORIZZK.COM	Novosync Mobili ..	NRG Global	NTT Resonant	OC Systems
Odin Technology	OpCord	Oracle	Orcanos	Original Softwa ..	OW2
PANAYA	Parasoft	PassMark	Patterson Consu ..	Perfecto Mobile	Pivotal, Inc.
Plutora	Postman (API To ..	PractiTest	PrimaTest	Process One	Programming Res ..
Psoda	PureLoad	PushToTest	Python	Q-Assurance	QA Systems
QACube	QASymphony	QAWorks	QMetry	Quali	Qualitia Softwa ..
Quality First S ..	Quotium	RadView Softwar ..	Ranorex	RedLine13	Reflective Solu ..
ReQtest	RevDeBug	Robotium Tech	Rogue Wave Soft ..	Rommana Softwar ..	RTTS
ruby-doc.org	Runscope	Sandklef GNU La ..	Sauce Labs	Seapine Softwar ..	SeleniumHQ
Sencha	Sensiple	Siemens PLM Sof ..	SmartBear Softw ..	SmarteSoft	SOASTA
SoftLogica	Softomotive	Softsmith	Solution-Soft	SonarSource	Sourceforge
Spirent Technol ..	SQS Software Qu ..	Square	Stimulus Techno ..	Swifting AB	Synopsys
T-komp	T-Plan	TechExcel	TechTalk	Telerik By Prog ..	Tellurium
Test Collab	Test Goat	Test Recon	TestCaseLab	testCloud.de Gm ..	TestCraft Techn ..
Testenium	Testim.io	TestingBot	TestLodge	Testmunk	Testomato
TestOptimal	TestPlant	TestPro	Testuff	The Core Bankin ..	The MathWorks
The Open Group	thePHP.cc	Thoughtbot	Thoughtworks	Tigris.org	Time Simulator
Top-Q	Trace Technolog ..	TrendIC	TRICENTIS	Tritusa Pty Ltd	TWD Solutions P ..
TypeMock	Tyto Software	Ubertesters	UniTESK	Universal Test ..	Usetrace Ltd
Utrecht Univers ..	Validata Group	Vanamco AG	Vector Software	Veracode	Verifaya Corpor ..
Verit	VersionOne	Viewlike.us	Vornex Inc.	Watir.com	WcfStorm Soluti ..
We Are Mammoth	Web Performance ..	Wintask	Wireshark Found ..	Worksoft	Xceptance
XK72	Xpand IT	XQual	ZAPTEST	Zeenyx Software ..	Zephyr
Zeta Software	zutubi pty

Acceptance-testing	Agile-testing
Application-Business-Logic	Automatic-Testing
Behavior-Driven-Development	Benchmark-testing
Black-Box-testing	Business-Flow-testing
Cloud-Based-Testing	Code-Coverage
Code-reviewing	Data-Driven-testing
Distributed-testing	End-to-End-testing
Exploratory-testing	Functional-testing
Hybrid-Testing	Integration-testing
Keyword-driven-testing	Load-Testing
Manual-testing	Model-Based-Testing
Monitoring	Object-Driven-Testing
Performance-testing	Regression-testing
Scalability-testing	Scrum-testing
Smoke-testing	Storyboard-testing
Test-Driven-Development	Traditional-Testing
Unit-testing	White-Box-testing

QATestingTools.com

Main menu

Tool Scope

Testing Methods

Testing Objectives

You are here

DTM Data Comparer

Important Links

Tool Information

Tool Summary

Features

DTM data comparer 150.png

Getting Started

How to compare data with DTM Data Comparer software?

Can DTM Data Comparer compare data in my databases?

Videos

Presentations

Media & Files

Price Information

DISCLAIMER

Tool Specifications

MANUFACTURERS Wallboard

QATestingTools.com

Main menu

SEARCH TOOL

Tool Scope

Testing Methods

Testing Objectives

You are here

DTM Data Comparer

Important Links

Tool Information

Tool Summary

Features

DTM data comparer 150.png

Getting Started

How to compare data with DTM Data Comparer software?

Can DTM Data Comparer compare data in my databases?

Videos

Presentations

Media & Files

Price Information

DISCLAIMER

Tool Specifications

MANUFACTURERS Wallboard