I've made a jaspersoft server that's running on a docker host, it has access to a database running on the same docker host, which it can connect to when you're on the jaspersoft server.
My user, has access to the website but not the database directly. He is to make reports using jaspersoft studio.
So I want him to be able to use the datasource that I have made on the website, since he can't use an data adapter that he has made on his end.
I've tried importing the datasource from the server as a local data adapter but then jaspersoft studio is stuck getting metadata
Is this possible?
my solution is based on the github project: https://github.com/TIBCOSoftware/js-docker
This is a general issue about how to expose a data source running with a container to the outside world for development purposes. This is exactly the same as accessing a database behind a firewall.
You have 2 options that I can think of:
- Expose the port(s) the data source is running on, just like you would do for a web server.
- Use a bastion pattern, where there is a container within your container environment that has SSH exposed, which you can then use to tunnel into the data source container.
Thanks for you answer Sherman.
I've been reading about subreports and was wondering if they could be used.
Do you think it would be possible to make a main report for the user that's on the server, and then the user would make subreports of that using the same connection?