Information Designer does not display the columns in specific MS SQL Server database views
Article ID: KB0081916
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | All Versions |
Description
Information Designer does not display the columns in specific MS SQL Server database views, even though these can be viewed using SQL Management Studio
Issue/Introduction
Information Designer does not display the columns in specific MS SQL Server database views.
Environment
--------------------
Resolution
If these columns are visible in the database (example: via SQL Management Studio) when accessed with the same user credentials as those used in Spotfire Information Designer, make sure these columns have "DataTypes" defined. If the columns have missing DataTypes, the JDBC drivers that connect the information link to the data source may fail to load them into Spotfire.
Feedback
Yes
No
Powered by
