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

Meet Syncsort DMX

Integrate ALL Your Data with NONE of the Hassle !

DMX-h Release 8

One software environment to manage your entire data pipeline

Extract, transform and load more data faster, 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.

 

Integrate all data across your organization

RDMBS, Mainframe, NoSQL, the Cloud, Hadoop and more!

Integrate all Data

Joining, blending and integrating data – legacy or new, big or small, with or without Hadoop – is easy with DMX. With enhanced support for mainframe, legacy and Big Data sources; plus a no-code approach to efficiently join datasets with maximum performance and highest resource efficiency. A common user experience across single and distributed environments means you can create your own data blends with consistent, sustainable performance.

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 ETL engine. Transformations are processed on the fly, eliminating the need for costly database staging areas or manually pushing transformations to the database.

Free up your database

Popular Use Cases

Solve your data integration challenges

Popular use cases
  • EDW Offload: Easily offload batch workloads from the data warehouse with our SILQ web-based utility.

  • Cloud ETL: Ironcluster ETL takes away the complexity of data integration, delivering a much more agile ETL environment with the capacity you need, when you need it.

  • Rehosting Optimization: Accelerate mainframe migrations by safely addressing critical data manipulation & performance requirements.

Integration with Visualization tools and Enterprise Data Warehouses

Syncsort DMX delivers a complete solution that makes it easier than ever to distribute your data by loading aggregated datasets to all major MPP appliances or directly feeding it to your favorite data visualization tool.

  • Create QlikView Data Exchange (QVX) and Tableau Data Extracts (TDE) files with one click, for best-in-class data discovery, analysis and visualization.
  • High performance connectivity to achieve the fastest data loads without tuning hassles. In addition to its best-in-class connectivity to Teradata and Vertica, including:
    • Parallel load to Greenplum: Automatically partition and load using psql COPY command to parallelize loading
    • Parallel load to Netezza: Automatically partition and load data using multiple streams
    • Parallel INSERT for Oracle: Insert data in parallel without locking the tables
    • Plus high-performance connectivity for Big Data and NoSQL databases such as Cassandra, HBase and MongoDB
Visualization tools

Optimize your solution with Intelligent Execution

Data Transformation

DMX is the only data integration tool with Intelligent Execution. 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. Intelligent Execution automatically adapts and optimizes itself to the exact characteristics of any particular job and system, whether on premises, in the cloud, or even Hadoop.

The result is 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.

Easily offload batch workloads from the Data Warehouse with SILQ

Syncsort offers a unique SQL offload utility, SILQ, specifically designed to overcome the challenge of understanding and documenting massive amounts of SQL code and mastering the skills to offload these transformations.

SILQ is a web-based utility that takes SQL as an input and provides a fully integrated analysis of ELT SQL jobs, including:

  • Detailed chart of entire data flows helps you identify, understand and document SQL workloads suitable for offloading
  • Best practice recommendations to build more efficient data flows
  • Automatic SQL-to-DMX conversion to fast-track your development efforts, with equivalent DMX jobs that you can then deploy on virtually any platform, including Hadoop

 

Smarter Metadata

Request a Demo of DMX

Simply fill out the form and one of our Product Experts will be in touch!


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

    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