Automotive Finance Corporation Uses Data Warehouse to Increase Business Volume

Overview

To provide unparalleled service to each and every customer, AFC developed a state-of-the-art information system, which has been in operation since 2000. AFC's system is based on Oracle databases running on Sun Solaris servers. The company wanted to turn the large database into an information base system to analyze which dealers are using the services, how they are using them, and where the profitability lies. To get the required data - stored in Oracle databases and Excel spreadsheets - into the data warehouse (also based on Oracle), AFC needed an efficient Extraction, Transformation, and Loading (ETL) tool that could interface with all its systems and perform the data transformation. In the end, the company narrowed down their choice to three tools, including Oracle Data Integrator.