Qlik Community

Ask a Question

Knowledge Base

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY

The setup routines for the Qlik2-greenplum ODBC driver could not be found. Please reinstall the driver

Sonja_Bauernfeind
Digital Support
Digital Support

The setup routines for the Qlik2-greenplum ODBC driver could not be found. Please reinstall the driver

Qlik Sense cannot connect to a Pivotal Greenplum database, even if a number of new ODBC drivers can be found in the ODBC Data Source Administration.

Examples:

Qlik-apache-hive
Qlik2-greenplum

However, the listed Qlik2-greenplum driver cannot be used to create User/ System DSNs. Such an attempt returns an error similar to the following:

 

The setup routines for the Qlik2-greenplum ODBC driver could not be found. Please reinstall the driver. 

 

setup routines for qlik2-greenplum.png


 

Resolution:


To connect Qlik Sense to Pivotal Greenplum database, the Pivotal ODBC driver needs to be installed and used with the generic ODBC connection via a DSN.  You can obtain the driver here: https://gpdb.docs.pivotal.io/43330/datadirect/datadirect_ODBC_71.html

 

 

 

Cause:


Greenplum driver is part of the installation package of drivers ( DataDirect Connect64) provided by Progress Software, which is utilized in Qlik ODBC Connector Package. However, it is not a supported driver, and therefore there is no UI associated with it in Qlik ODBC Connector Package. More information regarding third-party software installed along with Qlik Sense can be found in the document Qlik Sense® Third Party Software Attributions, Copyrights, Licenses and Disclosures, which is available at http://www.qlik.com/us/-/media/files/legal/license%20agreements/qlik%20sense/qlik-sense-third-party-...

Connectors of Qlik ODBC Connector Package should be added in Data Load Editor > Create new connection > Qlik ODBC Connector Package > select provider. The Package is not meant to be used with generic ODBC connections. Due to license constraints, it is not possible to invoke the driver DLL files directly or create DSN over these drivers.

Labels (1)
Version history
Revision #:
4 of 4
Last update:
‎2021-02-23 10:09 AM
Updated by: