Home Analytics DevShare
The community of Analytics developers are invited to follow and participate in the developer network.
OpenText technical experts collaborate with supported customers and partners in the Magellan product area.

BIRT Report with database write-back

edited July 1, 2013 in DevShare
This is an example of using a servlet to write-back data from a BIRT report to a database.



The servlet uses a copy of ClassicModels for SQL Server, but it could be adpated to any RDBMS.

Once the servlet is compiled and jarred, put the jar file in your iportalWEB-INFlib folder. Then, modify your web.xml file to add the following entries and re-start iPortal:
<>
 <servlet>
  <servlet-name>BirtWriteBack</servlet-name>
  <servlet-class>com.actuate.aces.servlet.BirtWriteBack</servlet-class>
 </servlet>
 <>
 <servlet-mapping>
  <servlet-name>BirtWriteBack</servlet-name>
  <url-pattern>/servlet/BirtWriteBack</url-pattern>
 </servlet-mapping>



The report design uses the new A10 HTML button to update one row of the report. The JavaScript code to call the servlet is in a text item at the top of the report.

Pierre Richer

Solutions Consultant, Analytics & Reporting

OpenText

 

Sign In or Register to comment.