Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Data load Oracle tables

How can I load large Oracle tables?

7 Replies
ramoncova06
Valued Contributor III

Re: Data load Oracle tables

as you would load tables from any other system

you create an odbc and then extract the data you need

sinanozdemir
Valued Contributor III

Re: Data load Oracle tables

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

Re: Data load Oracle tables

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
Honored Contributor

Re: Data load Oracle tables

Tammy,

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

qlikviewnovice
Valued Contributor II

Re: Data load Oracle tables

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
Contributor III

Re: Data load Oracle tables

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

MVP
MVP

Re: Data load Oracle tables

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.

Community Browser