hamermike

# Import win32com.client so that we have easy access to COM interfaces.
import win32com.client

# Connection information used to connect to your Oracle database.
source_connection = "SCOTT/SCOTT_PASSWORD@ORA_DATABASE"

# Start Toad DevOps Toolkit.
tdt = win32com.client.Dispatch("Toad.ToadAutoObject")

# Create and assign a Toad DevOps Toolkit connection.

hamermike

# Start Toad DevOps Toolkit
$TDT = New-Object -ComObject 'Toad.ToadAutoObject'
try {
  # Set Code Analysis parameters
  $TDT.CodeAnalysis.Connection = $TDT.Connections.NewConnection('user/pwd@db')
  $TDT.CodeAnalysis.ReportName = "CA Report"
  $TDT.CodeAnalysis.OutputFolder = "C:\Output"
  $TDT.CodeAnalysis.ReportFormats.IncludeHTML = $TRUE

  # Set database objects to Analyze