Configure data source connection

BIA uses named data sources to connect to the Cúram database(s), in particular the transaction database (CuramDB) and the data warehouse (CuramDM). The latter is only needed where the data warehouse is installed. The process for configuring data source connection in general is described in the "Deploying BIRT reports to BIRT iServer" manual, supplied with BIRT iServer, for convenience the steps required are listed below:

Create a XML file on the local machine which contains the following:

<Config>
  <Runtime>
    <ConnectOptions Type=
        "org.eclipse.birt.report.data.oda.jdbc_CuramDB">
     <Property PropName="odaDriverClass">$DriverClass</Property>
     <Property PropName="odaURL">$CuramDBConnectionURL</Property>
     <Property PropName="odaUser">$Username</Property>
     <Property PropName="odaPassword">$Password</Property>
   </ConnectOptions>
   <ConnectOptions Type=
         "org.eclipse.birt.report.data.oda.jdbc_CuramDM">
     <Property PropName="odaDriverClass">$DriverClass</Property>
     <Property PropName="odaURL">$CuramDMConnectionURL</Property>
     <Property PropName="odaUser">$Username</Property>
     <Property PropName="odaPassword">$Password</Property>
     </ConnectOptions>
  </Runtime>
</Config>

Replacing the driver class name, connection URLs, usernames and passwords with the appropriate values.

Use the BIRT iServer Configuration Console to configure the database connection to point to the file created above. From Server Templates->Advanced, choose Runtime from the list of property settings. Specify the location of the file.