BIRT
Installing BIRT on Windows 10
-Business Intelligence Reporting Tool
Installation and Configuration Steps
- Download birt-rcp-report-designer-4.8.0-20180626-win32.win32.x86_64.zip from here: http://download.eclipse.org/birt/downloads/. Look for RCP Designer partway down the page.
- Extract the BIRT folder from birt-rcp-report-designer-4.8.0-20180626-win32.win32.x86_64.zip and put it on my desktop.
- Install the 64-bit version of Java 1.8.
- Download the PostgreSQL JDBC driver referenced here: http://wiki.arcs.com/article/BIRT_With_Postgres . Its name is postgresql-42.2.5.jar. Put it in your javapath folder, which you will find by looking at the computer's Environment paths. Here's the path: C:\Program Files (x86)\Common Files\Oracle\Java\javapath. (Why is it the 32-bit program files???)
Starting a New Report
Start a new report. Then Data/New Data Source/Select a Data Source Type. Choose "Create from a data source type in the following list", then "Select JDBC Data Source." In "Create a new data source", org.postgresql.Driver (v42.2) should be in the list (because BIRT found it in the Java path).
Here's the data source I created, using formatting from http://wiki.arcs.com/article/BIRT_With_Postgres and information from Sharon. When I click on Test Connection, I get a message that the connection was successful.
If org.postgresql.Driver doesn’t show up in the Driver Class dropdown list…
Click on Manage Drivers…
Click on Add…
Browse to the postgresql file and click on Open. It should then show up in the Driver Class dropdown list.
Additional Links
-http://wiki.arcs.com/article/BIRT_With_Postgres