FREE DM Review Site Registration!
Sign-up today and access DM Review on the Web!

Your FREE registration entitles you to:

FREE email newsletters

FREE access to all DM Review content

FREE access to web seminars, resource portals, our white paper library and more!

   
BI Review content and features are now in DMReview.com!

One brand, one Web site! DM Review is now the home of all the content you're used to at BIReview.com and much more. If you are registered at BIReview.com, you're already registered at DM Review. If not, take just a moment to sign up for all the free services we have for you at the new DMReview.com.

Data Integration Channel

Channel Sponsored by
Informatica

Data integration allows organizations to access all their fragmented data, create an accurate and consistent view of their information assets, and leverage those assets to drive business decisions and operations.

While application integration focuses on transaction management and process integration, data integration resolves the complex issues that arise from data fragmentation - including poor data quality, inconsistencies in the structure and meaning of data and inadequate data governance.

Organizations are using data integration in many different ways. They are implementing real-time reporting and analysis to optimize minute-by-minute operational and strategic, decisions. They are using data integration to migrate data into new applications or implement master data management. They are using data integration to synchronize data across operational processes and systems, and to create flexible, reusable data services.

Organizations should look to data integration technologies that can be used across a broad range of initiatives, including data migration, data consolidation, data synchronization, data warehousing and the establishment of data hubs and data services.

To accomplish this, many organizations are adopting a common, enterprise approach - one that leverages a unified platform, is built on shared services and supports integration competency centers.

Informatica provides a single, unified platform for data integration. The Informatica platform connects all enterprise data, from virtually any business system, in any format, and provides a consistent way of accessing, profiling, cleansing, integrating and delivering that data throughout the enterprise to service multiple IT initiatives. The Informatica platform helps organizations take full advantage of their data to support strategic business goals.

Articles

Five Questions Your Integration Salesman Doesn’t Want You to Ask

This article focuses on five common questions that integration sales representatives may dance around either because of shortcomings in products or a lack of knowledge about how integration is implemented.

Essential Steps for the Integrated Enterprise Data Warehouse, Part 1

This article provides guidance to what an integrated EDW is and what design elements are needed to achieve integration.

Integrate Process Towers

Most large and midsized organizations today have done a good job of documenting key procedures within specific process towers. Despite all the resulting attention, however, there are still significant gaps.

Columns

Data Integration Will Break Out of the Silo: BI and DW Trends, 8 for ’08

How’s this for irony? A lot of integration projects create more silos!

Don’t Stop at How, Learn Why

People involved in BI and DW projects are very familiar with terms such as facts, dimensions, attributes, surrogate keys and slowly changing dimensions. Knowing the terms is not enough.

Building the Information-Empowered Organization

Most companies have yet to unleash the power of improved information systems.

The Song Remains the Same

Technology and products have changed, but as I’m always reminding my consulting clients, the basis for sound data integration remains. Always remember the following basics that comprise the DIF.

Resist the Urge to Start Coding

The most important first step in designing a data warehouse/business intelligence system, paradoxically, is to stop.

Ask the Experts

What is the best approach to get an integrated view of information of both my finance and sales/production systems?

What are the best methodologies for testing data integration?

White Papers

Why and How to Build a Continuous Integration Environment for the .NET Platform

By Enterprise Solution Providers, Inc.

Informatica - Handling Variable Length Files Using XML

By Arvind Kumar

Data Integration in a Service-Oriented Architecture: A Strategic Foundation for Maximizing the Value of Enterprise Data

By Informatica

EAI - Refine the Economics of Integration

By GaneshKumar Murugan

Profiling: Calculating Return on Investment for Data Migration and Data Integration Projects

By Informatica

Books

Enterprise Application Integration

By David Linthicum

PeopleSoft Integration Tools

By Stewart S. Miller

Common Warehouse Metamodel: An Introduction to the Standard for Data Warehouse Integration

By Dan Chang, Douglas Tolbert, David Mellor, W. H. Inmon




Industry Vendors