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:
- Create a database user authorized to access the database and specify a password.
- Launch the following script:
where the variables are as follows:<TWA_home>/TWS/dbtools/Oracle/scripts/dbgrant.bat/.sh <ID_of_user_to_be_granted> <database_name> <database_admin_user> <password>
- <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:
- 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
- Ensure that the following property is set in the
TWSConfig.properties
file to point to the Oracle JDBC URL:
For example:com.ibm.tws.webui.oracleJdbcURL
The Oracle JDBC URL is also to be specified in the PARAM_DataSourceUrl property in thecom.ibm.tws.webui.oracleJdbcURL= jdbc:oracle:thin:@//9.132.235.7:1521/orcl
.\config\common.properties
file. Thecommon.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 . - Restart WebSphere Application Server Liberty .
- Browse to the following path:
Actions taken on the Dynamic Workload Console:
- Log on to the Dynamic Workload Console.
- In the navigation bar, select . 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:
- Check Enable Reporting to enable the engine connection you selected to run reports.
- In Database User ID and Password, specify the database user and password that you authorized to access reports.