Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. READ MORE

Qlik Replicate: Data source name not found error when testing Redshift target endpoint point connection

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
Dineshan
Support
Support

Qlik Replicate: Data source name not found error when testing Redshift target endpoint point connection

Last Update:

Sep 1, 2023 8:45:49 AM

Updated By:

Sonja_Bauernfeind

Created date:

Sep 1, 2023 8:45:49 AM

After upgrading the Qlik Replicate to 2023.5.0.322 and upgrading the Redshift driver to 2.0.0.8, testing the Redshift endpoint fails with the following error:

00004260: 2023-08-28T16:06:05:467371 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [1022502] (ar_odbc_conn.c:584)
00004260: 2023-08-28T16:06:05:467371 [SERVER ]E: Cannot connect to Cloud server [1022505] (cloud_imp.c:4397)

 

Resolution

To resolve this error, verify that the correct ODBC driver version is installed and is correctly named. The supported driver version is listed in Get started with Amazon RedshiftFor Qlik Replicate May 2023, the version is 1.4.34.1000 or later.

If a later version of the driver is installed, such as 2.0.0.8, the driver name will have changed and may not match the one expected by Qlik Replicate. This can be resolved by editing the driver name in the Qlik Replicate Web Console. 

To rename the driver:

  1. Open the Qlik Replicate Web Console

  2. Open your Redshift endpoint

  3. Open Advanced 

  4. Review the ODBC driver name.

    The default name is Amazon Redshift (x64), which is the name of the installed driver for versions such as 1.4.34.1000. Later versions, however, use a different driver name.

    • For version 1.4.34.1000 the default name is correct
    • For version 2.0.0.8, change the name to Amazon Redshift ODBC Driver (64-bit)

      change driver name.png

      You can verify what the installed driver is named in the ODBC Data Source Administration panel in Windows (see Fig 02).

Cause

The installed driver is named Amazon Redshift ODBC Driver (64-bit), while Qlik Replicate expects Amazon Redshift (x64). 

Fig 02Fig 02

 

Environment

Qlik Replicate 

Labels (1)
Version history
Last update:
‎2023-09-01 08:45 AM
Updated by: