Topics created by Zeina Meng

There are two ways of providing data to the report.

You obtain data in your existing application and push it to the jsreport together with your template identification.
In this case you have never problem with connectors because your app is likely already connected to the db you are getting the data from.
https://jsreport.net/learn/api

You use jsreport custom script and beforeRender hook to obtain the data. In this case you can connect everywhere nodejs can connect because custom scripts are evaluated in the nodejs sandbox. This means you can connect pretty much everywhere.
I recommend to check custom script documentation and this example that does the same thing. Find a nodejs driver for the Redshift, likely the one AWS provides. And you are almost there.