Data Integration

Do you need a robust data integration solution that provides transparency into data transformation, quality and health?

Built upon the robust platform of SQL Server Integration Services, LG Consulting has developed a framework that accelerates the integration of source transactional systems with a Business Intelligence solution. Built to manage the extraction, transformation and loading of dimension and fact data, the meta data driven framework has template packages for multiple dimension and fact types that can be configured according to solution requirements. The ETL Framework also supports Data Quality processing and allows for configurable scoring and events. Finally, the ETL Framework provides transparency into data integration via a series of reports designed not only to provide an audit trail of corporate data, but to provide metrics on the integration processes themselves. The evnts and reports are configurable based on the solution requirements.

LG Consulting has supported many companies and extended solutions that allow business users realize the value of scalable solutions.