About this Article:
This article will discuss an approach to designing an ETL system in VFP as part of the overall data-warehousing project. I will provide two additional source data files as well and rely once again on the Northwind database. These source systems will be “ETLed” into the Dimensional Model I designed in the first article. I plan to provide a complete solution with source code, diagrams, and screenshots.
Tod McKenna is a business intelligence and data warehousing consultant for Contraste Europe. He has worked on various data warehousing and data integration projects for Certified Revaluation Company, Cardinal Health, ING, and others. A longtime Visual FoxPro developer, Tod spends his days working with SQL Server and its BI stack. By night, Tod writes his technology blog at blog.todmeansfox.com. www.linkedin.com/in/todmckenna tod@blackstoneprovidence.com
Keyword Tags: Database Management, IT Networking, Microsoft, Microsoft Access, Microsoft Office, Microsoft SQL Server, Microsoft Visual FoxPro, MySQL, Security, Software Development, XML