While running a query on Tosca Commander using Tosca DI, it returns an “Unknown” as the value where as the query returns valid data when run manually on Google Cloud Platform
Below is the link to the screenshot of the query run on Tosca.
Now, we did raise ticket with the Trecentist support and they quote it to be JDBC Driver issue rather than Tosca DI Issue.
We are currently using:
Driver Version: Simba JDBC Driver Version 1.2.14 Database: SQL Server Management Studio v18.6 Tosca Version: 14
Any responses/solution will be highly appreciated.