Lesson 1k: Connect using Qlik Cloud to Azure database
https://factsanddimensions.co.uk
Facts and Dimensions provide 1000s of tables of publicly available stats and reference data, ready to query immediately.
See how to connect to your Facts and Dimensions Azure database using Qlik Cloud
If you get an error with your IP address, this means you need to send us that address so we can whitelist it.
If you get an error regarding Named Pipes or TCP and such, then you need to update your firewall to allow access to Azure. We are based in UK South data centre.
Update firewall as per:
a. See https://docs.microsoft.com/en-us/azur... and
b. https://docs.microsoft.com/en-us/azur....
Our Server is in UK South, so use the IP address for that Region if you want to restrict 1433 access.
c. You need to ensure TCP/IP is enabled in SQL Server Configuration Manager
d. Other useful URLs
i. https://docs.microsoft.com/en-us/azur...
ii. https://docs.microsoft.com/en-us/sql/...