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.

​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.  Read More

​