topic Re: Data load Oracle tables in QlikView

Data load Oracle tables

Mon, 22 Jun 2015 19:01:12 GMT

How can I load large Oracle tables?

Re: Data load Oracle tables

ramoncova06 — Mon, 22 Jun 2015 22:25:31 GMT

as you would load tables from any other system

you create an odbc and then extract the data you need

Re: Data load Oracle tables

sinanozdemir — Mon, 22 Jun 2015 22:38:44 GMT

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

Re: Data load Oracle tables

Tue, 23 Jun 2015 00:42:29 GMT

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

Re: Data load Oracle tables

Siva_Sankar — Tue, 23 Jun 2015 01:23:14 GMT

Tammy,

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

Re: Data load Oracle tables

Anonymous — Tue, 23 Jun 2015 01:46:31 GMT

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

Re: Data load Oracle tables

hariprasadqv — Tue, 23 Jun 2015 03:42:47 GMT

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

Re: Data load Oracle tables

jagan — Tue, 23 Jun 2015 03:54:23 GMT

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.