Alteryx Designer

Definitive answers from Designer experts.

ERROR: "General error; 1033 error while parsing protocol" while connecting to SAP Hana DB

Created

Issue

 

In the Alteryx Designer, when a user connects to SAP HANA DB using the Input Data Tool, the following error is displayed:

 

ERROR[HY000][SAP AG][LIBODBCHDB DLL][HDBODBC] General error; 1033 error while parsing protocol

This error occurs, right after selecting the DSN name pointing to the SAP HANA Connection. There is a suitable driver for SAP HANA that is downloaded and installed. The connection to the DB is successful from the ODBC Admin window. The issue is only when it is connected from the Alteryx Designer.

 

Environment

  • Product - Alteryx
    • Observed in - 2018.2
  • Product - SAP HANA

Cause

This issue is caused when the user do not give the username and password details in the "Data Source Connection" dialog. Since there is no username and password given here, Alteryx takes this as an SSO Authentication and it errors out.

 

Solution

  1. Click on the 'Input Data Tool" to configure the DSN for SAP HANA. Select the dropdown near to the "Connect a file or database" field, to choose the SAP Hana as the data source name.
  2. The SAP Hana Connection window appears as below:                                    vijayakarthikeyan_1-1578288023556.png
  3. Now, enter the username and password in the above dialog box and click 'OK'.
  4. The SAP Hana connection would be successful now.