3 Replies Latest reply: Jul 4, 2017 6:52 PM by Justin Dallas RSS

    Cloud database recommendations

    Ignacio Garribia

      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

        • Re: Cloud database recommendations
          Justin Dallas

          If your tech stack already uses SQL Server, why would you deviate from that?

            • Re: Cloud database recommendations
              Ignacio Garribia

              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.

                • Re: Cloud database recommendations
                  Justin Dallas

                  Okay, two questions.

                   

                  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).