SA Families and Communities on data consolidation mission

Replacing seven legacy systems with one database

The Department for Families and Communities (DFC) in South Australia is planning to replace seven legacy client information systems with a single repository using master data management (MDM).

The DFC consists of seven offices including Housing, Families, Disability and Office for the Ageing.

“Each of these areas has its own systems containing client information and there is a limited capacity to identify clients existing in multiple systems,” read department documents.

These database platforms include SQL Server, Oracle, Salesforce and Intersystems Cache. The client information lists range in size from 5000 to 300,000 records.

Known as the Connected Client Interaction (CCI) project, the offering is intended to provide one source of data and a central store of history derived from legacy customer systems.

The successful supplier will have to supply a proof of concept explaining how they will extract data from the different server systems before placing it in the new system using an MDM offering. This concept will also need to show how it can integrate client alerts and address history information.

DFC has a number of outcomes planned for the CCI project including the ability to search and identify regular clients across disparate data stores, make people aware of the services offered to DFC clients by other divisions, and offer them options based on this information.

The department also wants to identify inconsistent client information that may be held in different offices, identify customers across multiple records and be alerted when clients receive a change of personal details.

Clients will also benefit as they only need to provide details to DFC once rather than to multiple offices.

The DFC has a preference for an offering that includes local support and has a range of training options available.

The project is scheduled for completion by July 2011.

Follow Hamish Barwick on Twitter: @HamishBarwick

Follow Computerworld Australia on Twitter: @ComputerworldAU

Join the newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

Tags master data managementsql serverdata consolidation

More about CacheCatholic Church InsurancesOracle

Show Comments
[]