Spotfire analysis file fails to open in Analyst client with error "The '...' data connector is not available"

Spotfire analysis file fails to open in Analyst client with error "The '...' data connector is not available".

If a Spotfire analysis file is accessing data via a data connector, it may fail to open in the Spotfire Analyst client with the following error message. For example, if the Spotfire Connector for Microsoft SQL Server was used in the analysis file, then the you would see:

ImportException at Spotfire.Dxp.Data:
The 'Spotfire.SqlServerAdapter' data connector is not available.
Reason:
The connector has not been deployed.

Data connection:
Connection

Unavailable connector:
The 'Spotfire.SqlServerAdapter' data connector is not available.

Reason:
The connector has not been deployed. (HRESULT: 80131500)

The data connectors are included in the main Spotfire client deployment, but this issue may occur on a newly installed Spotfire Analyst client that has not updated when connecting to a deployment area on the Spotfire Server which has the Spotfire Analyst client distribution file Spotfire.Dxp.sdn deployed (See Deploying client packages to Spotfire Server for more details)

To resolve, make sure you have deployed the Spotfire Analyst client distribution file Spotfire.Dxp.sdn (which contains data connector adapters) to the Spotfire Server, then launch the Spotfire Analyst client, connect to that server and deployment area, and choose to upgrade the client when prompted.

  Doc: Getting Started with Data Connections

• https://docs.tibco.com/pub/sfire-analyst/14.0.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=connect%2Fconnect_accessing_data_from_external_data_sources.htm&rhsearch=connectors&rhsyns=%20

Doc: Deploying client packages to Spotfire Server

• https://docs.tibco.com/pub/spotfire_server/14.0.6/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/deploying_client_packages_to_spotfire_server.html