Home > Data management / BI News > Pervasive the most persuasive, cost-effective data integration platform, study says
Data management / BI News:
EMAIL THIS

Pervasive the most persuasive, cost-effective data integration platform, study says

By Jeff Kelly, News Editor
17 Sep 2008 | SearchDataManagement.com

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   

Pervasive Software came out on top in Bloor Research's recent data integration platform and tools rankings, beating out industry titans Oracle and IBM, and integration specialist Informatica, among others.

According to the report, which ranked data integration vendors on cost and use cases, Pervasive's data integration platform offers the lowest total cost of ownership (TCO) among commercial vendors, at just over $500,000 over five years. Only open source data integration technology, which Bloor ranked as one category, bested Pervasive's TCO, but it was plagued by other drawbacks.

Pervasive is ideal for small-scale data integration projects, is itself relatively inexpensive and runs on relatively low-cost hardware, Philip Howard, research director at Northamptonshire, U.K.-based Bloor Research and the report's author, said in an email interview.

"You wouldn't expect to choose [Pervasive] where there are very high-performance requirements or, perhaps, for very large, complex projects, but otherwise they seem to have a broad … capability," Howard said.

Coming in second on TCO at around $1 million over five years was Microsoft SQL Server 2005 Integration Services (SSIS). SSIS comes free with SQL Server but requires additional software infrastructure investments to make it "viable for integration," the report states.

On the other end of the spectrum, Informatica and IBM had the highest TCO of all the vendors considered, at just under $3 million and nearly $4 million over five years, respectively. But the two were more likely to be used in large-scale, complex data integration projects, partly accounting for their higher costs.

The report, which surveyed 212 companies using data integration tools for a variety of purposes, evaluated a total of six commercial vendors: Business Objects, IBM, Informatica, Microsoft, Oracle, and Pervasive. Open source vendors were ranked as one vendor, and respondents using custom code for data integration projects were ranked separately.

Bloor asked respondents how much each spent on initial hardware and software costs, ongoing maintenance, and technical and administrative costs, and how long each project took, among other criteria, in order to determine the TCO for each vendor.

Data migration top integration use case

The Bloor report also identified and ranked the five scenarios for which data integration tools are typically used: data conversion and migration projects; extract, transform and load (ETL), customer data integration (CDI), and master data management (MDM) initiatives; synchronization of data between applications (such as customer relationship management and enterprise resource planning), including Software as a Service (SaaS) applications; B2B data exchange; and implementing service-oriented architectures (SOAs).

Thirty-four percent of respondents said they had used data integration tools for data conversion and migration projects, followed by 23% who reported using data integration tools for ETL, CDI and MDM initiatives. Among both categories, Informatica and IBM were the most popular integration tools of choice.

"There is a lot of interest in [data migration] right now, so I am not actually surprised [that it was the most popular use case]," Howard said. "Also, you tend to get multiple data migration projects each year and over a period of years, where ETL is a single project, even though it may be ongoing for years."

More on data integration
Find out how to sell your boss on master data management

Learn how competency centers streamline data integration projects

Find out how a customer data integration tool helped clear up call center confusion
Application synchronization and B2B data exchange were the third and fourth most popular data integration tools use cases, garnering 18% and 16% of responses, respectively.

At the bottom of the use-case scenario rankings was implementing SOA initiatives, but Bloor cautioned this was due more to a lack of awareness than a dearth of applicable tools.

"We suspect that the general weakness in the SOA arena does not reflect the strength of the various tools but is more a question of the awareness of the need for data services within an SOA environment," the report says.

Open source data integration platforms and tools, though boasting the lowest TCO, did not fare as well when considered on a cost-per-project basis, the report found, "because of relatively low reuse" compared with Pervasive and other commercial tools.

"As open source products add capabilities and get more traction, I would guess that they will close the gap," Howard said. "They cost even less but aren't reused as much – but this is probably [going] to change."



Tags: Customer data integration softwareEnterprise data integration (EDI) softwareExtract transform load toolsMDM best practicesSOA data services and architectureVIEW ALL TAGS

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
Customer data integration software
Six criteria for master data management (MDM) tool evaluation
What's the cost of developing PIM software internally vs. externally?
Top 13 master data management (MDM) buzzwords and definitions
Evaluating and selecting a master data management (MDM) vendor
MDM vendors improve data quality, stewardship, according to Gartner
Tips for planning a data governance strategy and MDM strategy
In customer data integration, is a "customer" always an individual?
EMR systems bring need for data integration, data quality into focus
What is driving MDM investments in the current economy?
Designing the MDM team for an SAP MDM implementation project

Enterprise data integration (EDI) software
Informatica hopes to bridge the business/IT divide with latest release
Data integration for Software as a Service business intelligence software evolves
Yearbook publisher finds BI reporting, data integration tools from same vendor
Efficiencies can be gained at the intersection of middleware and data integration
Data warehouse project leads to data mashups in D.C.
Understanding the latest data integration strategies and technologies
Interest in open source data integration technologies growing
Understanding key data integration trends and business drivers
Informatica acquires complex event processing vendor Agent Logic
Informatica offers data integration software by the hour on Amazon EC2

Extract transform load tools
Data integration for Software as a Service business intelligence software evolves
Efficiencies can be gained at the intersection of middleware and data integration
Interest in open source data integration technologies growing
Informatica offers data integration software by the hour on Amazon EC2
Open source data integration tools good choice for 'standard' ETL jobs
Operational BI gets a boost from real-time data loading
Data integration costs hurting companies with poor negotiation skills
Wholesaler turns to data integration adapters for mainframe to Oracle migration
Integration competency centers centralize data integration projects
Data warehouse case study: Midsized insurer goes enterprise with data warehouse

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Data Management: Business Intelligence, Data Integration, Data Compliance
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts