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

[carlabernethy]

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

[TrevorS]

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

[carlabernethy]

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

[carlabernethy]

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

[TrevorS]

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

[MichaelAd]

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.

[steven4320555]

Hi Michael @MichaelAd 

cc: @TrevorS 

Is there any update on the DSN less bulk loader capability? 

May I interpret with DSN connection, bulk load is supported?

Many thanks

Steven

[MichaelAd]

Hi @steven4320555,

We have the following article on the bulk load capability - https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Configure-a-Databricks-Conne....

Currently this functionality is only for DNS connections.

Many thanks,

Michael 

[steven4320555]

Thanks for the quick response @MichaelAd 

For those who are working on Spark, there are another useful resource I found today:

Apache Spark Direct | Alteryx Help

Apache Spark on Microsoft Azure HDInsight | Alteryx Help

Apache Spark Code Tool | Alteryx Help