Home > Data management / BI News > Efficiencies can be gained at the intersection of middleware and data integration
Data management / BI News:
EMAIL THIS

Efficiencies can be gained at the intersection of middleware and data integration

By Jeff Kelly, News Editor
08 Oct 2009 | SearchDataManagement.com

News on data management trends and technology
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google

LOS ANGELES -- The application development team has its job, and the data integration team has its job, and never the two shall meet. Or at least that's how it is at most organizations. But it shouldn't be.

With better communication between the groups, significant efficiencies in data integration and applications messaging, or middleware, can be gained, said Ted Friedman, an analyst with Stamford, Conn.-based Gartner, in an interview at Gartner's MDM Summit in Los Angeles.

Middleware, Friedman explained, is software that allows applications to communicate with one another, or send messages back and forth, often in real time, to initiate an action of some kind. It is also sometimes called enterprise application integration (EAI).

Middleware is at use, for example, when a bank assesses a customer's creditworthiness. One application considers the customer's credit history, and if certain conditions are met, middleware allows the application to communicate with another application to continue the process, and so on.

More on data integration
Get the latest on data integration trends from expert Rick Sherman

Find out why interest in open source data integration is growing
Middleware, or EAI, is the "glue" that enables applications running on different platforms to communicate, Friedman said.

In a classic middleware transaction, data itself is not transferred from one location to another, however. That's where data integration -- software that identifies, transforms and moves data from point A, like a transactional database, to point B, such as a data warehouse – comes into play.

But the two disciplines (middleware and data integration) have a number of commonalities, and Friedman said it is to the benefit of both the application development groups and the data integration teams to open up lines of communication to see where they can help each other.

"The two worlds are definitely overlapping," he said. "Over time, we will distinguish between them less."

For example, extract, transform and load (ETL) tools are traditionally used to integrate data in batch from one source to another. But ETL tools are not ideal for real-time movement of data. Middleware solutions such as Oracle BEA's Weblogic and IBM's WebSphereMQ, which facilitate real-time communication between applications, can be used to supplement this process, Friedman said.

Likewise, when data, not just messages, needs to be shared between applications that communicate via middleware, data integration tools can help.

Friedman therefore encourages application development teams and data integration workers to initiate a conversation about the tools and software at use in both groups to avoid making costly, redundant investments in technology. And at a time when IT budgets are tight, making better use of the technology an organization already has is a must.

The convergence of traditional middleware and data integration technology also has ramifications for vendors, Friedman said. Data integration specialists like Informatica will increasingly find it difficult to compete with the likes of IBM and Oracle, which offer both middleware solutions and data integration tools.

IBM has its WebSphere MQ middleware product, as well as its IBM Information Integration platform. Oracle, meanwhile, recently launched the latest version of its Fusion Middleware platform and acquired middleware extraordinaire BEA Systems last year. It also boasts its Oracle Integrator platform and is in the process of acquiring data integration vendor Golden Gate Systems.

"Informatica is finding it harder in competitive situations with IBM and Oracle," Friedman said. "That could be a pain point for Informatica."

Friedman said he wouldn't be surprised to see Informatica and other data integration-only vendors make strategic if small investments in EAI technology to improve their competitive positions.



Tags: Enterprise application integration softwareEnterprise data integration (EDI) softwareExtract transform load toolsVIEW ALL TAGS

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



RELATED CONTENT
Enterprise application integration software
A growing integration service providers market gives customers better choices, lower prices
Integration competency centers centralize data integration projects
Informatica to buy identity resolution software maker for $85 million
Companies choosing real-time data integration over batch-oriented techniques
Enterprise data integration quiz
Gartner data integration Magic Quadrant 2007: Platforms, market expand
Enterprise data integration software: EDI definitions you need to know
Data integration software vs. hand coding: Balancing costs and benefits
A guide to enterprise resource planning for IT managers
SOA and decentralized IT systems

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
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
Oracle's GoldenGate acquisition underlines demand for real-time data integration capabilities

Extract transform load tools
Data integration for Software as a Service business intelligence software evolves
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
Pervasive the most persuasive, cost-effective data integration platform, study says
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