Toad DevOps Toolkit – An Overview

The first impression TDT seems to give is that it is just like the other Toad products–but it is not.

Toad DevOps Toolkit (TDT) is not like the other Toad products, which include a Graphical User Interface.  TDT is based on COM (Component Object Model) objects.

Toad DevOps Toolkit provides the functionality of Toad for Oracle and more as programmable objects.

Toad DevOps Toolkit is not a connectivity and database admin tool, but a tool to perform more complex DevOps evaluations and run DevOps workflows on Oracle database/s.

AWS Relational Database Service (RDS) cannot be used with Toad DevOps Toolkit, because AWS RDS won't let users access the SYS schema, which has the required SYSDBA privileges required by TDT.

TDT may be used with AWS EC2 Instances.

Oracle Database Cloud Service on Oracle Cloud Platform is the only database cloud service that may be used with TDT.

The Source and Target databases used to run the Demo scripts install DEMO schema on the Source and Target databases. The Source and Target Databases must not be the same database.

TDT generates comparison reports in various formats (HTML, CSV, and TXT).

For the Windows PowerShell scripts at least PowerShell 3.0 is required.

TDT may be used with a wide range of Oracle Database versions: 10g to 12c.

Toad DevOps Toolkit may be run with a Jenkins Pipeline making use of the PowerShell plugin to invoke cmdlets/scripts from Jenkins.

Toad DevOps Toolkit API provides several Interfaces and Types.  A few examples:

The ITAConnection interface represents a database connection.

The ITACompareDatabases interface compares and synchronizes database objects from a source database to one or more target databases.

The ITACodeAnalysis interface is used to run code analysis metrics to improve code quality in a database. The Connection property defines the database connection on which code analysis is to be run. The code quality is evaluated using a RuleSet. The AddRuleSet method adds a custom ruleset.

The TATableMatchMode type is used to compare multiple tables.

The TAHalsteadLevel type is used by code analysis.