Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Better schedule a data transfer from AS/400 to Qlikview server and then access the data locally. So do we.
Hi Carlos,
what do you mean by data transfer from as/400, what is the type of that data?
thanks
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