Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Talent TechTalks
Currently we have SSIS jobs that download and upload data between salesforce and on-premise oracle using a WSDL based connector. Now we want to replace Salesforce with MS Dynamics 365 online. Please keep in mind that i need to download Dynamics entities as well as update Dynamics entities (bi-directional data sync). What is the best option in your experience to connect to Dynamics via SSIS. I am trying to avoid third party connectors like kingsoft etc. if possible .
In SSIS job you can use the script component(C#) and SQL components to achieve this with out any third party connectors.
Thanks Dharani..I will try your suggestion..and what’s your opinion on using logic apps for this..do you see any cos/pros
Sorry for the late response.
Yeah you can use the Azure Logic Apps too. As you didn’t want to spend too much time in this integration but still have a good scalable/manageable solution that can migrate large volume of data.
Please refer the below link it clearly explains you the data migration using Azure logic apps.
I hope this helps.
Hi Dharani..thanks for the prompt response..this is very productive discussion. I did not know that logic apps would have throttle limits and it definitely looks like lot of work to just do a simple data transfer ..going back to the C# solution, will that have any constraints like logic apps have e.g throttle limits etc..or would it be able to easily handle lot of records seamlessly. Any thing we need to watch out for in C#? we have to write close to a million records from Dynamics to Oracle and Oracle to Dynamics daily..
In C# solution we won't face any throttle issues. Generally what we do is. We categorize entities into two types simple and complex. Simple definition entities having lesser number of records(master data entity, record count less than 10 lacs). Complex definition entities having more records such as account, contacts, activities etc.(record count greater than 10 lacs). If it is simple then we go with kingswaysoft. For complex ones we prefer to go with script component in SSIS. We have seen performance was too good when we used script component to complex entities compared to kingswaysoft adaptor.
@Dharanidharan Balasubramaniam, it is not true when you say you are not throttled if you write your own C# code. Throttling happens on the server side, regardless how the client software is written.
It is also misleading that you claim that custom code performs better than a proven commercial offering. Performance comes down to many different factors. I have a recent communication with a partner who uses our software, they were able to process 3,800 records per second using our connector. I challenge that you can even get there through custom code. Not to mention that we offer many advanced integration features that took us years to build, which is not something that you can easily achieve in a short timeframe.
Adding one more thing - Using Logic Apps for large scale integration may not be the most economical option. If you go this route, make sure you price it out before you put it in production, you (or your client) might be surprised by the bill that you will be getting if you deal with a large quantity of data on a regular basis.
Yeah I understand Daniel. Sorry if I have mentioned anything wrongly. I haven't mentioned throttle won't occur if we use script component. I do completely understand performance issues will occur due to different factors. Here I have mentioned the problem which we faced in our project. Also I am not against Kingswaysoft adaptor. Even in my current project also I am using kingswaysoft adaptor to do the data migration.
Hi Dharanidharan, no worries. I appreciate your response and clarifications, and also want to thank you for the support.
Hi Daniel..do you have a comparison chart between various etl connectors to dynamic can..e.g Kingswaysoft vs scribe vs logic apps vs custom code..this will help me a lot to move to the next phase of my decision
Business Applications communities