Real Time Data in Qlikview from Oracle

[Anonymous]

How to get Real time Data from Oracle in Qlikview ?

[buzzy996]

u can create either ODBC or OLEDB connection on qlikview edit script and simply reload ur data through ur query.

[vinod2086]

Hi Nitish,

first you have to create ODBC/OLE DB Drivers(if it is already created no need to create again) after that you need to select the oracle db then give data source name , USERNAME and PASSWORD.

after that you would select the required tables from DB.

[Anonymous]

Thanks Shiva and Vinod for your reply , but I  Know that . I have a table Suppose Table X it takes around 1 hour to reload completely by using incremental load . I want once the record comes in Table x as soon as possible it should comes in Qlikview

[buzzy996]

what is the frequency of data loading from ur source Table x to QlikView through Incremental Aggregation?

[Anonymous]

Take a look at the "direct discovery" feature.  It gives access to the data without loading into QV application.

Otherwise, "as soon as possible" in your case is one hour.