Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I load large Oracle tables?
as you would load tables from any other system
you create an odbc and then extract the data you need
As Ramon pointed out you could use an ODBC connection or an OLE DB connection which also provides fetching certain amount of data/rows.
First you need DB connection by using ODBC or OLEDB.
After that we can load the data from Large table by incrementally with QVD's
Tammy,
Find the steps with screenshots for loading data from oracle here https://community.qlik.com/docs/DOC-3089
Hi Tammy,
go to control panel--> administrative tools--> data sources(ODBC)--> from the window that appears select system DSN--> add new source --> select microsoft ODBC for Oracle and check (test) connection
Now in the qlikview script connect to the newly created ODBC connection
Hope it will help!!
Hi,
Use ODBC or OLEDB connections, but make sure the your mechine is having oracle drivers for connectivity.
If your table is too big then you can use the concept called Direct Discovery.
Thanks
Hi,
You can load data from oracle then use ODBC or OLEDB refer google or QV community
Extracting data from Oracle using Qlikview.docx
If you want to optimize the data load from large tables then try to implement Incremental Loading, refer below links
analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/
learnallbi.com/incremental-load-in-qlikview-part1/
learnallbi.com/incremental-load-in-qlikview-part2/
Regards,
Jagan.