Client Overview

• Client is a US-based premium provider of prosthetics and orthotics, with operations and presence in India as well

Business Challenge

• Client had its data scattered across various repositories, including its indigenous CRM system, flat files, CSVs and local database

• Client needed disparate data integration and periodic data migration for its US and Indian division

  • For its US operations, the client needed a bidirectional integration between client’s local database and MS Dynamics CRM

  • For its India operations, client needed the data in MS Dynamics CRM to be extracted at a FTP location at regular, pre-defined intervals

Technical Requirements

• MS Dynamics CRM 13

• C#

• Visual Studio 10

• .NET Framework 3.5

Solution Strategy

• Eternus Solutions reviewed the client’s business requirements and its disparate, distributed data repositories

• The Eternus Solutions team came up with different approaches for the data integration and migration requirements for client’s US and Indian arms of operations

  • For the US unit, Eternus Solutions team worked on a two-way integration between client’s MS Dynamics CRM and its local database

  • This integration was near real-time, with set, pre-defined intervals for data sync

  • The client needed the data in the MS Dynamics CRM system to reflect in the local database also, as the local database was synced with client’s other back-end systems. For this sync, a windows service was written and executed to integrate the data from Lead and Account objects in MS Dynamics CRM into the local database and vice versa.

  • For the Indian unit, the client needed the data from MS Dynamics CRM to be extracted at an FTP location in a CSV format at pre-defined, configured time intervals.

  • Eternus Solutions provided an XML configuration file to the client in order to enable them to change the time interval, if needed.

  • The system needed to automatically pick up data from the MS Dynamics CRM system based on any updates. For this purpose, a Windows service was written and executed.

Solution Components

• Requirement analysis and synthesis along with client team

• Design and development of the Windows service required for data integration for both units of the client

• XML file for configuration

• Integration with MS Dynamics CRM and local database

• Ability for file extraction at FTP location in CSV format

Development Methodology

• Development on developer sandbox

• Evaluate and cover requirements using out of the box features

• SRS and design documents to start building any new components

• Design and development of workflows

• Windows based service for integration

• XML file for configuration of time interval for integration