Syncsort Hadoop Solutions

Syncsort’s Hadoop ETL Solution extends the capabilities of Hadoop, turning it into a highly scalable, affordable, and easy-to-use data integration environment.

• Connect to any data source or target
• Exploit mainframe data
• Develop MapReduce ETL jobs without coding
• Jump-start your Hadoop productivity with use case accelerators to help you build common ETL tasks
• Build, re-use, and check impact analysis with enhanced metadata capabilities
• Optimize performance and efficiency of each individual node
• Never tune again

Learn More about Hadoop ETL

Syncsort DMX-h dramatically simplifies and secures the process of accessing and integrating mainframe data with Hadoop MapReduce and Apache Spark.

• Get mainframe data into Hadoop and work with it like any other data source!
• Directly access and interpret VSAM files, mainframe fixed and variable files, and DB2 data without modifying it from its original format
• Avoid a complex learning curve with DMX-h's easy-to-use Graphical User Interface
• Secure the entire process with support for FTPS Connect:Direct data transfers, Kerberos, LDAP, or integration with Apache Sentry.

Learn More about Mainframe Access & Integration

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 practices recommendations to build more efficient data flows
• Automatic DTL generation to fast-track your development efforts, with equivalent DMX-h jobs that you can then deploy on virtually any platform, including Hadoop

Learn More about SILQ