JSReportOnline support for postgreSql

Ihsan Ahmed

Hi, Just wanted to know if there is support for PostgreSql via JSReportonline

bjrmatos

hi! since jsreportonline does not support installing custom nodejs modules you can't write a script that uses a postgresql nodejs module to extract data for your reports. however you can extract the data in your own backend and send it to jsreportonline via http and it will work normally. (this is the normal flow when using jsreportonline)

jan_blaha

The @bjrmatos suggestion is the most common implementation.
However I just add two additional options you have:

Expose a REST API in your application and use jsreport custom script to fetch the data from it.
If you for some reason really need to connect report directly to the db, you can also use AWS lambda or Azure function to do so and request it from the jsreportonline.