17 Replies Latest reply: Jul 5, 2012 3:03 AM by Gaurav Khare Branched to a new discussion. RSS

    Can Qlikview server deployed on a virtual server?

      Hi

      Hi I am new to QV. My clients would like to know whether Qlikview server can be deployed on a virtual server ?

      Regards

      Raj

        • Can Qlikview server deployed on a virtual server?

          We have been running QV server from a VM for a few years and it has been working ok. We are now in the process of moving it to a 64 bit VM from a 32 bit due to memory requirements.

           

          • Can Qlikview server deployed on a virtual server?
            Ashfaq Mohammed

            Hi Arun

            Yes it can be deployed on virtual server.

            And make a note that virtualization make qlikview to run slow.

            Hope that helps.

            Regards

            ASHFAQ

              • Can Qlikview server deployed on a virtual server?

                Hi Asfaq / Kajok,

                Suppose my qlikview document in the virtual server extracts data from 3-4 QVD files which are stored locally, then can the data from these multiple QVDs be put into one file and then sent to virtual server instead of having the data from each QVD being sent to the virtual server.

                I hope my question is clear...

                Raj

                  • Can Qlikview server deployed on a virtual server?

                    Hi Colin,

                    Suppose my qlikview document in the virtual server extracts data from 3-4 QVD files which are stored locally, then can the data from these multiple QVDs be put into one file and then sent to virtual server instead of having the data from each QVD being sent to the virtual server.

                    I hope my question is clear...

                    Raj

                    • Can Qlikview server deployed on a virtual server?
                      Ashfaq Mohammed

                      Hi Arun

                      Yes, You can do that. You can do any sort of transformations on qlikview server.

                      you can merege all qvd's into one. but have to follow some standard rules.

                      Hope that helps

                      Regards

                      ASHFAQ

                        • Can Qlikview server deployed on a virtual server?

                          Hi Ashfaq / Colin,

                          Thank you for the information. I have one more question and I would highly appreciate if you could answer it.

                          Suppose my client has business purpose databases (such as at their payroll, sales, etc.) on their own site and a qlikview server on a virtual server at a remote location in a data center.

                          In the above scenario, huge amount of data has to be extracted from the local databases to the remote virtual server which could lead to bandwidth overload.

                          I was wondering if I could have a Small Business Edition Server with 4 CALs on the remote virtual server and have one CAL on the local client site so that instead of sending huge amount of data directly to the remote server, a QVD could be built locally using one CAL and then published to the remote virtual qlikview server to be viewed by other users.

                          Or

                          Do you have any suggestion for enhancing performance without bandwidth overload where the Qlikview server in on a virtual and REMOTE platform?

                          Thanks and Regards

                          Raj

                            • Can Qlikview server deployed on a virtual server?
                              Ashfaq Mohammed

                              Hi arun.

                              I agree with your approach.

                              Bandwidth consumptions and all comes into consideration when you have compleated your project.

                              This is the time wherein you can give Exact memory required on server.

                              As colins said you have to have higher ram. In order to overcome loads.

                              And I don't think it will take time to reload data on virtual machine even if you are loading data from data center.

                              Provided they are in same domain and on the same network.

                              Hope that helps

                              Regards

                              ASHFAQ

                              • Can Qlikview server deployed on a virtual server?
                                Colin Hancox

                                We have a client with much the same setup - 12 remote servers, of which six are in other countries connected by 128k or 256k satellite links, so reducing bandwidth is very important. We have an instance of QlikView running on each server extracting data into QVDs. For large transactional tables we load the existing transaction numbers from the QVDs each night and create new QVDs containing only the new transactions, so we have a QVD per day (or in some cases per week). We have a standalone licence on each server, but you could use a server CAL per server too.

                                We have Windows DFS running from 7pm to 7am to synchronise the folder we store the QVDs in on each remote server with a corresponding folder on the central (virtual) server. You can also achieve this with batch files using the DOS xcopy command.

                                As far as enhancing performance goes, make sure the QVDs are as small as possible, only select fields that you need and try to only transfer new or changed data, rather than transferring entire tables of transactions.

                                Good luck...

                                Colin.

                                  • Can Qlikview server deployed on a virtual server?

                                    Thank you Colin. I think you have helped me understand most of it. I would like to clear a view doubts though...I might sound silly as I am new to QV

                                    1. Are you aware of any methods to pull the full data set ( and not just the changed or new) data from large transactional databases into the remote QV Server?

                                    2.Is it possible to have one CAL deployed on the server where the large transactional databases reside and use it to create a QVD with full data (not just changed data) and have it accessed on the remote server (where the 'enterprise edition' or 'small business edition server' and other CALs are deployed)?

                                    i.e is it possible for the client to buy for example 5 licences,then have one on the server where the large transactional databases reside to create a QVD to collate data and have four of them on the remote Qlikview server for users.

                                    Regards

                                    Raj

                                      • Can Qlikview server deployed on a virtual server?
                                        Colin Hancox

                                         

                                        1. No, if you're extracting the full dataset into a QVD, that is about as compressed as you are going to get it. You could try setting up an ODBC connection to your database from the remote QV server and extracting remotely, but we found that extracting the QVDs and transferring those was more reliable.
                                        2. Yes. If you open a remote server document from QlikView on the transactional server and get allocated a CAL, you will then be able to use that instance of QlikView to extract data. I have a situation where I do exactly that, and it has been running for over a year without me having to reconnect to the server to reissue the CAL.

                                         

                                        Colin.

                                          • Can Qlikview server deployed on a virtual server?

                                            Hi Colin,

                                            In point 2, you have stated that we can allocate a CAL to the transactional server. What I would like to know is:

                                            If the client has bought 5 CALs along with QlikView Small Business Edition Server and deployed in a remote location then would they have to buy another QlikView Small Business Edition Server for the transactional server?

                                            or just use one of their CALs for the transactional server?

                                            The reason I am asking is because I do not know whether the CALs bought can be divided and allocated between two or more servers.

                                            Regards

                                            Raj

                                              • Can Qlikview server deployed on a virtual server?
                                                Colin Hancox

                                                No, you wouldn't need to buy another server licence. You would install QlikView Developer on the transactional server and then select Open in Server from the Start Page and connect to your QlikView server. As long as they are on the same network you should be OK. Once QlikView on your transactional server has leased a licence, you will be able to have it running your QVD extraction on that server.

                                                Colin.

                                • Can Qlikview server deployed on a virtual server?
                                  Colin Hancox

                                  Hi Raj

                                  I have been running QlikView 9 on a virtual Windows 2003 64 bit server for about a year, with no problems. My only recommendation would be to make sure you have more than one CPU allocated, otherwise performance, especially reloads, can be slow.

                                  Colin.