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

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

Workflow

Settings

Topic of Interest

In Database

Database Connection

In-Database

Accepted answers

All comments

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

madler_alteryx

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 @madler_alteryx

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703