Notifications
Announcements
Hi
I need to connect Dynamics 365 with SQL Server. I have SQL Server tables and my Admins would perform DML operations on SQL Server table from Dynamics 365. We would also have customer service portal for external users and they also need to perform DML operation against the SQL Server DB. How can we achieve that.
Thanks
Hi Noor!
You don't need to go anywhere just open MS FLOW(Power Automate) it has built in connector for SQL SERVER(Online & Onpremise)
Thank you Zeeshan , I know about MS Flow. Client doesn't want to store data in Dynamics CRM. He wants to use SQL Server as their only Datasource and at the same time they want to expose the SQL Server tables/data via Dynamics 365 for Admins and through Dynamics 365 Portal to external users.
How can I achieve this.
Possible Ways
1- Power Automate
2- SSIS Packages
3- Zapier
4- Cdata
5- Azure Logic App
6- Azure Function/Custom APIs
7- SkyVia
8- Azure DataFactory
9- Leads Bridge
Regards,
ZG
Hi,
You can setup DES sync and use the destination SQL database for your internal work.
Thank you Sinha
Could you please explain what is DES Sync.
Hi Noor,
Using DES you can push all your CRM entity data into a local SQL database or azure database.
https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/data-export-service#:~:text=Data%20Export%20is%20an%20add,customer%2Downed%20Microsoft%20Azure%20subscription.
https://powerobjects.com/2019/05/07/data-export-service-installation-configuration/
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 22 Super User 2026 Season 1
Suriyanarayanan V 15
CU19070926-0 10
