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:

Note: Ensure the installation account at the database level possesses DBA privileges and that Java 17 is installed.

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

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

Note: Tidal Automation will install and connect to the DB using the JDBC java drivers.

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.