HCL Workload Automation, Version 9.4

Configuring for an Oracle database

About this task

Actions taken on HCL Workload Automation engine:

For Oracle, the IT administrator, or the HCL Workload Automation IT administrator, or both working together, do the following:

Use the TWS Oracle user specified during the master domain manager installation or perform the following steps to create a new user:
1. Create a database user authorized to access the database and specify a password.
2. Launch the following script:
```
<TWA_home>/TWS/dbtools/Oracle/scripts/dbgrant.bat/.sh 
		<ID_of_user_to_be_granted> 
		<database_name> 
		<database_admin_user> <password>
```
  where the variables are as follows:
  <TWA_home>
  
  The HCL Workload Automation instance directory
  
  <ID_of_user_to_be_granted>
  
  The ID of the user created in step 1.a, who is going to be granted the access to the reports
  
  <database_name>
  
  The name of the database, as created when the master domain manager was installed
  
  <database_schema_owner> <password>
  
  The user ID and password of the database schema owner.
Define a valid connection string to the database:
1. Ensure that the following property is set in the <TWA_home>/WAS/TWSprofile/properties/TWSConfig.properties file to point to the Oracle JDBC URL:
```
com.ibm.tws.webui.oracleJdbcURL
```
  For example:
```
com.ibm.tws.webui.oracleJdbcURL=
                    jdbc:oracle:thin:@//9.132.235.7:1521/orcl 
```
  The Oracle JDBC URL is also to be specified in the PARAM_DataSourceUrl property in the .\config\common.properties file. The common.properties file is required when setting up for command line reporting. For more information about this file, see Setting up for command line audit reporting and Setting up for command line batch reporting .
2. Restart the WebSphere Application Server.

Actions taken on the Dynamic Workload Console:

Download the JDBC drivers required by your Oracle server version.
Copy the JDBC drivers in a directory that is accessible by the WebSphere Application Server used by your Dynamic Workload Console.
Create a shared library on WebSphere Application Server specifying the path and filename of the JDBC drivers you have copied, as described in:
Creating shared libraries
Associate the isc Enterprise Application to this shared library, as described in:
Associating shared libraries with applications or modules
Log on to the Dynamic Workload Console.
In Dashboard Application Services Hub navigation bar, select System Configuration > Manage Engines. The Manage Engines panels opens.
Select the engine you defined or create another engine. The Engine Connection properties panel is displayed.
In Database Configuration for Reporting, do the following:
1. Check Enable Reporting to enable the engine connection you selected to run reports.
2. In Database User ID and Password, specify the database user and password that you authorized to access reports.