Manually creating a data source in CABI JasperServer for another DB, however, it throws an error in the test connection phase:
The root user being used to access the DB doesn't have privileges to do so.
CABI JasperServer 7.1.1 or later
You can login to the MySQL DB as an admin user and run the following to grant privileges to the root user:
However, this is not the regular way you would connect CABI JasperServer to Spectrum. We do not support any other data sources for CABI JasperServer other than Spectrum.