HELP: "Simba Spark ODBC Driver" DSN-Less connection String
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @TrevorS , do you have any further advice or help for this topic? Cheers Carl
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Sr. Customer Support Engineer -- Knowledge Management Coach
Alteryx, Inc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Sr. Customer Support Engineer -- Knowledge Management Coach
Alteryx, Inc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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