Enables the powerful SonarPLSQL analyzer.
First Analysis of a PL/SQL Project
- Install SonarQube Server (see Setup and Upgrade for more details)
- Install SonarQube Scanner and be sure your can call sonar-scanner from the directory where you have your source code
- Install SonarPLSQL (see Installing a Plugin for more details)
Run your analysis with the SonarQube Scanner by executing the following command from the root directory of the project:
sonar-scanner -Dsonar.projectKey=xxx -Dsonar.sources=.
- Follow the link provided at the end of the analysis to browse your project's quality in SonarQube UI
Assuming steps 1-3 above have already been completed, you'll want to encapsulate your analysis parameters in a sonar-project.properties file at the root of your project (see a sample project on GitHub: https://github.com/SonarSource/sonar-scanning-examples/tree/master/sonarqube-scanner). Then subsequent analyses can simply be run with:
Accuracy of the analysis can be improved by providing properties to retrieve the data dictionary.
With SonarPLSQL, you can:
- create your own Custom Rules
- change the files to analyze by configuring the property
sonar.plsql.file.suffixes in Settings > General Settings > PL/SQL > File Suffixes