topic Re: Real Time Data in Qlikview from Oracle in QlikView

Real Time Data in Qlikview from Oracle

Anonymous — Fri, 17 Apr 2015 09:25:50 GMT

How to get Real time Data from Oracle in Qlikview ?

Re: Real Time Data in Qlikview from Oracle

buzzy996 — Fri, 17 Apr 2015 09:31:40 GMT

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

Re: Real Time Data in Qlikview from Oracle

vinod2086 — Fri, 17 Apr 2015 09:40:41 GMT

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.

Re: Real Time Data in Qlikview from Oracle

Anonymous — Fri, 17 Apr 2015 13:42:47 GMT

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

Re: Real Time Data in Qlikview from Oracle

buzzy996 — Fri, 17 Apr 2015 13:45:37 GMT

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

Re: Real Time Data in Qlikview from Oracle

Anonymous — Fri, 17 Apr 2015 14:11:11 GMT

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.