Product: TIBCO Spotfire®
Only one/first column present inside the data table(s) is visible in Azure data warehouse(DW) data source.
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.