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

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.
------------------------------------ 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.

• How to Check a Database’s Compatibility Level in SQL Server using T-SQL
  • https://database.guide/how-to-check-a-databases-compatibility-level-in-sql-server-using-t-sql/