{iframe:src=http://update.sonarsource.org/plugins/plsqltoad.html|width=700|height=250|frameborder=0}
Your browser does not support iframes.
{iframe}

Description / Features

The Toad CodeXpert plugin is an extension of the PL/SQL plugin (commercial) and can only be used with it.

...

• It scans source code from files on disk. This mode is generally used in enterprise environments with configuration management strategies (use tools like Subversion or Clearcase).
• It connects to the database and analyzes all the objects stored in that database. This mode is NOT supported by Sonar.

Usage

Prerequisites

• Quest Software Toad 9.5 or higher with the CodeXpert module (included into Toad for Oracle Xpert, Toad for Oracle Professional and Toad Development Suite for Oracle).
• A connection to an Oracle database if you use Toad 9.x or 10.x. This is a limitation of Toad that needs to be connected to the database even if it is not used by the CodeXpert module. So you can set a “fake” connection to an empty database.

Configuration

The following settings need properties have to be added to set (at project level through the 'sonar-project.properties:# PLSQL plugin specific properties (required if you use Toad)
# Those properties can also be set in $SONAR_RUNNER_HOME/conf/' file or at instance level through the 'sonar-runner.properties' file
# or specified through the Web interface to avoid repeating them on each PL/SQL project.or web interface):

sonar.plsql.toad.exePath=C:/Program Files/Quest Software/Toad for Oracle 10.5/Toad.exe

...

sonar.plsql.toad.login=USER@XE

...

sonar.plsql.toad.password=user_password

Running an a

Activate some rules from Toad CodeXpert in your project quality profile and run a Sonar analysis.

Sonar automatically configures and launches Toad CodeXpert to analyse the PL/SQL codecheck your code against the Toad CodeXpert's rules.

Troubleshooting

Toad Code Xpert CodeXpert 9.x is unable to start from the command-line when the month of the current date contains an accent ("Décembre" in French for example). The workaround for this is to change the regional settings on the machine.

...