more quick actions
minimize quick actions
Topic starter
Hello,
This is not a request from the customer, but rather a curiosity from my end. As more customers are going for a cloud-based solution, one of the common questions is if the Azure SQL server is supported for connection from PcVue, and we say that it is possible using UDC for SQL Read and Write.
As I was going through the training module for UDC, I realized that the example is using SQL database hosted on Azure, and to connect, we make use of the built-in Data Source "Microsoft SQL Server".
I guess it is the same one that is used in the HDS Database creation dialog. In the HDS Database creation dialog, I tried using the same credentials as provided in the training module, and I receive a message like the below. It is expected because as explained in the training module, the ID Student does not have the privilege to browse available databases.
But I wonder if anyone has tested this and if there is any drawback? I can think of some possible issues, like the latency of the Azure SQL database and whether it can cope with the amount of HDS writing to the cloud database over the internet connection.
Posted : 14/12/2021 3:38 pm
Hi Kantha,
The driver for Azure SQL is really different than the one for SQL Server therefore it is not supported.
A work around could be to use the feature "Linked server". You can see in SSMS / Server objects / Linked Servers / Providers
We made a test with success for Oracle but it should work also for Azure SQL
Nico
Posted : 14/12/2021 4:18 pm
Topic starter
Thank you Nico for the answer
Posted : 14/12/2021 5:05 pm