Simple Rules of Successful Data Integration Strategy

by Katherine VasilegaSeptember 20, 2010

More and more company leaders admit that responding to the requests in a timely manner is a distinguished competitive advantage for any business. Data integration provides for a one-stop source for all your business operations that saves your company time, money and customers. Therefore, it’s simply a must for your data integration strategy to correspond with two important business approach rules that I’m describing below.

Move data once and use it many times

An ETL process is needed to secure data migration to a repository. Once it is moved, it can be used without replication by any application or tool. The consistency and accuracy of the ETL process requires a logical data model to define data and its usage based on business rules and user requirements. The logical model implies that the data integration is independent of any physical schema or database technology. It helps to avoid database redundancy and denormalization instead of transformation.

Data availability

The data repository should be a corporate tool that can be accessed by employees without addressing IT specialists. Users must be able to make any inquiries of any data at any time. The ETL solution that uses graphical tools to map data for business usage corresponds with this rule. The users benefit from data presentation via user-friendly interfaces, as the technical aspects of data migration are hidden from the users and tools.

These simple rules lead to data integration that provides for available, accurate and useful information. And of course, to commit to these rules, the data integration from across the enterprise must be carefully planned and carried out.

Data integration maturity levels (image credit)