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 Integration (EII).
   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.

Timing Batch snapshots Real time Real time
Historical Record Yes No No
Persistent Auxiliary Tables Yes No. Transactions applied directly to applications' tables No. Virtual database
Application Managerial reporting, trend analysis, multi-dimensional aggregation 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

Why 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 Data Integration?

   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 Help?

    Integration Assessments - EAI, EII, ETL
    Integration Tools Evaluations - EAI, EII, ETL

    Integration Leadership and Mentoring
    Data Flow Management Architecture Templates
    Architectural Planning and Roadmaps



The definition of a data warehouse has taken on many meanings and interpretations throughout the years. But at its core, a data warehouse represents a consolidated view of an entity's data...

The RapiMart Methodology supports all aspects of the implementation of a warehouse – from project charter through deployment through post-project review. It does this through a series of templates that prompt users through each step and are self-documenting. Several areas of RMM include...  READ MORE...

  Modeling within the data warehousing industry has evolved, just as businesses have. With organizations now required to comply with multiple regulations, and with competition becoming an even bigger issue, companies must rely on their data warehouses to answer questions quickly, accurately, with an eye on the big picture.

Business Intelligence (BI) is insight – insight into information that is required to make sound business decisions. BI is a key component of a successful data warehouse endeavor...