Integrate Sonarqube code analysis rules into RedGate SQL Prompt

[upendaravireni]

Hi Team,
Request you to suggest us on is there a way to get the SonarQube recommendations into RedGate with the SQL Prompt Code analysis rules? For example, could we create new rules for business (see screenshot below) that match the SonarQube? Or do the default rules in RedGate match SonarQube?

Thanks,
Upendar

[ganncamp (G Ann Campbell)]

Hi Upendar,

As far as I know, this functionality isn’t currently available. We do offer analysis of T-SQL and PL/SQL starting in Developer Edition($) but we don’t have a way to import RedGate recommendations.

If you really need this functionality, then I see a few ways to go about it:

• convert the RedGate warnings into a Generic Issues report and pull them in that way
• craft a plugin to read the RedGate recommendations from an exported report file (assuming that’s available) and raise them on your SQL code either as External Issues (like we do for Checkstyle, for instance. You’ll find example code for this in our Java, and JavaScript analysis repos)
• craft a plugin that creates RedGate Rules in SonarQube that can be managed via your Quality Profile and then pull in the RedGate findings and raise them as “native” issues against those rules. (Like the Checkstyle plugin.)

 
HTH,
Ann