8 Replies Latest reply: May 28, 2012 12:11 PM by adi adi RSS

Real Time Server

adi adi

Hi all,

 

I am using Qlikview Server 11 and we want to use Real Time Server to push all the modifications from database into QVW.

I looked for information on forums but I didn't find anything useful about Real Time Server

 

Has someone used Real Time Server? can you give me some information, documentation for it?

How to push data from database to QVW or an alternative.

 

An example would be a huge help.

 

 

Regards,

Adi

  • Real Time Server
    Bill Britt

    Adrain,

    My understanding of this is it is for a few fields of data and not all the database data. You have to write your own program to get the data and push it into QVS.

    • Real Time Server
      adi adi

      Thanks for response.

       

      Then, what is Real Time Server used for?... I'm confused. It updates the modification into QVD files or directly into inmemory of the QVW?

       

      I want to push only modification from database into my documents(qvw)... not all database.

       

      Regards,

      Adi

      • Real Time Server
        Bill Britt

        It updates the data into memory as the server is running the QVW. The data is not saved in the QVW to do that you have to do a reload. This works well with limited data updates but not with large about of data.

        • Real Time Server
          Matthew Fryer

          Real time server allows you to make external calls to QVS to insert a record into a table within an application it is hosting in memory. As Bill said it doesn't get saved to the QVW/QVD file at all.

           

          The real limitation is that RTS only works well with relatively small data sets. Every time a record is added to memory, QV has to calculate the relationships between the new record and all the data it is already hosting. So you can insert a very small record but if you already have billions of records in memory it takes a long time for it to calculate the relationships and insert the record. Trying to insert records faster than it can calculate the relationships and insert them creates a situation where the records get buffered and "Real Time" becomes anything but.

           

          Matt

  • Real Time Server
    adi adi

    Thanks for fast answer.

     

    So...why should I buy a license for Real Time Server(which is so expensive), if I need to create another program to push data to RTS... and it doesn't save data into the QVW/QVD files and work only with small data?!

     

    I have a big question mark.... for what is good RTS?!

     

     

    PS: however can you give me a small example for "External calls"... to realize how it works with RTS.

         It will be a good starting point for many developers.

     

    Regards,

    Adi

    • Re: Real Time Server
      Matthew Fryer

      Basically you've hit the nail on the head. It has its uses but they are very specific. In all the QV implementations I've seen/worked on I have only seen it used twice. The best was a dashboard for monitoring/planning capacity within an emergency department at a hospital and needed to know immediately if a patient was checked in at the reception.

       

      For examples of adding, deleting and updating records in memory, take a look at the "QlikView Automation Reference.pdf" that gets installed with QV in the installation directory under the "Documentation" sub folder.

      • Real Time Server
        Adnan Rafiq

        Dear All,

        This thread is quite useful, and I have same question,

        Can any one tell me that do we require any change in DB or write SQL script differently for realtime update

         

        Regards

        • Real Time Server
          adi adi

          This is what I find... but is useless for me, I want to select from DB and insert into in-memory data.

           

          Dynamic Data Update provides a mechanism for making transactions with the in-memory data of

          QlikView in real-time using syntax similar to SQL. The field data is updated in real-time without

          running the script.

           

          Example:

          Rem Dynamic Data Update

          sub Update

          SET Result = ActiveDocument.DynamicUpdateCommand ("UPDATE * SET

          Discount = if(Discount >= 35, 0, if (City='Stockholm', Discount + 5,

          Discount + 2)) WHERE Country = 'SE'")

          if Result = false then

          MsgBox Result.ErrorMessage

          end if

          end sub

          sub Insert

          SET Result = ActiveDocument.DynamicUpdateCommand ("INSERT INTO *

          (Country, City) VALUES (DK, Copenhagen), (NO, Oslo)")

          if Result = false then

          MsgBox Result.ErrorMessage

          end if

          end sub

          sub Delete

          SET Result = ActiveDocument.DynamicUpdateCommand ("DELETE FROM

          CITY WHERE IsNull (Discount)")

          if Result = false then

          MsgBox Result.ErrorMessage

          end if

          end sub