DMX™

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 ETL engine. Transformations are processed on the fly, eliminating the need for costly database staging areas or manually pushing transformations to the database, and you can create your own data blends with consistent, sustainable performance.

Integrate all data across your organization RDBMS, mainframe, NoSQL, the Cloud, Hadoop and more, with DMX. Get your data where you need it without long ETL development cycles or slow execution times.

Move hundreds of tables at once with DataFunnel™

Defining import jobs for the hundreds or even thousands of tables you need to move can take hundreds of hours with traditional ETL tools. Syncsort’s DataFunnel lets you point, click and onboard entire schemas from a relational database in minutes.

Import data from sources such as DB2, Oracle, SQL Server, Teradata, Netezza, and Redshift, and write them to databases like SQL Server or Postgres. Write to Cloud targets like Redshift or Amazon S3. DataFunnel lets you transform and cleanse data in-flight, without staging data by using the high-performance DMX ETL engine, so you get optimal performance every time with no coding or tuning.

Optimize with Intelligent Execution

Syncsort’s DMX is the only data integration tool with Intelligent Execution. While traditional integration tools are manual and static, with every change requiring constant tuning to maintain performance SLAs, DMX dynamically selects the most efficient algorithms based on the data structures and system attributes at run-time.

Intelligent Execution means DMX automatically adapts and optimizes itself to the exact characteristics of any particular job and system, whether on-premises, in the cloud, or even on Hadoop. The result is maximum performance with minimum CPU and memory utilization, out-of-the-box, saving you money by freeing up your most skilled developers to more value-added activities.

Integration with visualization tools and EDWs

DMX delivers a complete high performance integration solution that lets you load aggregated datasets to all major MPP appliances, or directly feed data to your favorite data visualization tool. Create QlikView Data Exchange (QVX) and Tableau Data Extracts (TDE) files with one click for lightning fast discovery, analysis and visualization.

You can do parallel inserts to Oracle without locking the tables. You can automatically partition and load into Greenplum and Netezza for the fastest data loads possible. Syncsort’s DMX gives you best-in-class loads to a wide variety of analytics databases including Teradata, Vertica, Greenplum, Netezza, Oracle, and NoSQL databases such as Cassandra, HBase and MongoDB.