I am evaluating Qlik Sense for my organization but I am having trouble simply adding data from our database to work with. I am able to connect to the server, specify the owner, and select the tables, but when I click "Add Data" the program simply hangs for hours attempting to load. The tables themselves are not that large (one table has 159,000 lines and the other has 279,000 lines) but I am not able to add either one as a data source.
Is there anything that I can do to resolve this issue?
What type of database is it that you are connecting to?
Are you using the Data Manager or the Load Script? The Data Manager has some nice features, such as data profiling and auto-suggestion of joins, but it is not always as efficient.
If you are not yet trying it I would definitely opt for the Load Script.
Database loads can be affected by record locking, in exactly the same way as loading rows straight against the database, so that is worth checking. The fact that two separate tables suffer the same fate this sounds less likely.
Connectivity between Sense and the Database could be an issue. Is there any port-blocking between the two - it could be that the authentication is done on one port and the retrieve on another.
We have not had any success at this point. We know that our server setup isn't ideal and will make changes down the road, but we will need a BI solution that can work with our existing tools as we transition.
For now we are using Excel files instead of a live database connection to allow our evaluation team to get a sense of what they can expect if the data connection issues are resolved. Hopefully a fix will be rolled out soon enough for us to assess Qlik's viability from an IT perspective.
I am having the same problem using Qlik Sense desktop and when I create new App and press "Add data from files and other sources", following is where it stucks for hours and nothing happens after that. Please help