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)

Report
All responses (
Answers (