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. Browse to the following path:
  
  On Windows operating systems
  
  <TWA_home>\usr\servers\engineServer\resources\properties
  
  On UNIX operating systems
  
  <TWA_DATA_DIR>/usr/servers/engineServer/resources/properties
2. Ensure that the following property is set in the 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 .
3. Restart WebSphere Application Server Liberty .

Actions taken on the Dynamic Workload Console:

Log on to the Dynamic Workload Console.
In the navigation bar, select Administration > 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.