Minor issue connecting QlikSense Cloud to SQL Database (ODBC)
Recently installed QlikSense Cloud and pleased all is working well.
However, 1 minor (I think so anyway) problem is that when we try to connect to any SQL (2012) database (via ODBC), we can actually see the database names, but cannot get at the tables within them. Simply the contents are not displayed. But, the strange thing is that we can see the System Databases (master, tempdb, msdb and model) in their entirety.
See attached screens.
Any ideas? QlikSense Engine, Repository or SQL Database owner issue? A setting within the Management Console that needs to change?
NB: Qliksense and SQL Server are hosted on the same (virtual) server.