About data source connections
Actuate Customer Support publishes the Supported Products and Obsolescence Policy document that describes the data sources, drivers, operating systems, and other software requirements for connecting iHub to data sources. Actuate Supported Products and Obsolescence Policy, available on the Actuate Support site at the following URL, also contains information about the required patches:
iHub connects to data sources when generating reports and using the Actuate Caching service (ACS). The report designer specifies data source connection information in the report design, or you specify it in an external connection configuration file. In most cases, iHub and the database run on different computers for load-balancing purposes, but this division is not mandatory. Running iHub on the database host can improve performance.
The iHub installation process installs and configures DataDirect Connect for ODBC drivers and JDBC drivers. You can also use third-party drivers to connect to data sources, but you must license, install, and configure them.
To connect BIRT reports to other JDBC data sources, place the .jar files for the custom database driver in:
AC_SERVER_HOME\iHub\Jar\birt\platform\plugins\org.eclipse.birt.report.data.oda.jdbc<version>\drivers