I am new to Qlik Cloud/Qlik Sense. I only have experience using Qlik View with an on-site server. I have recently started a Qlik Sense trial but am struggling to get a connection from a SQL Server DB to work. This is the same SQL Server DB I'm already using just fine with Qlik View. But I cannot get it to work with Qlik Cloud.
It seems there are two methods to add a data connection to Qlik Cloud: a standard method (which I really can't find much information on for troubleshooting purposes) and direct access gateway. The latter I cannot use because from what I've read it requires a lot of server resources and needs to be placed on its own server because of that. Unfortunately, I do not have much access to server resources at my company.
Therefore, I'm forced to go with the standard connection method. I assume this method requires me to expose my DB connection to the internet, but how do I go about doing that? I've already setup and tested the connection properly in my ODBC Data Sources program. The connections are working there. But they are not working in Qlik Cloud. What step am I missing or is it some kind of limitation with the Qlik Sense trial?
