Business SituationLTCG needed a reusable ETL framework to get new clients up and running faster than previously experienced. Each time LTCG brought a new client on board, it had to spend up to six months building an integration layer to enable its service applications to work with the client’s data servers.
LTCG was in the process of building a data warehouse based on Microsoft SQL Server 2000 and 2005 but needed a partner with enterprise experience in BI solutions to enable them to consolidate disparate data sources into the warehouse.
SolutionLTCG engaged Avanade as an expert consultant in ETL design in order to:
ResultsAs a result of the work, LTCG now has their desired reusable ETL model that enables it to: