Apatar, a provider of open source tools for data integration, has announced connectivity to the Vertica Analytic Database (
News -
Alert), a grid-based column-oriented database management system used for analytics and business intelligence.
With the new connector, developers and business users can migrate data between the Vertica Analytic Database and third-party applications, according to the companies. Apatar officials said that this functionality eliminates the need for any custom coding and allows for the data to be filtered, validated and cleansed.
Gartner (
News -
Alert) reports that more than 25 percent of critical data in Fortune 1000 companies is inaccurate, incomplete, or duplicated, and three-quarters of large enterprises will make little to no progress toward improving data quality until 2010.
A large part of corporate data are scattered across enterprises and becoming outdated, according to Apatar officials. Using connector for Vertica, companies can synchronize their critical data before delivering it to decision-makers.
Colin Mahony, senior director of business development at Vertica, said that Vertica’s Analytic Database enables companies to store terabytes of information with blazingly fast query response times.
“With Apatar’s visual designer and integration tools, it becomes extremely easy to extract and load large volumes of data into Vertica quickly for rapid analysis,” Mahony said.
One of the benefits of Apatar open source data integration is that it can be distributed under an open source model. Also, it features job scheduler and synchronization that automate the data integration process.
Officials said that prior to entering into the Vertica Analytic Database, data can be filtered, validated, and cleansed using Apatar’s data quality capabilities.
The ease of “drag-and-drop” integration saves time and allows for these operations to be performed even by non-technicians, officials said.
“Most data integration projects fail, after they exceed allocated budgets or cannot be delivered in time, and never get built,” said Renat Khasanshyn, founder and chief executive officer of Apatar.
He said that combining Vertica’s performance and ease of use with Apatar’s visual data quality and integration features, enterprises can accelerate decision-making and provide the quality and completeness of their most critical information timely, before it’s too late.
Anshu Shrivastava is a contributing editor for TMCnet. To read more of Anshu's articles, please visit her columnist page.