We are using Jaspersoft Studio v7.3.1 to build BI reports. Eventually, we are going to migrate the underlying datasource to Snowflake cloud. I am unable to establish connection with Snowflake account using the existing Jaspersoft version, tried using the JDBC connection using net.snowflake.client.jdbc.snowflakedriver but it didn’t work.
Below is the error message,
java.lang.ClassNotFoundException: net.snowflake.client.jdbc.SnowflakeDriver cannot be found by net.sf.jasperreports_7.3.1.final
I understand, the version of Jaspersoft is not supporting the above method but here the team is bit reluctant to upgrade the version or migrate to another reporting tool, considering stability & timeline.
Can I please get some guidance here , regarding alternative methods to test snowflake connection. Thanks in advance.
Steps Followed ::
Go to Jaspersoft Studio Professional as an admin
- Click on DataAdapters and Create new data adapter
- In JDBC Url provide – net.snowflake.client.jdbc.SnowflakeDriver
- JDBC URL – jdbc:snowflake://<>.snowflakecomputing.com/
- Added username and password for the snowflake account.
- Test the connection
user3651204 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.