Toad DevOps Toolkit is not an interactive program like Toad for Oracle. Instead, it is built as a Windows Automation Server (COM) which provides a rich set of APIs that can be programmed and customized to suit your needs. It can also be integrated into any programming environment capable of creating and accessing COM objects.

Learn about Toad DevOps Toolkit

• Check out videos, blogs, news, and more on Toad World at www.toadworld.com/products/toad-devops-toolkit.

• The Toad DevOps Toolkit installation folder includes the following resources to help you get started:

  • Toad DevOps Toolkit help file: Review this file to understand the Toad features that are available. Included in the help file is the complete API reference documentation.
  • Code Analysis rules and rulesets documentation: Use this reference to help you set up Code Analysis to test your code against standard best practices.
  • Basic demonstrations: These demonstrations show you how Toad DevOps Toolkit can be used with PowerShell, VBA, and PL/SQL languages.

Start and stop the toolkit

Since everything about using Toad DevOps Toolkit is up to you — which features you will use, how you want to integrate them into your processes, and so forth — what we can do is show you how to start and stop the toolkit itself. After you review the available features, have a look at the API documentation, and then start programming your database automation tasks to meet your needs.

Start a Toad DevOps Toolkit instance

Like all COM objects, you need to create an instance of Toad DevOps Toolkit for it to be usable. Each invokation of Toad.ToadAutoObject creates its own instance of Toad DevOps Toolkit (tdt.exe).

PowerShell:

$TDT = New-Object -ComObject Toad.ToadAutoObject

VBA:

Dim TDT as ToadAutoObject

PL/SQL:

l_tdt_object   varchar2(100) := 'Toad.ToadAutoObject';
begin
l_result := 
   m.ordcom.createobject(l_tdt_object, 0, '', l_object_token);

Stop the Toad DevOps Toolkit instance

You will need to stop Toad DevOps Toolkit once it is finished running its tasks.

PowerShell:

$TDT.Quit()

VBA:

TDT.Quit

PL/SQL:

l_result := com.ordcom.destroyobject(l_object_token);   	
l_result := com.ordcom.destroyobject(l_com_token);