Case Study: Using Scribe Insight to Integrate Microsoft CRM with 4 Other Systems

This summer I worked on an interesting and challenging Microsoft Dynamics CRM project for a large university. This project involved not only implementing Microsoft Dynamics CRM, but also integrating 4 other systems with CRM so that CRM became the central repository of student and alumni data, making it easy for users to find data and report from one system.

The kicker is that each of the 4 systems used a different database platform!

The key to making this project successful was the use of Scribe Insight, a tool from Scribe Software (http://www.scribesoftware.com/) used to migrate data into just about any system, and integrate systems. Thanks to the power of Scribe Insight, we were able to integrate all systems with Dynamics CRM.

Here's the rundown of the applications we integrated with Microsoft CRM:

Application: Web-based career center management application
Source Data Format: Text files created by exporting data from the source system
Integration Type: Periodic batch load to CRM

Application: Campus calendar application with events that students register for
Source Data Format: mySQL database
Integration Type: Ongoing two-way real-time integration with CRM

Application: Student information system
Source Data Format: Sybase database
Integration Type: Initial batch load and ongoing one-way real-time integration to CRM

Application: Alumni information system
Source Data Format: Oracle database
Integration Type: Initial batch load and ongoing one-way real-time integration to CRM

Conclusion:
If you ever need to do ANY kind of systems integration work regardless of whether a Dynamics product is involved or not, then I recommend you check out Scribe Insight.