Toad DevOps Toolkit PL/SQL Code Analysis

tdt_1.0.1.14_code_analysis_example.ps1

# 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
  $DBObject = $TDT.CodeAnalysis.DBObjects.Add()
  $DBObject.ObjectName = 'OBJ_NAME'
  $DBObject.ObjectOwner = 'OBJ_OWNER'
  $DBObject.ObjectType = 'OBJ_TYPE'

  # Execute Code Analysis
  $TDT.CodeAnalysis.Execute()
} finally {
  # Quit Toad DevOps Toolkit
  $TDT.Quit()
}