Placing JDBC drivers for BIRT and e.Spreadsheet Reports

In order to utilize JDBC drivers to access data for your BIRT reports with the Web Viewer or through the Actuate iPortal or iServer Express, the Jar files need to be placed in the proper directory.  The following describes the location to place JDBC jar files according to the product being used.

BIRT Web Viewer: 
WEB-INF\platform\plugins\org.eclipse.birt.report.data.oda.jdbc_\drivers
(within the context of the application)

iPortal for BIRT reports: 
WEB-INF\platform\plugins\org.eclipse.birt.report.data.oda.jdbc_\drivers
(e.g. C:\Program Files\Actuate9\iPortal\webapps\iportal\WEB-INF\platform\plugins\org.eclipse.birt.report.data.oda.jdbc_2.2.2.v20071218-1951\drivers)

iPortal for e.Spreadsheet  reports:
iportal/JavaReportAPI/engines/ess/lib
(e.g. C:\Program Files\Actuate9\iPortal\webapps\iportal\iportal\JavaReportAPI\engines\ess\lib)

iServer Express - e.Spreadsheet:
ACTUATE_HOME\iServer\JavaReportAPI\engines\ess\lib
(e.g. C:\Program Files\Actuate9\iServer\JavaReportAPI\engines\ess\lib)

iServer Express - BIRT:  ACTUATE_HOME\Jar\BIRT\platform\plugins\org.eclipse.birt.report.data.oda.jdbc\drivers
(e.g. C:\Program Files\Actuate9\Jar\BIRT\platform\plugins\org.eclipse.birt.report.data.oda.jdbc_2.2.2.v20071218-1951\drivers)

You will also need to either redeploy your application, or restart the app server.