DMX™

Smarter data integration

DMX is now Connect ETL

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.

Connect ETL 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 Connect ETL. Get your data where you need it without long ETL development cycles or slow execution times.

Learn more about Connect ETL

Move hundreds of tables at once with DataFunnel™

DMX is now Connect ETL

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 Connect ETL engine, so you get optimal performance every time with no coding or tuning.

Learn more about Connect ETL

Optimize with Intelligent Execution

DMX is now Connect ETL

Syncsort’s Connect ETL 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, Connect ETL dynamically selects the most efficient algorithms based on the data structures and system attributes at run-time.

Intelligent Execution means Connect ETL 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.

Learn more about Connect ETL

Integration with visualization tools and EDWs

DMX is now Connect ETL

Connect ETL 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. Connect ETL 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.

Learn more about Connect ETL