WebLogic

The BIRT Viewer application has been tested using a non-XA data source and a XA data source. The recommendation for creating a Datamart Data Source on WebLogic is to use the non-XA data source. data source.

Create a non-XA data source called <curamdm>, as below with the following settings, create a connection pool data source with no global transactions, add the Cúram node as a target.

Open the Administration Console as detailed in the previous section.

Navigate to <DomainName>+Services+JDBC+Data Sources.
Click the New button; Enter the following fields:
- Name: curamdm
- JNDI Name: jdbc/curamdm
Change the Database Type to be Oracle and set the Database Driver to be Oracles Driver (Thin XA) for Instance connections. Versions:9.0.1,9.2.0,10,11.
Click the Next button.
Leave the default for Transaction Options and click the Next button.
Set the URL Value field to the value below where serverName is the name of the server hosting the database. Port is the port number the database is listening on and databaseName is the SID of the database. This is the URL to connect using Oracle SID name:
jdbc:oracle:thin:@serverName:port:databaseName
Leave all other fields untouched unless a specific change is required.
Click the Next button.
Review the settings and click the Next button.
Select Targets, select the Cúram node.
Click the Finish button.

It is advised to restart the AdminServer at this point, to ensure the changes are correct. To do this:

Navigate to <DomainName>+Environment+Servers.
Select the Control tab, then select AdminServer in the Server's list and click Shutdown+When work completes.
Click the Yes button to shutdown the AdminServer.