The Insider's Guide to Next-Generation BPM
By Somnath Basu, Project Manager, Infosys Technologies , 12/25/2005
Print this article
Email this article
Talk Back!
Write to Editor
INTRODUCTION
This document aims to compare the two widely used Integration Technologies, EAI and ETL.
Although both ETL and EAI technologies seem surprisingly similar from an architectural view - where so-called adapters (or connectors) provide access to systems and data sources transformations take place to standardize proprietary formats, or routing capabilities are used to move packets of data - ETL and EAI serve fundamentally different purposes from an information management perspective.
ETL is typically used to move bulk data from application systems to data warehouses or data marts (all in a highly scheduled environment to avoid generating bottlenecks from high-volume transactions) while EAI is the technology of choice to connect systems for business process management and workflow.
EAI AND ETL DEFINITIONS
EAI: Acronym for Enterprise Application Integration, EAI involves integration of incompatible business applications within and beyond enterprise to allow them to talk to each other seamlessly and to share data in real time.
EAI is usually deployed to allow real-time system users to access the data and functionality in legacy systems in a way that ensures consistency of access and update regardless of the data source. For example EAI (like Vitria, SAP XI) would be used to propagate single logical operation, such as a preferred address change to the many systems that hold preferred addresses for the customer in question.
Put simply, EAI exist to allow client applications to operate on data from across the business without regard to its location, encapsulating technology or format.
ETL: Extraction, Transformation and Loading (ETL) are three database functions that are combined into one tool (like Informatica) to pull data out of source databases and place it into target databases. ETL is used to migrate data from databases to others, to form data marts and data warehouses and also to convert databases from one format or type to another.
ETL is used within the business domain of management reporting for the process of collating business data from many sources and loading it into a form from which ad hoc queries and reports can be generated.
Put simply, ETL exist to allow client applications to query data from across the business without regard to its location, encapsulating technology or format.
COMPARING ETL AND EAI
-1-
Best Practices in Moving Processes to the Clouds
How Can the Cloud Fit Into Your Applications Strategy?
Cloud Data Integration Best Practices
The Economics of Cloud Computing
Data Services Insight: Successful implementation of Canonical Information Models
Can OSS Integration Server Software Enable EAI/BPM? 
Consolidating Data Integration Architectures With Metadata Acquisitions
Application Development: Challenges and Opportunities in 2006
The Flexibility of XML-Based Rich Clients
Achieving Semantic Interoperability
Your Pocket Guide to Semantics, Ontologies, and Application to SOA
ebizQ editorial highlights and updates, compiled by Site Editor Anne Stuart
March 10, 2011
The sixth annual BPM in Action 2011 Virtual Conference will explore cutting-edge market developments in BPM and describe how to leverage them for improved business operation and performance. More
Date:Apr 07, 2010
Time:13:00 PM
ET- (17:00 GMT)
Date:Apr 07, 2010
Time:12:00 PM
ET- (16:00 GMT)
In part two of Joe McKendrick's recent podcast with Miko Matsumura, chief strategist for Software AG, they talk about how SOA and IT systems need to change and grow and adapt with the organization around it.
Listen Now
Phil Wainewright interviews David Vap, VP of products at RightNow Technologies, and finds out how sharing best practices can help businesses understand how best to engage with online communities.
Listen Now
Scott Hebner, Vice President of Marketing and Strategy for IBM Rational, discusses a topic on the top of every company's mind today: getting the most from IT investments.
Listen Now
In BI, this tough economy and the increasing role of Web 2.0 and MDM are certainly topics on people's minds today. WiseAnalytics' Lyndsay Wise addresses each of them in this informative podcast.
Listen Now
Deepak Singh, President and CTO of Adeptia, joins ebizQ's Dennis Byron in a podcast that gets its hand around the trend of industry-specific BPM.
Listen NowSmart event processing can help your company run smarter and faster. This comprehensive guide helps you research the basics of complex event processing (CEP) and learn how to get started on the right foot with your CEP project using EDA, RFID, SOA, SCADA and other relevant technologies. Learn More
A lot of people are talking about Enterprise 2.0 as being the business application of Web 2.0 technology. However, there's still some debate on exactly what this technology entails, how it applies to today's business models, and which components bring true value. Some use the term Enterprise 2.0 exclusively to describe the use of social networking technologies in the enterprise, while others use it to describe a web economy platform, or the technological framework behind such a platform. Still others say that Enterprise 2.0 is all of these things. Learn More
|
|
This new publication from our sister site SearchSOA.com explores workflow, business activity monitoring (BAM) and complex event processing (CEP) issues. |
|
|
