Marketing Cookie wrote!
Syncsort Big Data Software : DMX - A Smarter Approach to Data Integration
Contact Syncsort

Meet Syncsort DMX

A Smarter Approach to Data Integration !

DMX-h Release 8

DMX is Smarter Data Integration!

Extract, transform and load more data in less time, with less money and fewer resources

DMX reduces the cost and complexity of data integration by freeing up database capacity, delivering up to 10x faster performance, and eliminating the need for manual coding and tuning.


Extract more value from your mainframe data

Smarter Mainframe Connectivity & Data Transformation

Mainframe Connectivity

Most large organizations still rely on mainframe to run their core applications, generating massive amounts of transaction data every day. Neglecting this data can result in missed business opportunities. Unfortunately, collecting, transforming and processing mainframe data is not trivial and most ETL tools don’t even support native mainframe connectivity.

DMX leverages decades of mainframe experience, to help you extract more value from your mainframe data. DMX provides high-performance connectivity to move data in and out of the mainframe. Moreover, mainframe users can use the FilePort utility to automatically transform mainframe data to UNIX format and vice versa.  The data to be converted can contain any combination of character, decimal, packed decimal and binary fields. FilePort runs on all major UNIX systems.

Free Up Your Database!

Smarter Data Integration

Underperforming ETL tools have forced many IT developers to push transformations down to the database, adding complexity and requiring massive investments in additional database capacity. DMX brings all data transformations into a high-performance, in-memory ETL engine. Transformations are processed on the fly, eliminating the need for costly database staging areas or manually pushing transformations to the database.

Smarter Data Integration

No Tuning Required, Simply Faster!

Smarter ETL Optimizer

Smarter ETL Optimizer

DMX is the only data integration tool with a Smart ETL Optimizer. Conventional data integration tools are manual and static, with every change requiring constant tuning to maintain performance SLAs. By contrast, DMX dynamically selects the most efficient algorithms based on the data structures and system attributes it encounters at run-time. The ETL optimizer automatically adapts and optimizes itself to the exact characteristics of any particular job and system.

A Smart ETL Optimizer means you always get maximum performance with minimum CPU and memory utilization, out-of-the-box, allowing you to shift your most skilled developers to more value-added activities.

Faster data transfers with less CPU utilization

Smarter I/O for Faster Data Connectivity

Every ETL process is ultimately I/O bound, especially at the end points of a job: extracting the data from the source and loading it into the target. Unlike any other ETL tool, DMX incorporates Smart I/O capabilities for many file systems and storage systems (e.g. storage array networks). Smart I/O bypasses the operating system buffer cache enabling a more efficient transfer of larger blocks of data. The results are faster data transfers with less CPU utilization.

DMX provides high-performance connectivity to virtually any source and target, including all major RDBMS systems, MPP appliances, flat files, XML files, HDFS, mainframe sources, and more.

Data Connectivity

Deal with the most demanding data integration transformations and functions

Smarter Data Transformations for 10x Faster Performance

Data Transformation

Most ETL tools implement only few algorithms to deal with data transformations. DMX packages a library of hundreds of smart algorithms to deal with the most demanding data integration transformations and functions, including sorting, aggregating, joining, parsing, hashing, and pattern-matching.

Users typically experience up to 10x faster elapsed processing times than conventional data integration tools and up to 25x faster than hand-coding approaches with linear scalability to support rapid data growth and changing business requirements.

Related Solutions

  • DMX Whitepaper

    DMX Technical White Paper

    Learn how DMX can help you collect and process more data, in less time, and with fewer resources.

    Learn more
  • Videos


    Check out our collection of Big Data videos.

    Learn more
  • Data Warehouse Offload to Hadoop

    Data Warehouse Offload to Hadoop

    Need more from your data warehouse? Set it free with the Syncsort Data Warehouse Offload Solution.

    Learn more