topic Re: Teradata and QlikView in QlikView

Teradata and QlikView

saumyashah90 — Tue, 19 Nov 2013 08:14:38 GMT

As we know when QlikView hits a database it takes each and every row one by one.
Is there any way to take huge data from database(Teradata) to qlikview fast or performance could be better.

There is thousand's of MB's of data being pulled from the data base

Re: Teradata and QlikView

kaushiknsolanki — Tue, 19 Nov 2013 08:24:30 GMT

Hi,

Use the logic of the Incremental load. This will help you only a set of the data from huge table which is newly updated or inserted.

Regards,

Kaushik Solanki

Re: Teradata and QlikView

Tue, 19 Nov 2013 08:33:44 GMT

Refer to this :

http://community.qlik.com/message/377629

I know its a very long thread, but very useful. You will find tips & tricks to enhance performance in between.

Also, you can find many other discussions on community.

Re: Teradata and QlikView

Tue, 19 Nov 2013 08:49:53 GMT

Incremental loads can help with with the reload performance if you need to have all the data in memory (and your hardware/infrastructure can handle it).

Direct Discovery (QlikView v11.2) or document chaining are worth considering when you need to limit the amount of data being loaded into memory.

Re: Teradata and QlikView

saumyashah90 — Tue, 19 Nov 2013 11:21:56 GMT

yeah i am aware about the incremental approach.

but wanted to know if Direct Discovery could help me out

Re: Teradata and QlikView

Tue, 19 Nov 2013 12:39:13 GMT

The current version of Direct Discovery has a few limitations but it may be the solution to your issue.

An overview can be found here: http://www.qlik.com/us/~/media/Files/resource-library/global-us/direct/datasheets/DS-QlikView-Direct-Discovery-EN.ashx

I believe there are some demos on YouTube too.

Direct Discovery v2 will be released in the near future as part of QlikView v11.2 SR5:

http://community.qlik.com/blogs/technicalbulletin/2013/11/07/qlikview-1120-service-release-5-pre-beta-announcement