With the evolution of data warehouses and the explosion in the number of systems being integrated into data warehouse/datamart solutions, enterprise data integration now involves a great deal more than ETL tools and routines.

Metadata integration is a requirement and challenge that more and more organizations are looking to take on. In most cases, the metadata for each software tool and the business metadata are not integrated. In order for developers and business users to accurately and consistently interpret the data elements they are using, an integrated metadata is critical. Lunexa consultants have worked on many such metadata integration initiatives.

Federated data warehouses and the use of database gateways is another form of data integration that is gaining popularity. When, for a multitude of reasons, loading data into a single Data Warehouse or Datamart does not make sense, a federated approach and the use of database gateways is an effective alternative. Lunexa consultants have experience with this category of data integration as well.

Finally, as more and more Data Warehouses are storing customer information and other "free form" data, the role of data profiling and data cleansing tools becomes increasingly important. In working on various customer-centric Data Warehouses, Lunexa consultants have taken on such data profiling and cleansing tasks as well.

As part of a data integration solution we deliver clear, useful, easily referenced design documentation.