Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

Only one/first column present inside the data table(s) is visible in Azure data warehouse(DW) data source.

Rich Talbot
  • Updated
Date Posted:
Product: TIBCO Spotfire®

Problem:

Only one/first column present inside the data table(s) is visible in Azure data warehouse(DW) data source.


Solution:

While making use of the data source template 'SQL Parallel Data Warehouse (SQL PDW)' present in the community link for the JDBC connection: https://community.tibco.com/wiki/tibco-spotfire-jdbc-data-access-connectivity-details#toc-33 to connect to the Azure DW, only first column from all the data tables/schema is visible while expanding the data source. To resolve it, follow the below steps:

1) Stop the Spotfire Server Service and remove all the mentioned JDBC driver(s) -> SQLJDBC4.Jar and mssql-jdbc.jar from the below folder(s) of the TIBCO Spotfire Server Installation Directory: \tomcat\lib,\tomcat\custom-ext,\tomcat\spotfire-lib and \tomcat\webapps\spotfire\WEB-INF\lib

Note: Take the backup of the driver(s) which are being removed. 

2) Download the 'sqljdbc42.jar' driver from the link: https://www.microsoft.com/download/details.aspx?id=11774 or 'mssql-jdbc-8.2.2.jre8.jar' from the link: https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15

3) Place the driver inside the \tomcat\custom-ext folder and restart the Spotfire Server Service.

Related articles