Data Sources with Jaspersoft

JasperReports^®,  Jaspersoft^® Studio and JasperReport^®V Server come with a wide variety of data source connectors that can be used for reporting, ad hoc analysis etc. Here are instructions for some data sources that are not included.

Google Big Query

https://community.jaspersoft.com/project/google-bigquery-connector

Snowflake

The latest Snowflake JDBC driver is downloadable here:
https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc

Adding a JDBC driver to JasperReports Server:
https://community.jaspersoft.com/documentation/jasperreports-server/tibco-jasperreports-server-administration-guide/v900/jasperreports-server-admin-guide-_-datasources-_-managing_jdbc_drivers/#top

You can do this through the Jaspersoft web admin UI.

For Snowflake JDBC to work in JRS, a setting needs to change in the server config files:
https://community.jaspersoft.com/wiki/how-remove-readonly-flag-jdbc-and-jndi-data-sources-jasperreports-server

One thing we have seen with Snowflake is that the list of schemas and tables visible in the domain designer can be wrong with a lot of duplicates. The following command run once for each userid connecting to Snowflake fixes it.

alter user <db_user>,  set CLIENT_METADATA_REQUEST_USE_CONNECTION_CTX=true;

References

• https://community.jaspersoft.com/knowledgebase/how-to/connecting-jasperreports-server-your-database/
• https://community.jaspersoft.com/documentation/jasperreports-server/tibco-jasperreports-server-administration-guide/v900/jasperreports-server-admin-guide-_-datasources-_-datasources_intro/, which includes the list of data sources supported by JasperReports Server out of the box.