What is Data Integration?
In today's competitive marketplace,
it is essential to have an accurate, up-to-date,
flexible environment in which to assess the business
and make strategic decisions for the organization.
The best way to do this is through an integrated
environment. But integration can take on many
forms. With the ever-changing options available
technically, businesses need to decide how to
integrate their data, whether it is real time,
near real time, application to application, or
another way. There are three main types of integration:
Extract Transform and Load (ETL), Enterprise Application
Integration (EAI), and Enterprise Information
ETL refers to a process of extracting
data from source systems, transforming the data
so it will integrate properly with data in the
other source systems, and then loading it into
the data warehouse. ETL is either batch, near
real-time, and sometimes real-time. Enterprise
Application Integration (EAI) combines separate
applications into a cooperating federation of
applications – by placing a semantic layer
on top of each application that is part of the
EAI infrastructure. EII allows information to
appear as a virtual relational database.
||No. Transactions applied
directly to applications' tables
||No. Virtual database
||Managerial reporting, trend analysis,
||Near real time synchronization of operational
data where transaction commitment dependent
on state of related transactions
||Near real time decision making based on
most current information in operational
systems. No update.
|What it's not
||Not source of record.
Does not support transaction processing
||Not appropriate for
ad-hoc analysis and reporting
||Not a virtual data warehouse
is Data Integration Important?
Applications are often dependent
upon data in other applications, but lack the
ability to access this data. In addition, external
data sources such as research reports, that are
integrated into corporate information can be a
valuable complement to the business. Integration
is the key component of this process and choosing
the correct integration strategy is paramount.
Factors such as latency, consistency and time
to market weigh into the integration strategy.
What is the Value of
By removing the technology barrier
from your business, you will gain a better understanding
of that business, a better understanding of your
customer or any other business process that is
critical to your organization's success. Using
a combination of expert consultants and Innovative
Logic's standardized methodologies and
templates, you can greatly reduce the time required
to implement the correct integration strategy.
How Can Innovative Logic
Integration Assessments -
EAI, EII, ETL
Integration Tools Evaluations - EAI,
Integration Leadership and Mentoring
Data Flow Management Architecture Templates
Architectural Planning and Roadmaps