topic Re: HELP: "Simba Spark ODBC Driver" DSN-Less connection String in Alteryx Server Discussions

HELP: "Simba Spark ODBC Driver" DSN-Less connection String

carlabernethy — Fri, 14 Jun 2024 14:51:28 GMT

All,

I've managed to setup a DSN connection with both read and write functioning correctly to stream data to Databricks.

However when converting to DSN-Less, as i don't have permission to setup a DSN on the Alteryx Server (far more convenient too), i'm getting an error.

The read connection string I have converted to DSN-Less without any issue, but the write driver part seems to always expect a DSN name based on the error given.

Read Connection String using DSN-Less (No Error)

Write Connection String using DSN (No Error)

Write Connection String using DSN-Less (Error)

Any support or help much appreciated!

Carl

Re: HELP: "Simba Spark ODBC Driver" DSN-Less connection String

TrevorS — Thu, 03 Sep 2020 20:25:10 GMT

Hello @carlabernethy

I would recommend taking a look at this post which discusses DSN-Less connections.
You will need to get the driver for this onto your server environment so you will need assistance from someone within your org who can download that for you and set it up.

Thanks!

TrevorS

Re: HELP: "Simba Spark ODBC Driver" DSN-Less connection String

carlabernethy — Mon, 07 Sep 2020 08:17:06 GMT

Thanks for the response.

Unfortunately your advice doesn't help too much as the driver is already installed on the Server. The "Read" connection string is already DSN-Less and works fine. However the "Write" driver which starts with dbblc does not work as a DSN-Less connection when testing.

Regards,

Carl

Re: HELP: "Simba Spark ODBC Driver" DSN-Less connection String

carlabernethy — Wed, 28 Oct 2020 18:18:10 GMT

Hi @TrevorS , do you have any further advice or help for this topic? Cheers Carl

Re: HELP: "Simba Spark ODBC Driver" DSN-Less connection String

TrevorS — Wed, 28 Oct 2020 21:42:54 GMT

Hello @carlabernethy

I would recommend reaching out to Support@alteryx.com if you are still having trouble as a call may be needed to resolve this for you!

Thanks,

Trevor

Re: HELP: "Simba Spark ODBC Driver" DSN-Less connection String

madler_alteryx — Mon, 02 Nov 2020 11:31:35 GMT

Hi @carlabernethy,

At the moment DSN less connection strings do not work with the bulk loader.

This is a consequence of the design of the special prefix added to the Spark Bulk Loader Connection String dbblc. The connection string parser expects then a DSN.

Thanks.