Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data load Oracle tables

How can I load large Oracle tables?

7 Replies
ramoncova06
Specialist III
Specialist III

as you would load tables from any other system

you create an odbc and then extract the data you need

sinanozdemir
Specialist III
Specialist III

As Ramon pointed out you could use an ODBC connection or an OLE DB connection which also provides fetching certain amount of data/rows.

Not applicable
Author

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

Siva_Sankar
Master II
Master II

Tammy,

Find the steps with screenshots for loading data from oracle here  https://community.qlik.com/docs/DOC-3089

Anonymous
Not applicable
Author

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!!

hariprasadqv
Creator III
Creator III

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

jagan
Luminary Alumni
Luminary Alumni

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.