Breaking news from around the world
Get the Bing + MSN extension
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 TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
Hello! I have very little database experience, and I'm doing an internship at a startup company that is wanting me to do the following:
We are making a game that college instructors will buy and provide licenses to their students so they can play it. We have a database using MySQL that holds basic information, such as usernames and passwords, etc. We also want to use Microsoft Dynamics CRM for customer relations. Both the database and the CRM will be on the same cloud (using AWS).
I have been instructed to figure out something where when an instructor creates an account, something will be triggered that will automatically create a new contact in the CRM, and triggers will happen when things are changed or added to the instructor's account.
Is there a way to do this? If so, please give me the most detailed explanation you can because I'm a complete beginner with this stuff!
You can use something Like Kinswaysoft which has a free SSIS adapter or Scribe which Is premium, and you have the option of Mapping the fields you want to update from both data sources using the Adapters provided, and integration rules for a time based integration or Net Change integration based on a value etc
The above tools should provide a MySQL Adapter, if not then im sure Cosysoft will
Hope that helps :)
It's your gig, have fun with it! Try node.js and socket IO to build up that web service from scratch, spin up an SSIS vm/trial, do everything Raz mentioned as well. Learn as much as you can, while you can!
Completely agree with Ummacrm, certainly isn't an easy task / a task associated with interns who have little experience in the area. However, good luck! Some nice tips above.
Raz has the right idea, I wish you the best of luck!
Thank you!! I really appreciate your help!
I'd like to add to your list SSIS Data Flow Components for Dynamics CRM and SSIS Data Flow Components for MySQL. Both products include Source, Lookup and Destination components and offers high performance data loading, convenient component editors, SQL support and lots of data specific features
As a non-coding solution to integrate Dynamics CRM with MySQL take a look at Skyvia - https://skyvia.com/data-integration/integrate-dynamics-crm-mysql
I'd like to add to your list SSIS Data Flow Components for Dynamics CRM and SSIS Data Flow Components for MySQL. Both products include Source, Lookup and Destination components and offer high-performance data loading, convenient component editors, SQL support and lots of data specific features
One more way to do it is to use no coding service that was already mentioned - Skyvia
Business Applications communities