Hello Everyone! I need to work with a bi solution using a sql server express 2008 database. I am thinking of replying some tables in microsoft azure or another cloud database easy to reply. Then I will connect qlik sense desktop with the cloud database. Which database can you recommend? why? Thank you very much
Hellow Justin, just because there are many users of qlik which are not log in to the internal network and they use qlik sense desktop. The can`t reload data from the server without using a vpn connection. The company prefers to avoid vpn and just leave some usefull tables in the cloud for qlik sense users.
1. Do the users really need a db? Or could they just load a flat file that's put out in the cloud somewhere and have that file get refreshed every hour or 15 minutes if need be.
2. I would still go with SQL Server if I had to have a DB, because I wouldn't want any nonsense happening on the DB->DB transfer. You could write an Integration Services Package and have it dump the data as needed. Whereas with something like MySQL, you would need an Enterprise version because QlikSense doesn't like the Community version without adding an ODBC. And if you go Postgres I assume you still might be stuck having SQL Server dump a file somewhere, and then having Postgres pickup and apply that file (but I'm not sure).