Database Support

Before installing TA, you should have database software installed.

The Master support these databases:

• Microsoft SQL Server

• Oracle. TA supports these database platforms when connecting to the Oracle Database:

  • Oracle RAC

  • AWS RDS for Oracle (cloud)

  • Oracle DBAAS (cloud)

  • Oracle Autonomous (cloud)

  • PostgreSQL

Note: For information about the supported database versions, see the TA Compatibility Matrix.

Each Master should have access to up to 20 database client licenses to use as needed during processing.

Microsoft SQL Server Database Requirements

Microsoft SQL (MS SQL) Server users should verify the items before installing TA:

• A DATA folder exists in your MSSQL Server installation.

• There is enough space on the drive to create the TA database.

• The Microsoft SQL Client or the actual database is installed on the machine where the TA Master is installed.

  Note: MS SQL Server must be installed before installing the TA Master either on the same machine where the TA Master is installed or on another machine in the same domain.

• The TA Master and the Client Manager must have Microsoft OLE DB Driver 18 for SQL Server to connect to Microsoft SQL Server, if TLS 1.1 or TLS 1.2 is selected during the TA Master and the Client Manager installation for Windows. Before installing the Microsoft OLE DB Driver 18 for SQL Server for the TA Master and the Client Manager, make sure that you have disabled TLS 1.1 and TLS 1.2.

Oracle Database Requirements

Here are the requirements for using an Oracle database with TA:

• The Master uses only JDBC to connect to any Oracle-related database. TA requires installing the OLE providers for the Oracle 11gR2, 12c, 18c, 19c, and 21c databases on each TA machine. These OLE providers are typically installed only during a full Oracle client install (also known as Oracle Admin Client). Have your Oracle administrator install these drivers on each machine that will run TA. The drivers are called “Oracle Provider for OLE DB” and are selected in the Oracle Windows Interfaces section of a custom install.

• If you are performing a Master installation, your database administrator needs to know the Oracle tablespace datafiles to be used with TA. These three Oracle tablespace data files are created by TA during installation and require at least the stated amount of tablespace:

  ADMIRAL_DATA 400 MB

  ADMIRAL_INDEX 300 MB

  ADMIRAL_TEMP 200 MB

• The tnsnames.ora file must exist on or be available to the TA Master machine. This file is typically found in the Oracle home directory. The tnsnames.ora file should be local since network access may not always be available to the Master service, and it must be available to the TA Master. Verify that the Oracle bin folder is in your system path before installing TA.

• Because TA uses the Oracle Native drivers for connectivity, the Oracle SQL*Net client must be installed and configured on all Windows Masters.

  Note: For information about the supported database versions for all platforms, see the TA Compatibility Matrix.

PostgreSQL Database Requirements

PostgreSQL Server users should verify if the PostgreSQL Server or the actual database is already installed on the machine where the TA Master will be located.

Make sure that the TA Master is installed on the same machine or another machine in the same domain where the PostgreSQL Server is installed.