JDBC data source for CentraSite reports

Hi All,

We are currently using 9.9 version of CentraSite . For “reporting” in CentraSite we are making use of Mediator Tables as a datasource for the custom reports . The report is created using BIRT and deployed successfully to CentraSite from Desginer.

When we try to execute the report from Business UI , we are getting the below error.

“org.eclipse.birt.report.engine.API.EngineException: An exception occurred during processing. Please see the following message for details: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.dbprofile. org.eclipse.datatools.connectivity.oda.OdaException ; java.lang.ClassNotFoundException: com.softwareag.common.jdbc.driver.OracleProxyDriver”

I placed the ojdbc jar in the redist directory as I was not sure where else it should be placed and tired executing the report but still throws the same error.

Please suggest what other configurations are suppose to be done to make the datatsource (JDBC ) connection profile of the report to establish connection from CentraSite.

TIA,
Priyadharshini Muniyandi.

Hi Priyadharshini,

The error message names a SoftwareAG class which could not be found.
This class is not part of the ojdbc.jar.

Regards,
Holger