Summary
This Connector allows Spotfire® users to connect to Azure Databricks using Azure AD Token Authentication or an Azure AD Personal Access Token. The functionality once connected is identical to the GA Spotfire® Apache Spark SQL Connector.
More details about custom connectors can be found in this article.
Release v17
Published: August 2023
This zip file contains versions 10.3.17.0, 11.5.17.0 and 12.0.17.0 of the
Custom Connector For Spotfire® To Connect To Azure Databricks
v10.3.*.* is for Spotfire® 10.3 through 11.4
v11.5.*.* is for Spotfire® 11.5 through 11.8
v12.0.*.* is for Spotfire® 12.0 and newer
The build date is August 22nd 2023.
Fixed: Some previous versions of the 12.x build would not deploy onto Linux based Web Players and Automation Services.
Only updated build process - no code changes.
*******************************************************************************************
June 28th 2023. Build Number: 10.3.16.1, 11.5.16.1 and 12.0.16.1
Updated: Signing Certificate - No code changes
*******************************************************************************************
Jan 20th 2023. Build Number: 10.3.16.0, 11.5.16.0 and 12.0.16.0
New: Connector now supports specifying a CATALOG via the Advanced Properties. This is to
support Unity Catalog on Azure Databricks Premium Tier.
Fixed: Connection Form wording was confusing when using a Personal Token
Fixed: Issues when switching between Personal Token and AAD Authentication
Fixed: Issue when saving Data Connection with stored credentials to the library
*******************************************************************************************
Nov 10th 2022. Build Number: 10.3.15.0, 11.5.15.0 and 12.0.15.0
Fixed: Support spaces in Table Column Names
*******************************************************************************************
May 25th 2022. Build Number: 10.3.14.0, 11.5.14.0 and 12.0.14.0
Breaking Change: When upgrading to Spotfire 12, existing users must re-create any encrypted
Preferences. Only existing users are affected by this change which is
required to enable Linux support.
New: The Connector can now be deployed on Web Player on Linux with Spotfire 12
*******************************************************************************************
May 25th 2022. Build Number: 10.3.13.0 and 11.5.13.0
Changed: Temporary DSNs are no longer used when connecting to Azure Databricks
Changed: Version numbering changed from x.y.0.z to x.y.z.0 to comply with corporate standards
*******************************************************************************************
December 30th 2021. Build Number: 10.3.0.11 and 11.5.0.11
Fixed: Deadlock when validating Custom Query
*******************************************************************************************
December 30th 2021. Build Number: 10.3.0.11 and 11.5.0.11
New: Advanced Connection Options. Allows specifying of ODBC Driver Connection Properties
including which ODBC Driver to use via the Driver Property.
Fixed: Improve user feedback when Azure Token retrieval fails
*******************************************************************************************
December 21st 2021. Build Number: 10.3.0.9 and 11.5.0.10
Fixed: Error when installing the Connector on Spotfire 11.6
*******************************************************************************************
June 29th 2021. Build Number: 10.3.0.9 and 11.5.0.9
New: The ability to retrieve the Access Token for the current user via IronPython is
now enabled/disabled via a Preference setting
New: Encryption of Preferences settings is now optional
*******************************************************************************************
June 23rd 2021. Build Number: 10.3.0.8
New: There is now a new Helper Class to retrieve the Access Token for the current users
session. This can be called via IronPython using
from Spotfire.Dxp.Data.Adapters.AzureDatabricksCustom import TokenHelper
access_token = TokenHelper.getAccessToken ( Application )
where Application is the IronPython Application object.
NOTE: The user must have authenticated with Azure Databricks using the Custom Connector
for this to work.
*******************************************************************************************
June 22nd 2021. Build Number: 10.3.0.7
New: There are now separate Proxy Settings for Spotfire Analyst and
Spotfire Web Player + Automation Services.
*******************************************************************************************
June 18th 2021. Build Number: 10.3.0.6
New : Access Token is now refreshed when it is about to expire (< 1 minute)
New: Spotfire Web Player is now supported.
*******************************************************************************************
June 14th 2021. Build Number: 10.3.0.5
Breaking Change: Encryption is now required for the Connector Preference information.
The Custom Tool MUST be used to create an encrypted configuration and
this MUST be used in the Connector Preference setup.
*******************************************************************************************
June 10th 2021. Build Number: 10.3.0.4
New : A new Preference option was added to control whether the User Consent form is shown
during Microsoft Login
New: A Custom Tool was added which must be used to create the Preference Settings. The
tool refers to encryption but this has not yet been enabled
Breaking Change: The Preference settings are now a single value and must be re-entered
via the Spotfire Administration Manager.
*******************************************************************************************
June 8th 2021. Build Number: 10.3.0.3
Fixed: Creating a connection required the user to be an Administrator on their local machine.
This is no longer the case.
New: The Connection UI has been updated to provide better feedback about whether the user
can Sign In with Microsoft.
*******************************************************************************************
June 6th 2021. Build Number: 10.3.0.2
New: The Connector now supports the use of a Personal Access Token as an alternative to
signing in to Azure Active Directory.
Fixed: Connection via a Proxy Server now works with Username and Password authentication
*******************************************************************************************
June 3rd 2021. Build Number: 10.3.0.1
New: Added Proxy Server support
*******************************************************************************************
May 31st 2021. Build Number: 10.3.0.0
Initial Release
This version is for Spotfire 10.3 and newer.