Preserving leading zeroes in numerical constant value mappings

If you need to map a numerical value to a constant value and that constant value has leading zeroes, those zeroes will be parsed off.  For example, if want to map a numerical field to a constant value of 00000000115 and you enter a constant value in the mapping wizard, the transformation logic will truncate the leading…

0

Connector for Microsoft Dynamics configuration settings that can be used to control some of the default behaviors for logging and retries

There are some configuration settings that can be added or changed in the ConnectorServiceHost.exe.config to update default behavior with respect to retries and log cleanup; they are as follows:  Config Setting Behavior Remarks  HousekeepingCleanupLogs True: The Housekeeping task should run CleanupLog.proc.sql and CleanupRetryTask.proc.sql False: The Housekeeping task will run only run CleanupTaskDeletionTracking.proc.sql (not recommended) Caution: Log…

12

Lessons learned from a Partner when upgrading Connector for Microsoft Dynamics MSDI database

The MSDI database that Connector for Microsoft Dynamics uses for storing information about integrations is intended to be used ONLY for Connector for Microsoft Dynamics.  Recently I was working with a partner who was experiencing some issues when upgrading to the latest version of Connector for Microsoft Dynamics.  The partner was receiving error messages similar to the…

3

Sorting in Microsoft Dynamics AX 2009 AxdItem and AxdInventoryOnhand data sources can effect paging in the Microsoft Dynamics AX 2009 adapter

Paging is implemented in the Microsoft Dynamics AX 2009 adapter and relies on the AIF services to return the keys to the Items to be integrated in ascending order by ItemID.  If the AIF services that the Item to Product map relies on do not sort the returned item keys in the proper order, you…

3

Moving the MSDI database to a new Microsoft SQL Server instance

When Connector for Microsoft Dynamics (version 3.x) is installed a database master key is created (for encryption of passwords saved with adapter settings) using a random password. The downside of using a random password is the owner of the database will be unable to back up the master key allowing the key to be restored…

44

New feature in Connector for Microsoft Dynamics V3 CU2 allows for limited updating of Contact Info View items in Microsoft Dynamics AX 2012

The new field, “Allow Contact Info View Updates” is used to enable updates to existing Contact Info View items.  After generating Microsoft Dynamics AX 2012 object config files, this field will show up in any Complex Types that contain a ContactInfoView field.  Leveraging this new field will allow you to update your Contact Info View…

2

Connector for Microsoft Dynamics in the Microsoft Dynamics CRM field guide

Connector for Microsoft Dynamics is covered in a book recently published by a group of Microsoft Dynamics CRM MVPs. Check out chapter 23 in the recently published “CRM Field Guide”: “Chapter 23 – Dynamics Connector – From Zero to Hero, in this chapter, you will learn what some of the considerations are when combining CRM…

0

Mapping Microsoft Dynamics NAV OptionStrings and Microsoft Dynamics CRM OptionSets

Have you found yourself needing to map custom OptionString fields from Dynamics NAV into custom OptionSets in Dynamics CRM?  And have you found that if you have blank or unassigned values in either system that this can be difficult to do?  If so, then this post is intended to help you out.  One of our…

6

Configuring Microsoft Dynamics GP 2010 for use with Connector for Microsoft Dynamics

This video will walk you through the process of installing and configuring the prerequisites for Microsoft Dynamics GP 2010 to be ready to work with Connector for Microsoft Dynamics  https://youtu.be/-EqpPXcZ78M  [View:https://www.youtube.com/watch?v=-EqpPXcZ78M&feature=youtu.be] Key take aways from this video include: The process for installing GP web services The process for configuring GP web services Enabling the GP adapter user…

0

Considerations for designing a single Microsoft Dynamics CRM organization to multiple Microsoft Dynamics ERP Companies integration

The latest release of Connector for Microsoft Dynamics supports integrating multiple Microsoft Dynamics ERP companies into a single Microsoft Dynamics CRM organization. Connector supports these scenarios if an instance of a Microsoft Dynamics CRM entity can tell Connector which company in the Microsoft Dynamics ERP it needs to be sent to. When this occurs, Connector…

7