The Center for Health Affairs

The Center for Health Affairs provides a variety of services oriented around healthcare for Northeast Ohio hospitals as well as nationwide through their affiliate CHAMPS Healthcare. They rely on Microsoft technologies in order to drive business efficiency in improving the health of the community. Microsoft Dynamics CRM plays a large role in facilitating communication between The Center for Health Affairs and their customers to keep them up-to-date with healthcare matters that impact their everyday lives.

THE CHALLENGE

The Center for Health Affairs needed to upgrade their Microsoft Dynamics CRM 2011 system to CRM 2016 and was looking for a tool to assist in migrating the data from CRM 2011 to 2016. Their previous data integration solution required processes to be set-up across multiple integration platforms which made it difficult to manage the execution of integration jobs. The Center for Health Affairs needed a single platform that could handle all their data integration requirements in order to minimize development, maintenance, and processing time.

The Center for Health Affairs was extensively using SSIS within their data integration development already. Finding a tool to integrate with Microsoft Dynamics CRM that worked within their existing practice played a key role in their decision to use KingswaySoft’s SSIS Integration Toolkit for their CRM data migration and integration. With this solution the development team can prepare, stage, and write data to CRM all within SSIS. The unique features within the tool also presented them with many opportunities to streamline their integrations to better manage and automate business processes.

One such feature The Center for Health Affairs uses regularly is the ability to execute a CRM workflow. They use this action frequently within their data integration development in order to automate the execution of emails and other CRM processes. With their previous system, a similar set-up required the development team to include the email body within the data integration project which they would need to constantly update for the CRM users. By taking advantage of KingswaySoft’s ExecuteWorkflow feature, the body of the email can exist within CRM allowing the appropriate CRM users to access and modify the email body and workflow as needed without development’s involvement. This gives control back to the CRM users and provides less maintenance for the development team as the data integration jobs do not need to be re-configured when changes are made to the workflow within CRM.