Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Slow extraction on AS400

Hi all,

I'm using AS400 as a datasources and currently I'm facing a bad performance when qlikview extract data from AS400, one table only.

This table have 65 of column and around 8million of records, the extraction will took around 6 - 8 hours.

Questions:

1. Is the cause because of the number of columns?

2. or network? because AS400 is not in the same server.

3. The ODBC driver version? which version is the best?

4. How to optimized the extraction time?

Thank you

3 Replies
carlosc
New Contributor II

Re: Slow extraction on AS400

Hi,

Better schedule a data transfer from AS/400 to Qlikview server and then access the data locally. So do we.

Not applicable

Re: Slow extraction on AS400

Hi Carlos,

what do you mean by data transfer from as/400, what is the type of that data?

thanks

carlosc
New Contributor II

Re: Slow extraction on AS400

Hola,

The data type is .dif :

QlikView:

Saludos,

Carlos

De: BayuAditya <qcwebmaster@qlik.com>

Para: carlosc <carlosc@colombit.com.co>,

Fecha: 03/10/2012 05:30 p.m.

Asunto: - Re: Slow extraction on AS400

QlikCommunity

Re: Slow extraction on AS400

created by BayuAditya in Connectivity and Data Sources - View the full

discussion

Hi Carlos,

what do you mean by data transfer from as/400, what is the type of that

data?

thanks

Reply to this message by replying to this email -or- go to the message on

QlikCommunity

Start a new discussion in Connectivity and Data Sources by email or at

QlikCommunity

© 1993-2011 QlikTech International AB Copyright & Trademarks | Privacy

| Terms of Use | Software EULA

Community Browser