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
- Create a SQL connection to any of your Dynamics GP companies. The Database name can be any of your target databases.
- 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.
- 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.