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.
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.
Contact us to learn more about high performance ODBC connectivity and professional tuning services available from our brilliant team of Systems Engineers.
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.
Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.