Jenkins throws [odbc drive manager] data source name not found and no default driver specified in hive connection

  alteryx, jenkins, odbc, user-controls, windows

I have an alteryx workflow that inputs data at hive, using an ODBC connection. This workflow works just fine with the default user, but when I use the jenkins user it throws the following error:

[odbc drive manager] data source name not found and no default driver
specified in hive connection

I am using a microsoft notebook with both users.

The ODBC driver is Cloudera ODBC Driver for Apache Hive version 2.06.04.1004 and I use Kerberus to authenticate my connection to Hive.

The jenkins user is at C: and my other user (where everything works fine) is at D:

I call the alteryx at jenkins with the following code:

"C:PathToAlteryxInstallAlteryxbinAlteryxEngineCmd.exe" "D:PathToAlteryxFileAlteryxFile.yxmd"

I also tried the following command:

SET ALTERYXURL=C:PathToAlteryxInstallAlteryxbin
pushd %ALTERYXURL%
chcp number
SET PROJECTFOLDER=D:PathToAlteryxFile
AlteryxEngineCmd.exe "%PROJECTFOLDER%AlteryxFile.yxmd"

I checked some other questions and they said it could be because my notebook users are different, although the hive and alteryx user is the same. How do I make it work on jenkins user as well?

Source: Windows Questions

LEAVE A COMMENT