web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Suggested Answer

Connect D365 with SQL Server

(0) ShareShare
ReportReport
Posted on by 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

I have the same question (0)
  • ZeeshanGhause Profile Picture
    on at

    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)

  • Noorahmad001 Profile Picture
    130 on at

    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

  • Suggested answer
    ZeeshanGhause Profile Picture
    on at

    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

  • Suggested answer
    SS-01100907-0 Profile Picture
    on at

    Hi,

    You can setup DES sync and use the destination SQL database for your internal work.

  • Noorahmad001 Profile Picture
    130 on at

    Thank you Sinha

    Could you please explain what is DES Sync.

    Thanks

  • SS-01100907-0 Profile Picture
    on at

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 22 Super User 2026 Season 1

#2
Suriyanarayanan V Profile Picture

Suriyanarayanan V 15

#3
CU19070926-0 Profile Picture

CU19070926-0 10

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans