How to Integrate One Dynamics CRM Organization to Multiple GP Companies using Scribe

How to Integrate One Dynamics CRM Organization to Multiple GP Companies using Scribe

Posted By
BDO

If you need to integrate data from a single Microsoft Dynamics CRM organization to multiple Microsoft Dynamics GP companies, the most obvious solution would be to create a Data Translation Specification (DTS) file that has multiple steps and imports to the applicable Dynamics GP company. However, if you want to use the minimum number of steps and complexity for queue-based integrations, you should use the powerful DTS parameters that Scribe provides. The /TD parameter, in particular, allows you to indicate the GP database name that your DTS should connect to. Resources on configuring the DTS parameters are slim, so here are the basic steps to get you well on your way to integrating to multiple GP companies using a single DTS file.

Configuring a DTS File in 3 Steps

  1. Create a SQL connection to any of your Dynamics GP companies. The Database name can be any of your target databases.how-to-integrate-one-dynamics-crm-organization-to-multiple-gp-companies-using-scribe-1
  2. You will need to add a field to the entity in the Dynamics CRM you are integrating from that will hold the database name of your Dynamics GP company. In my example, this field is called bdo_gpcompanyid.
  3. You then need to specify the following string in the DTS Parameters field in your integration properties. The XPath switch will parse through the XML message and find the value indicated. It will then pass it into the DTS at runtime.

how-to-integrate-one-dynamics-crm-organization-to-multiple-gp-companies-using-scribe-2


If you aren't using web portals for Microsoft Dynamics CRM, here's why you should consider it,
If you aren’t using web portals for Microsoft Dynamics CRM, here’s why you should consider it.

 

BDO eBook - The Cloud Changes the Game

There are times in the course of your business when you have the opportunity to dramatically accelerate growth and improve day-to-day efficiencies. Recognizing

Download