Product: TIBCO Spotfire®
Validation of the data source template definition failed for Amazon Athena
Sometimes the validation for the data source template for Amazon Athena fails even after placing the required JDBC drivers in the tomcat\lib (10.2 and prior) or tomcat\custom-ext (10.3 and onwards) directory. The XML does not get parsed and shows the following status.
Validation of the data source template definition failed: Database driver com.amazonaws.athena.jdbc.AthenaDriver not found.
The issue seems to be most likely with the JDBC Driver version. The XML fails to parse using any of the 2.0.X versions of the driver. To resolve this issue, we can try to instead use the 1.1.0 (AthenaJDBC41-1.1.0.jar) version of the driver which is compatible with JDBC 4.1 and JDK 7.0.
Download Link: https://docs.aws.amazon.com/athena/latest/ug/connect-with-previous-jdbc.html