Connector for Microsoft Dynamics V3 CU2 has been re-released and now supports Microsoft SQL Server 2014.
If you are planning to install the MSDI database for Connector for Microsoft Dynamics on an instance of Microsoft SQL Server 2014, then you will need to use this refreshed version of CU 2 (3.2.816.1).
Connector for Microsoft Dynamics also supports the recently released Microsoft Dynamics AX 2012 R3 ERP. This refresh is only required if you are integrating Microsoft Dynamics CRM and Microsoft Dynamics AX 2012 R3 and you are installing the MSDI database on an instance of Microsoft SQL Server 2014. If you are using another supported version of Microsoft SQL Server, this refresh is not required.
I've installed v3.2.
I logged on as a user who existing datareader and datawriter roles in MSDI db, and tried to open the connector client. but got below error in Event viewer. who should I solve it?
The encrypted setting, User password, could not be decrypted.
--- Exception Dump ---
Caught Exception: [System.Security.Cryptography.CryptographicException] Encrypted data was invalid and cannot be decrypted.
at Microsoft.Dynamics.Integration.DataAccessLayer.DataProtection.Decrypt(Byte data)
at Microsoft.Dynamics.Integration.DataAccessLayer.DataProtection.DecryptSettings(XElement settings)
@Alan - most likely you will need to logon as the SQL admin and then re-enter the passwords for the integration users for all integrations.
I have created a query with 2 tables like parent and child table and created a document service based on that query. Now when I am mapping my new customized service with CRM then it will show all parent and child table mapping in Connector. Now the problem is when I map parent fields in Connector then there is no issue but when I map child fields then there is an issue for Transform generation like " Field contains errors preventing successful transform generation". Even both the data types are same from AX & CRM end.
Can you please help to resolve this issue. Because same issue with all customized service with linked table.
@Parag - most likely you will need to use functions in your mappings for the child elements in order to index into the collections that are being passed out of AX. If this is AX 2012 then the child elements are presented in generic dictionaries so you can use the built-in functions to index into those collections, take a look at the out of the box maps for entities like Customer to Account for examples. If this is AX 2009 and you have built your own adapter for accessing these custom services then you might be able to use some of the built-in functions or you might have to create your own custom functions. You can also log a support case to get assistance with this effort.