Feeds

Your mainframe's pegs not fitting in Amazon's elastic holes? Syncsort has a hammer for that

FOA CTO/CIO: ETLaaS AWS EC2

Gartner critical capabilities for enterprise endpoint backup

Syncsort wants to make life easier for Amazon cloud compute users who use data stored in mainframe storage silos and similar kit.

Its solution? ETLaaS – or Extract, Transform and Load (ETL) as a Service.

ETL products take data from a source, convert it as required, and then transfer it into the target system for processing. They are needed because the target system doesn’t have the data stored in the right way for its software, and the source system doesn’t have the compute applications to process the data it has stored.

Syncsort, originally a mainframe data sorting company, specialises in ETL products with its DMExpress line, recently rebranded DMX. A DMX-h product offers Hadoop data sorting. We can envisage mainframe data sources having information fed through ETL, and then processed by x86 server-based applications.

In November, Syncsort announced a DMX-h for Amazon’s Elastic Map Reduce (EMR), calling it Ironcluster Hadoop ETL. This extracted and transformed data from on-premises systems and loaded it up into Amazon’s cloud for EMR to process it.

Syncsort then stated: “Ironcluster will make it simple for customers to offload their expensive and inefficient data processing workloads from legacy data warehouses and mainframe systems into Amazon EMR. Customers will also be able to seamlessly move high-performance data processing workloads between Ironcluster on Amazon EMR and Ironcluster running within a customer’s data centre on Hadoop.”

Now Syncsort has extended Ironcluster to support Amazon’s EC2 (Elastic Compute Cloud) “targeting the legacy ETL and data warehousing market with a cloud-based enterprise grade data integration engine for Amazon EC2 and Amazon Redshift”.

Syncsort’s CEO, Lonne Jaffe, said in a canned quote: "Customers are looking to move data workloads from expensive, inefficient legacy systems into low cost Amazon Redshift and Amazon Elastic MapReduce environments, and we’re helping make that transition seamless and secure.”

Source data stores can include legacy data warehouses, ETL suites and mainframe systems. Targets include Amazon’s Redshift data warehouse. Syncsort claims “users of the new Ironcluster ETL for EC2 can experience up to a 75 per cent reduction in processing time and total cost of ownership when compared to legacy ETL approaches and tools”.

The product also provides connectivity for Amazon’s S3 and DynamoDB.

It seems more and more data is accelerating up the on-ramp to cloud-based processing apps. Once customers get used to processing data in the cloud, they’ll think more positively about storing copies of their files in third parties' off-site systems, and then storing all their data in the cloud.

And then the solid rock that was their on-premises storage arrays will be revealed as a fragile eggshell from which the contents have been sucked out, leaving just the shell to implode.

Ironcluster ETL is available on the AWS Marketplace at no additional charge for small instances and at a low price, it claims, for medium and large instances. There is a free trial available here. ®

Secure remote control for conventional and virtual desktops

More from The Register

next story
The Return of BSOD: Does ANYONE trust Microsoft patches?
Sysadmins, you're either fighting fires or seen as incompetents now
Microsoft: Azure isn't ready for biz-critical apps … yet
Microsoft will move its own IT to the cloud to avoid $200m server bill
US regulators OK sale of IBM's x86 server biz to Lenovo
Now all that remains is for gov't offices to ban the boxes
Flash could be CHEAPER than SAS DISK? Come off it, NetApp
Stats analysis reckons we'll hit that point in just three years
Oracle reveals 32-core, 10 BEEELLION-transistor SPARC M7
New chip scales to 1024 cores, 8192 threads 64 TB RAM, at speeds over 3.6GHz
Object storage bods Exablox: RAID is dead, baby. RAID is dead
Bring your own disks to its object appliances
Nimble's latest mutants GORGE themselves on unlucky forerunners
Crossing Sandy Bridges without stopping for breath
prev story

Whitepapers

Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Top 10 endpoint backup mistakes
Avoid the ten endpoint backup mistakes to ensure that your critical corporate data is protected and end user productivity is improved.
Top 8 considerations to enable and simplify mobility
In this whitepaper learn how to successfully add mobile capabilities simply and cost effectively.
Rethinking backup and recovery in the modern data center
Combining intelligence, operational analytics, and automation to enable efficient, data-driven IT organizations using the HP ABR approach.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.