When connecting to Microsoft SQL Server using the SQL Server connector in TIBCO Spotfire Analyst, all databases are not listed

When connecting to Microsoft SQL Server using the SQL Server connector in TIBCO Spotfire Analyst, all databases are not listed

book

Article ID: KB0074818

calendar_today

Updated On:

Products Versions
Spotfire Analyst All

Description

In some scenarios, while connecting to a Microsoft SQL Server database through SQL Server connector connection, all the databases are not listed whereas the missing databases are visible when making a connection using SQL Server Management Studio (SSMS) or any other 3rd party tool by making use of the same user credentials.

Below is the information which is getting logged inside the Spotfire Analyst Debug log file:

------------------------------------
2019-12-22T11:48:48,335-04:00 2019-05-22 15:48:48,335 D981@TIBCO.com [35] DEBUG Spotfire.Dxp.Data.Adapters.SqlServer.SqlServerAdapterConnection [(null)] - ConnectAndGetDatabaseNames: Database "Employees" has compatibility level 80. Skipping.
------------------------------------

Environment

All

Resolution

The compatibility level for the missing databases is 80 (which corresponds to SQL Server 2000) and levels below 90 are not supported in TIBCO Spotfire Analyst. 

Note: With the SQL Client data provider option, the data can be loaded inside Spotfire Analyst from the databases which are not listed in the SQL Server Connector connection i.e. all SQL Server database versions are supported in it.

Issue/Introduction

The SQL Server connector connection does not list all the available databases in the TIBCO Spotfire Analyst database drop-down. Only databases with compatibility level 90 or higher are listed.

Additional Information