Gordon Food Service Canada, a premier foodservice distributor, turns to HiT Software for its data replication needs in the implementation of an Enterprise-wide Business Intelligence (BI) Solution for all Divisions of GFS Canada.

GFS Canada
 
Gordon Food Service Canada is a premier foodservice distributor. With over 100 years of business behind them, in 1994 Gordon Food Service entered the Canadian marketplace through the merger of some of the more significant businesses in the foodservice industry.
 
Their explosive growth requires GFS Canada to handle more products, provide more services and satisfy more customers' needs than ever before. GFS Canada turned to HiT Software for their data replication needs as a key component in the delivery of an Enterprise-wide Business Intelligence (BI) Solution for all Divisions across GFS Canada.

Reviewer
 
Stuart Bestbier, Project Manager for the delivery of the BI Solution for GFS Canada.

Background
 
Stuart's role in the BI Project is to manage the design, development and implementation of an Enterprise-wide BI Solution for all Divisions of GFS Canada. The project includes selecting and implementing the necessary BI software and supporting infrastructure. The BI Solution will support analysis, reporting and decision-making across all Divisions.

Platforms
 
GFS Canada is using DBMoto v5 to continuously mirror data from DB2 on their P30 iSeries source system to their SQL Server 2005-based Data Warehouse Staging Area which is hosted on an IBM X366 2 CPU (dual core) x64-bit Windows 2003 R2 Server.

Problem Solved
 
The purpose of the GFS Canada BI Project is to implement the necessary Data Warehouse processes, tools and techniques to allow Product Item, Vendor and Customer margin and profitability analysis for the Sales and Marketing business areas.
 
The BI project needs to manage approximately 50 tables with between 20 and 230 columns per table, and between 150 and 26 million records per table. The overall number of new transactions per month runs at around 3 million, translating to roughly 100,000 primary business transactions per day with many hundreds of thousands of supporting transactions every month.

Selection Criteria
 
The primary criteria used to select the data replication tool were:

• Minimize the impact to the mission critical production source system and have no negative impact on end user access to production data
• Have flexibility to automatically stop and restart the replication process in order to force a "point of quiescence" in the Data Warehouse extract process
• Capture only the changes to source data (i.e. the deltas) from one Data Warehouse extract to the next
• Have a 100% reliable mechanism for capturing changes to source data, including a verbose record of all inserts, updates and deletes
• Product performance: GFS Canada data volumes require a fast, reliable data replication capability

Product Functionality
 
Stuart's project uses continuous one-way mirroring of source data to the Data Warehouse Staging Area with controlled stops and restarts. The use of DBMoto allows them to overcome the following challanges:

• Removes the need to write custom code to identify source data changes from one day to the next
• Removes the need to read source data tables directly thus minimizing potential impact to end users

Strengths
 
GFS Canada chose DBMoto for the following reasons:

• It enabled them to minimize impact to their mission critical production source system, while generating no negative impact to end users attempting to access production data
• DBMoto is flexible enough to allow the BI project to automatically stop and restart the replication process as needed
• DBMoto replication setup allows project developers to capture only the changes to source data from one Data Warehouse extract to the next. The mirroring mechanism captures all changes to source data, including a verbose record of all inserts, updates and deletes
• DBMoto met the project requirements for a fast, reliable data replication capability for large volumes of data

Vendor Support
 
Stuart reports that technical support has been very good so far (mostly during the pre-sales cycle when the team was coming up to speed with the product features and capabilities). In addition, documentation met their needs, although more detailed examples to help out with custom scripting would be useful.
 
HiT Software, Inc. can be reached at: www.hitsw.com.