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:
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.
------------------------------------
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
- How to Check a Database’s Compatibility Level in SQL Server using T-SQL
Feedback
thumb_up
Yes
thumb_down
No