Home Services Partners Company
Improve Qlikview ODBC reload performance against DB2 by 2X

Improve Qlikview ODBC reload performance against DB2 by 2X

February 12, 2013 0 Comments

The Visual Data Group published Qlikview best practices for data access which recommends DataDirect's Teradata ODBC driver for high performance.  Lately, I have been working with Qlikview shops to improve performance against DB2 across LUW, z/OS and iSeries (AS/400).  From reading Qlikview communities, I have also seen recommendations to use OLE DB over ODBC to improve performance, however my testing scenario concluded that ODBC was the fastest solution when accessing DB2.

Getting Started with Qlikview and DataDirect Connect for ODBC DB2 Wire Protocol driver

qlikview0

Watch the video showing performance improvement of 2X!

Note: While this specific case resulted in an approximately 2X performance increase, DataDirect recommends testing performance in your own production like environment.  If you are not seeing the desired performance, please contact us for professional tuning services available as part of your trial period.

Performance Summary

  • Windows 7
  • DB2 on AIX v9.5
  • Qlikview Personal Edition 11.20  32-bit

06:15 minutes to load 2,563,410 rows using Default DB2 driver

qlikview1

03:13 minutes to load 2,563,410 using DataDirect Connect64 for ODBC DB2 Wire Protocol Driver

qlikview2

Learn more about high performance ODBC connectivity with Qlikview

Contact us to learn more about high performance ODBC connectivity and professional tuning services available from our brilliant team of Systems Engineers.

Sumit Sakar

Sumit Sarkar

Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others. 

Comments
Comments are disabled in preview mode.