With release of office 365 cloud application and Dynamics CRM 2013 online, I’ve seen lots of SalesForce customers are switching to use Microsoft Dynamics CRM 2013. it’s cheaper in the long run and will integrate better in enterprise environment with Microsoft back end and Microsoft office outlook.
One challenge of this transition would be transferring current integration from SalesForce to Dynamics CRM. Talking about integrating SalesForce and other systems, I find Informatica one of the best solution out there but when it comes to Microsoft Dynamics, it’s not as good as it should be, for instance it does not support CRM lookups inside the interface and you can’t do lookup directly inside the interface, and it also doesn’t give you much details while running integration, like number of rows before running integration.
There are two ways to do Dynamics CRM lookup in Informatica, using Visio informatica add-on or using easier way which is flat files.
in the next post I will talk about flat file Dynamics CRM lookup in Informatica.