Apatar Announces Connectivity to Vertica Analytic Database

Apatar, a vendor of open source tools for data integration, today announced connectivity to the Vertica Analytic Database (News - Alert), a grid-based column-oriented database management system used for analytics and business intelligence.

 

The new connector lets developers and users migrate data between the Vertica Analytic Database and third-party applications “without any custom coding,” and allows for this data to be “filtered, validated, and cleansed,” company officials say.

 

According to Gartner (News - Alert) studies cited by Apatar, 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 towards improving data quality until 2010.

 

Saying “huge amounts of corporate data are scattered across enterprises and becoming outdated too rapidly,” Apatar officials say the connector for Vertica “can help companies synchronize data before delivering it to decision-makers.”

 

“Businesses are asking more questions against ever-growing volumes of data from multiple sources,” said Colin Mahony, senior director of business development for Vertica. “Vertica’s Analytic Database lets companies store terabytes of information with fast query response times.”

 

Prior to entering into the Vertica Analytic Database, data can be filtered, validated and cleansed using Apatar’s data quality capabilities. Now both Vertica users and administrators can de-duplicate data received from multiple sources, verify e-mail and postal addresses, check customer socio-economic parameters, and more.

 

“Most data integration projects fail, exceed allocated budgets or cannot be delivered in time, and never get built,” said Renat Khasanshyn, founder and chief executive officer of Apatar.

 

Last month Knowledge Integration Dynamics, a Johannesburg-based company selling business intelligence, data warehousing and products, concluded a partnership agreement with Apatar to distribute its open source data integration suite in South Africa.

 

KID will train and offer support services for the Apatar integration package for integration projects across Mac OS, Windows and Linux.

 

“South Africa is a developing region, and it is important for us to fill the open source data integration niche,” said Sergei Lobanov, Alliance Enabler at Apatar.

 

Apatar already has in excess of 100 users in South Africa and expects KID to rapidly expand its penetration of the local market. KID is Apatar’s first South African partner.

 

The companies say they’ll be targeting small and mid-sized companies in South Africa with a need for a free, easy-to-use extract, transform, and load tool. They’ll be pushing Apatar’s visual job designer and visual transformation mapper, which are 100 percent Java-based and “obviate the need for coding of any kind,” Apatar officials say, reducing the need for technical skills.