DMExpress

From Wikipedia, the free encyclopedia

DMExpress is an ETL 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 [1]. It can integrate from multiple sources to multiple targets, and supports all the major database engines, including Oracle, Sybase, DB2, Informix, Microsoft SQL Server and Teradata.

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 [2].

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

[edit] Syncsort

Syncsort is the company that produces DMExpress. According to a press release, 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.