Gartner Suggests Rationalizing Data Integration Tools to Cut Costs
Optimizing a fragmented approach
The market for application, integration, and messaging software is estimated to be $8.5 billion (Gartner, June 2006), while the market for the support of these products is valued at $132 billion. According Gartner’s latest press release, rationalizing data integration tools can save companies more than $500,000 annually. The company suggests adopting a shared-services model in the long run.
Most companies often purchase and implement new data integration tools in a fragmented way—without extending investments already made in other parts of the business. This results in multiple tools from different vendors and, consequently, loads of money on licensing and maintenance.
Taking into account today’s focus of organizations and industries on cost optimization, fragmented approach to data integration should be reviewed in order to increase efficiency and reduce expenses. Here is what Ted Friedman, a distinguished expert at Gartner, says:
“The first step is for IT teams focused on data integration to save money by rationalizing tools. Further, there is a greater longer-term opportunity to substantially reduce costs and increase efficiency and quality by moving to a shared-services model for the associated skills and computing infrastructure.”
Gartner recommends three elements executed to implement this:
- Planners should rationalize across the three main categories of data integration tools: extraction, transformation, and loading (ETL); data replication; and data federation, ideally arriving at a standard tool for each of these styles of data delivery. They should decide which tools to keep and which to discontinue based on the business context and requirements, rather than blindly rationalizing wherever possible based purely on cost.
- Centralize data integration computing infrastructure to avoid redundant servers and storage caused by deployment of each tool on dedicated hardware. Many organizations can make substantial savings on computing capacity by implementing shared computing infrastructure for data integration workload.
- Gartner recommends that organizations centralize data integration roles and skills into a shared-services team model to reduce staffing costs directly by 50% or more each year.
Ted Friedman stresses that rationalization should not be limited to one business unit, and that CIOs and data integration teams should work together to lead the rationalization and shared-services program.
Open source is good for ETL
According to Ted Friedman, more and more companies start considering open-source IT technologies as the economy continues sliding down. Surely, it’s done to keep costs down, which is a major driver of open-source technologies of all kinds, including open-source data integration software.
However, one should take into account that open-source data integration tools are not absolutely cost-free. You don’t have to buy licenses from open-source software providers, what you certainly have to do dealing with their commercial counterparts. Customers still must pay for support and maintenance and for internal manpower to run and monitor the software.
There is one more thing one should take into account with regards to open-source software, according to Friedman:
“We definitely are seeing an increased interest in open-source tools in the data integration space.”
Most open-source data integration software is geared to traditional extract, transform, and load (ETL) methods. As for data virtualization and enterprise information integration, real-time data integration methods (e.g., change data capture) are not well represented, at least at this point, in the open-source community. Open-source metadata management capabilities are also “lighter” than most on-premises variants.
There is a continuous growth of interest in open-source ETL and other open-source technologies, as the recession continues to put pressure on IT departments to do more with fewer resources.
Friedman’s recommendation for companies is to consider open-source data integration software to reduce costs “when your requirements map well to the level of maturity of the open-source solution,” which, as he reiterated, are mostly geared to standard ETL.