# Azure DevOps integration steps for sql scan

**URL:** <https://community.sonarsource.com/t/azure-devops-integration-steps-for-sql-scan/108690>\
**Category:** SonarQube Cloud\
**Tags:** plsql, azuredevops, sonarqube-cloud\
**Created:** [February 6, 2024, 12:31pm UTC](https://community.sonarsource.com/t/azure-devops-integration-steps-for-sql-scan/108690 "2024-02-06T12:31:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rajesh.allanki](https://avatars.discourse-cdn.com/v4/letter/r/b3f665/32.png) [@rajesh.allanki](https://community.sonarsource.com/u/rajesh.allanki)\
**Post date:** [February 6, 2024, 12:31pm UTC](https://community.sonarsource.com/t/azure-devops-integration-steps-for-sql-scan/108690/1 "2024-02-06T12:31:58Z")

</div>

Template for a good new topic, formatted with [Markdown](https://commonmark.org/help/):

- 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)!**

---

<div class="post-metadata">

**Author:** ![denis.troller](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/denis.troller/32/49117_2.png) [@denis.troller](https://community.sonarsource.com/u/denis.troller)\
**Post date:** [February 7, 2024, 8:12am UTC](https://community.sonarsource.com/t/azure-devops-integration-steps-for-sql-scan/108690/2 "2024-02-07T08:12:25Z")

</div>

Hi Rajesh, welcome to the community!

You can find the first steps in the [SonarCloud documentation](https://docs.sonarsource.com/sonarcloud/getting-started/azure-devops/).

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

---

<div class="post-metadata">

**Author:** ![rajesh.allanki](https://avatars.discourse-cdn.com/v4/letter/r/b3f665/32.png) [@rajesh.allanki](https://community.sonarsource.com/u/rajesh.allanki)\
**Post date:** [February 7, 2024, 8:42am UTC](https://community.sonarsource.com/t/azure-devops-integration-steps-for-sql-scan/108690/3 "2024-02-07T08:42:15Z")

</div>

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 }}’
