Azure DevOps integration steps for sql scan

SonarQube Cloud
, ,
1

Template for a good new topic, formatted with Markdown:

  • ALM used Azure DevOps
  • CI system used Azure DevOps
  • Scanner command used when applicable (private details masked)
  • Languages of the repository plSQL
  • Only if the SonarCloud project is public, the URL
    • And if you need help with pull request decoration, then the URL to the PR too
  • Error observed (wrap logs/code around with triple quotes ``` for proper formatting)
  • Steps to reproduce

i am looking for steps to integrate with azure devops with sonarcloud

  • Potential workaround

Do not share screenshots of logs – share the text itself (bonus points for being well-formatted)!

2

Hi Rajesh, welcome to the community!

You can find the first steps in the SonarCloud documentation.

On this page you will find how to connect SonarCloud to your AzureDevops Organization as well as pointers to setup your analysis.

Hope that helps.

Denis

3

we already using sonarlcloud integrated with Azuredevops for .Net.
here we are looking for integrating with sql code.

.sql code scan analysis is working if we use snannerMode is “CLI” - is it right approach ?

do we have to pass any additional configurations for sql project.

  • task: SonarCloudPrepare@1
    inputs:
    SonarCloud: ‘${{ parameters.sonarserviceconnection }}’
    organization: ‘${{ parameters.organisationName }}’
    scannerMode: ‘CLI’
    projectKey: ‘${{ parameters.sonarprojectKey }}’
    projectName: ‘${{ parameters.sonarprojectName }}’