New resources available on Microsoft Learn
Did you know that Microsoft Learn offers free training modules to assist you on your path to mastering Dynamics 365 for Finance and Operations? Become an expert at your own pace or share with your team to foster growth.
Dynamics 365 2019 release wave 2 plan Discover the latest updates to Dynamics 365.Release Plan | Weekly Deployment Notes
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
How to Connect D365 FO (SQL Server) to My SQL?
Please explain in detail , what you want to do .
Even though you may find something to connect in DEV environment, you won't be able to use the connection in production environment. Basically you don't have access to Azure sql server (provided you will be using Azure and not using on-premise installation). If you trying to get data out of D365, start looking at data entities and see what they can do for you.
you have to use export options or integration
One of the possible way is BYODW and if would like to user Azure data lake then it is also an option now
But I am working on D365 (On Prem) Environment, there's no use of Azure in my project.
You could develop a C# solution for connecting to MySQL and use it from x++. I'm sure there are plenty of articles about connecting from C# class to a MySQL database.
On the other hand, if you are on premises, you can also use SSIS, SQL agent jobs or many other things to copy data from D365FO db to MySQL db.
What is your business requirement?
I'm also curious what you need to achieve. Note that when a customer is now running on-premise, they might consider the cloud in future. Also similar requirements might be valid for customers already running in the cloud. So, try to think in a solution direction which would be suitable for any deployment type (depending on the requirement)
see if REST API helps
Data management framework's package representational state transfer (REST) application programming interface (API). The package API lets you integrate with Microsoft Dynamics 365 for Finance and Operations by using data packages. The REST API can be used with both cloud deployments and on-premises deployments.
Business Applications communities