Home
Administrator Guide
This guide describes how to install Rational® Integration Tester. After you install the software, you can perform administration tasks such as configuration and integration of the product. This guide is intended for administrators.
Configuration of Rational® Integration Tester
Configuring the project results database
Historical test data and performance results from agents and probes are stored in the Rational® Integration Tester project results database. It is difficult to estimate the space that is required as the number and type of tests to be run varies. For example, lengthy performance tests can generate large amounts of data. When you create the project results database, 50GB is probably a good starting point.
Creating the project results database by using Oracle
You can create a project results database that uses Oracle.

Administrator Guide
This guide describes how to install Rational® Integration Tester. After you install the software, you can perform administration tasks such as configuration and integration of the product. This guide is intended for administrators.
- Installation of Rational® Integration Tester
  You can find information about installing IBM® Rational® Integration Tester from the IBM Rational Test Workbench or IBM Rational Integration Tester package.
- Installation of Rational® Test Control Panel
  You can find information about installing IBM® Rational® Test Control Panel from the IBM Rational Test Workbench, IBM Rational Test Virtualization Server, or IBM Rational Performance Test Server package.
- Configuration of Rational® Integration Tester
  - Installed directories
    When you install Rational® Integration Tester, the following directories are created and populated under the installation directory.
  - User file storage
    Rational® Integration Tester projects store user files, and can be created in any location to which a user has access. However, using a remote or network location can reduce Rational Integration Tester performance significantly, so it is recommended that Rational Integration Tester is installed on a local drive.
  - Changing the display language
    When you want to use the product in a different language other than the display language of your computer, then you can change the language of the product by using the command-line interface. You can find the information to change the language in Linux or Windows.
  - Configuring the project results database
    Historical test data and performance results from agents and probes are stored in the Rational® Integration Tester project results database. It is difficult to estimate the space that is required as the number and type of tests to be run varies. For example, lengthy performance tests can generate large amounts of data. When you create the project results database, 50GB is probably a good starting point.
    - Creating the project results database by using IBM® Db2®
      You can create project results databases that are based on IBM® Db2®.
    - Creating the project results database by using Oracle
      You can create a project results database that uses Oracle.
    - Creating the project results database by using Microsoft™ SQL Server
      You can create project results databases by using Microsoft™ SQL Server.
    - Creating the project results database by using MySQL
      You can create project results databases by using MySQL.
    - Upgrading the project results database schema
      The following provides information about upgrading the schema version of an Rational® Integration Tester project results database, and illustrates the process with an example.
  - HTTP/TCP proxy setup
    The process of configuring applications to use the HTTP/TCP proxy varies according to the application.
  - Setting up the JDBC proxy
    After you install the JDBC proxy, you must deploy the proxy into the Java™ virtual machine (JVM) of the relevant applications, set up the proxy for use, and verify that it is deployed.
  - Rational® Integration Tester tool packages
    To enable IBM® Rational® Integration Tester to work with certain technologies, you must configure the required libraries by using the Library Manager and also install and configure Rational Integration Tester tool packages that are provided with Rational Test Control Panel.
  - Working with Library Manager
    Rational® Integration Tester uses a plug-in architecture to provide support for various middleware and messaging technologies, so the list of third-party products with which it interacts can become large. You can manage this list by using Library Manager. When support for a new architecture or messaging plug-in is required, you use Library Manager to add that support.
  - Debugging failed Windows™ services
    If one of the programs fails to start as a Windows™ service, it can be difficult to determine the cause. Typically the service fails to start but gives no indication of why. The Windows Event log has nothing useful and the process might not have created its log file.
  - Rational® Integration Tester and Rational® Test Automation Server
    You can publish test reports for tests run on Rational® Integration Tester to Rational Test Automation Server. You can create secrets collections for your project and store them securely on Rational Test Automation Server that you can retrieve the secrets from Rational Test Automation Server during tests at runtime.
- Administering IBM® Rational® Test Control PanelRational® Test Control Panel
  is a server-based web application providing a central repository for virtualized services. The Rational® Test Control Panel allows you to use virtual services published with Rational Integration Tester to create, share, and deploy virtualized test environments in IBM® Rational Test Virtualization Server.
- Integrations
  Rational® Integration Tester supports integration with various other tools for quality management, change management, software configuration management, and deployment automation tools such as UrbanCode™ Deploy.

Creating the project results database by using Oracle

You can create a project results database that uses Oracle.

Before you begin

For information about the supported versions of the database, see the Supported Software > Database section in Software Product Capability Reports.

About this task

The database that you create for Rational® Integration Tester must be formatted to use UTF-8 as the character set. By default, Oracle does not create a database with the UTF-8 character set. When you create a new database, ensure that you select AL32UTF8 in the Oracle database setup.

Procedure

Create a user within a suitably sized tablespace.
Grant the following privileges to the new user: CONNECT, CREATE TRIGGER, CREATE PROCEDURE, CREATE TABLE, CREATE SEQUENCE, CREATE VIEW, and CREATE SYNONYM.
Logged in as the newly created user, run the ghtester_oracle.sql script against your database.
Note: There are various ways to run the script against the database. For example, by using Oracle SQL Command Line utility, run a command of the following format: @"<Installation Directory>/scripts/ghtester_oracle.sql"