Enterprise data integration software: EDI definitions you need to know
Kathryn Marquis, Assistant Editor
05.31.2007
Rating: -4.44- (out of 5)
Enterprise data integration includes a variety of unique -- yet related -- technologies known by a slew of acronyms. The terms defined below help clarify the broad practice of data integration and introduce some of the methods that support an enterprise data integration project.
- Enterprise data integration (EDI) (not to be confused with electronic data interchange, also commonly known as EDI) is the broad set of technologies that help combine, or integrate, two or more data sets. EDI typically involves merging data from disparate systems and delivering that combined data in such a way that it can be manipulated and analyzed to support information management activities, such as business intelligence or reporting. Read about the costs and benefits of data integration software versus hand coding.
- Extract, transform, load (ETL) refers to three separate database functions used to collect data for analysis, reports or other uses. First, the requested data is read and extracted from a source database. Next, it is it transformed using business rules into the desired state. Finally, the transformed data is loaded into a target database or data warehouse where is can be accessed by other applications or users. Learn about the pros and cons of custom code versus the use of an ETL tool or read a study that reports ETL tools are transforming.
- Enterprise application integration (EAI) enables data propagation and business process execution across various applications to support complex operational business functions such as fulfilling a customer order. It aims to allow changes in one application to propagate across all systems across an enterprise as if they were one global application – its goal is to ultimately deliver one consistent version of the data. Read about EAI's role in SOA and decentralized IT systems.
- Enterprise information integration (EII) is a strategy for making enterprise-wide data operative and manageable. This integration technology uses query federation to allow information gathered from various sources to be accessible
To continue reading for free, register below or login
To read more you must become a member of SearchDataManagement.com
| |
