mit.navn.marcus Posted August 6, 2019 Share Posted August 6, 2019 Hello,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 metadataIs this possible? my solution is based on the github project: https://github.com/TIBCOSoftware/js-docker Link to comment Share on other sites More sharing options...
swood_1 Posted August 11, 2019 Share Posted August 11, 2019 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. Sherman Link to comment Share on other sites More sharing options...
mit.navn.marcus Posted August 14, 2019 Author Share Posted August 14, 2019 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? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now