130
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,
Using DES you can push all your CRM entity data into a local SQL database or azure database.
https://powerobjects.com/2019/05/07/data-export-service-installation-configuration/
Thank you Sinha
Could you please explain what is DES Sync.
Thanks
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
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.
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)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (