Configuring JDBC Support for BIRT Reports
CentraSite reports mainly use CentraSite Registry Repository (CRR) as data source. In addition to using CentraSite as data source, CentraSite reports can also access SQL databases using the Java Database Connectivity (JDBC).
CentraSite provides a set of report templates that are available to access an Oracle database, but will continue to use
CentraSite as the default data source. For a list of the supported JDBC-compliant report templates, see
Predefined Reports.
These JDBC-compliant report templates can switch the data source dynamically on the basis of the selected target (Mediator).
To enable the access to an Oracle database, you must add the following XML fragment in the customization file, centrasite.xml. You can find this file on <CentraSiteInstall_Directory>\cast\cswebapps\BusinessUI\custom\conf.
<RuntimeDatastore>
<SqlDatabase
targetName='Exact name of CentraSite target'
url='URL of the SQL database (please see below)'
driver='Database system specific driver (please see below)'
user='User with the necessary permissions to access the SQL database'
password='Password of the user'>
</SqlDatabase>
</RuntimeDatastore>
Note: Add an element <SqlDatabase> to the configuration for each target populating the metrics and event data to the SQL database, which should be accessed.
The centrasite.xml file should look as follows:
<?xml version='1.0' encoding='UTF-8'?>
<GUIConfiguration>
...
<RuntimeDatastore>
<SqlDatabase
targetName='Exact name of CentraSite target'
url='URL of the SQL database (please see below)'
driver='Database system specific driver (please see below)'
user='User with the necessary permissions to access the SQL database'
password='Password of the user'>
</SqlDatabase>
...
</RuntimeDatastore>
...
</GUIConfiguration>
You may include multiple <SqlDatabase> entries in the <RuntimeDatastore> configuration. The name of the target, defined by the attribute targetName, is case-sensitive, and therefore the name of the target and the name of the corresponding Mediator must exactly match.
The value of the attribute password will be encoded after accessing the SQL database with a BIRT report for the first time. A password with prefix @secure: is not permitted.
The driver and the URL format depends on the SQL database you are accessing. CentraSite supports the following drivers and URL formats:
DB2
Driver:
com.softwareag.common.jdbc.driver.DB2ProxyDriverURL format:
jdbc:wm:db2://<server_name>:<port>;databasename=<database_name>Microsoft SQL Server
Driver:
com.softwareag.common.jdbc.driver.MSSQLProxyDriverURL format:
jdbc:wm:sqlserver://<server_name>:<port>;databasename=<database_name>Oracle
Driver:
com.softwareag.common.jdbc.driver.OracleProxyDriverURL format:
jdbc:wm:oracle://<server_name>:<port>;sid=<database_name>Sybase
Driver:
com.softwareag.common.jdbc.driver.SybaseProxyDriverURL format:
jdbc:wm:sybase://<server_name>:<port>wherein, the substitution tokens <server_name>, <port>, and <database_name> are placeholders that should be replaced by real values.