I have installed a BI server community edition and create a DataSource. This DataSource connect with a PostgreSQL database in another server (JDBC). Now, I have the Report Designer and I want to use the DataSource created in BI CE Server.
I can connect with PostgreSQL database from Report Designer creating a JDBC Datasource, but I want to connect with the DataSource created in BI Server.
How could i do that?
Best regards.
You can do that creating a JNDI connection in Pentaho BI Server and Pentaho Report Designer (PRD). I leave this links of my blog where I have instructions of how to do it:
Also, when you create a report using PRD you have to Publish it to Pentaho BI Server. I hope it helps you.