Dremio ODBC Connection String Set up in Alteryx Server Data Source Connection

[zzy98y]

Hi Alteryx Community, 

I want to set up the Dremio ODBC connections on Alteryx Server because most of my workflow involves Dremio connection as a Input Data. 

I was able to set up things through DSN with Dremio. But in order to run workflow on the Alteryx Server, I need to have this set up on the Server. 

I am using UID, PWD and UseEncrpytion = 0, Host, Port. 

Anyone know what is the connection string format for Dremio? I googled bunch and looked through their documentations, none of them worked for me so far. 

It would be great if anybody can share what they know! 

Thanks for your help! 

[fmvizcaino · Accepted solution]

Hey @zzy98y ,

I would look here for insights and see if one of the examples applies to your case. 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/How-to-format-common-ODBC-D...

Another option is to keep using the DSN connection, not ideal but it works. For that, you need to standardize the DSN connection name between all the designer users and request an admin to create a system DSN on the Alteryx Server`s machine.

Best regards,

Fernando Vizcaino