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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Linking between Dynamics 365 and Sql Server - post MS Access 2016 Linking

(0) ShareShare
ReportReport
Posted on by

Microsoft has now announced that you can link between MS Access 2016 and Dynamics 365 - Great!

But what we need is a way to Link between a SQL Server Database (ours is currently 2008R2) and Dynamics 365.

Jumping the business in full to Dynamics 365 is a ideal goal, but it is just too far to jump, it needs to be done over a number of months or even years. Making Dynamics 365 the primary location for customer data is a starting point, but systems elsewhere need to rely on data from SQL Server. I know Access 2016 could bridge the gap, using data from both sources, but the processing power of SQL Server, is required for a large amount of processing.

Other external data sources are in the process of coming on board (onto our on premise SQL Server), I suppose the final goal might be a Dynamics 365 platform supported by Azure SQL Server for the items which can not be configured in Dynamics 365, although the people who supply my external data, do not have any idea how this would work in Azure.

First goal is to link Dynamics with SQL Server.

Has Microsoft updated this or do they intend to update this, due to the MS Access linking.

Many thanks.

David Stone 

*This post is locked for comments

I have the same question (0)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans