Client sync via data warehouse

Date: 11/18/2006

Forklift is an open-source (GPL v1.1) application to synchronize client data between multiple agency systems such as CTFACS, Energy, and others into a central Data Warehouse (developed by another company) to help centralize reporting, reduce client duplication, and reduce data re-entry.


This application extracts modified client data from the individual agency systems on a nightly basis, uploading the changes to the warehouse while also bringing down new changes from the warehouse to be integrated into the client systems. We developed this application for Nutmeg Consulting, who oversaw the original development before making it available to the public for the benefit of other agencies.

The system indirectly uses Web Services to communicate with the warehouse via a proprietary interface library, and is designed to use agency system plugins to communicate with the individual agency systems. This allows integration with different types of agency data systems, and allows new systems to be integrated into the existing application.

For more information on using Forklift to centralize or integrate your agency data, contact Nutmeg Consulting below.

{include_weblink 11}

Customer: Nutmeg Consulting, LLC

Since its founding in 2003, Nutmeg Consulting, LLC has specialized in providing high quality Information Technology (IT) and Project Management services and products targeted at small business and the non-profit sector. From the beginning, we differentiated ourselves from other companies by offering a combination of private and public sector experiences, using proven methodologies for planning and implementation. We provide the skill and knowledge every organization requires – regardless of your size.

Location: Hartford, CT


Contact: Chris Shipley

Email: Zbqry.Cebwrpg.Phfgbzre.Rznvy