DMExpress is an ETL

Extract, transform, load

Extract, transform and load is a process in database usage and especially in data warehousing that involves:* Extracting data from outside sources* Transforming it to fit operational needs...

 tool designed primarily for performance. It processes data using proprietary algorithms instead of the database engine. It is able to generate code in C, C++, Visual Basic, Kornshell and SQL to carry out ETL tasks . It can integrate from multiple sources to multiple targets, and supports all the major database engines, including Oracle

Oracle database

The Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....

, Sybase

Sybase

Sybase, an SAP company, is an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile applications development platforms....

, DB2

IBM DB2

The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix , Linux, IBM i , z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions...

, Informix

Informix

IBM Informix is a family of relational database management system developed by IBM. It is positioned as IBM's flagship data server for online transaction processing as well as integrated solutions...

, Microsoft SQL Server

Microsoft SQL Server

Microsoft SQL Server is a relational database server, developed by Microsoft: It is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network...

 and Teradata

Teradata

Teradata Corporation is a vendor specializing in data warehousing and analytic applications. Its products are commonly used by companies to manage data warehouses for analytics and business intelligence purposes. Teradata was formerly a division of NCR Corporation, with the spinoff from NCR on...

.

Released in November 2004, DMExpress uses "patented algorithms, state-of-the-art parallel processing technology, and dynamic optimization" to achieve high performance (press release). It "extracts data at very high speed from any source database or flat file, applies any kind of record level transformation and/or field level transformation, and then loads the data into any target database or flat file". The speed comes primarily from highly specialised sorting technology previously developed by the company and adapted to the task of ETL.

On November 14, 2008, DMExpress set a world record for ETL performance by extracting, transforming, cleansing, and loading 5.4 TB of data into a Vertica

Vertica

Vertica Systems is an analytic database management software company. Vertica was founded in 2005 by database researcher Michael Stonebraker, and Andrew Palmer; its President and CEO is Christopher P. Lynch. HP announced it would acquire the company in February 2011. On March 22, 2011, HP completed...

 Analytic Database on a c-Class HP BladeSystem in 57 minutes . Microsoft

Microsoft

Microsoft Corporation is an American public multinational corporation headquartered in Redmond, Washington, USA that develops, manufactures, licenses, and supports a wide range of products and services predominantly related to computing through its various product divisions...

 and Unisys

Unisys

Unisys Corporation , headquartered in Blue Bell, Pennsylvania, United States, and incorporated in Delaware, is a long established business whose core products now involves computing and networking.-History:...

 set the previous ETL world record at 2.36 TB/hr in early 2008 .

The pricing structure of the product is such that customers pay the first five years of support up front .

Syncsort

Syncsort

Syncsort

Syncsort Incorporated is a software company specializing in high speed sorting products, as well as data integration and backup software and services, for Windows, Unix, Linux, and mainframe systems. According to its website, Syncsort products are used by over 90 of the Fortune 100 companies and...

is the company that produces DMExpress. The company has been around for nearly 40 years , and counts most of the Fortune 500 companies amongst its customers.

Syncsort provides telephone and on-site customer support for DMExpress.