Forum Discussion
How to create Azure SQL Server Views that reads data from a Dataverse?
Hi,
I have an Azure SQL Server installed. I would like to create SQL Views within a SQL database on this server. These SQL Views will point to and show data held within our Dataverse (the database for Dynamics).
The Azure SQL Server and Dataverse are both within the same Azure subscription/tenant.
When attempting to write the a SQL View, I need to fully qualify the source details in the FROM clause, naturally. It's not recognising the Dataverse details, and I would expect this, unless I make it seen. I'm out of touch with all this but I do remember Linked Servers being the traditional way. However, when following instructions on this, in Azure, I cannot see the Linked Servers option.
How do I achieve what I need to do? Please can someone provide me with an link on achieving it?
Thanks.
4 Replies
AzureNewbie1 , Linked Server are not supported on Azure SQL Databases, see
Linked Servers (Database Engine) - SQL Server | Microsoft Learn
- olafhelper - thanks. Are you able to advise on how I do fully qualify a Dataverse from within Azure SQL Server database?
AzureNewbie1- You may want to examine whether switching to an Azure SQL Managed Instance solution from an Azure SQL Database is worthwhile. Linked servers are permissible with Azure SQL Managed Instances.
