Data Dictionary is not configured warning

SonarCloud
1

When I look in SonarCloud, I always have the following warning:

The Data Dictionary is not configured which prevents rule(s) S3641, S3921, S3618, S3651 to raise issues. See https://docs.sonarqube.org/display/PLUG/Data+Dictionary

However we don’t use any oracle connection, but SQL connection. How do we need to configure this to prevent this warning from coming up?

3

I’m not sure what you mean by:

we don’t use any oracle connection, but SQL connection.

Some possible workarounds:

  • Exclude sql files from the analysis:
    sonar.exclusions=**/*.sql
  • Remove the rules mentioned in the message from the PL/SQL quality profile which is used by your project
4

I mean that we don’t use Oracle databases, but only Microsoft SQL databases.

We don’t want to exclude the sql files, because there is a lot of business logic in the Stored Procedures.

Do you have any tips how to fill in these parameters for Microsoft SQL server/database
https://docs.sonarqube.org/latest/analysis/languages/plsql/

5

I suggest that you configure your project so that files with a “.sql” suffix are analyzed by the T-SQL analyzer instead of the PL/SQL analyzer:

sonar.tsql.file.suffixes=sql,tsql
sonar.plsql.file.suffixes=pks,pkb
2 Likes
6

I suggest that you configure your project so that files with a “.sql” suffix are analyzed by the T-SQL analyzer instead of the PL/SQL analyzer:

But is this valid if the The *.sql files are written in PLSQL?

7

No. The user who asked the original question mentioned that:

My understanding was that this user had .sql files containing T-SQL code.

8

@pynicolas that is correct.

This ticket is allready over a year old and I am not working at the company where this issue was. I don’t know the status is any more.

9

Hi,
I saw this reply of yours, but I’m curious, I’m using sonarcloud with bitbucket pipeline. Is there a way to inject this as a script part in the pipeline?

10

Sorry, I don’t know anything about Bitbucket pipeline.
I suggest that you open a new thread because this one is quite old and not really related to your question.

11

Does sonar.plsql.file.suffixes supports some kind of regex?
I have the situation where my .sql files are in the following format:

example.up.sql
example.down.sql

Apparently, sonar does not recognize it. I already tried setting:
sonar.plsql.file.suffixes=sql
and
sonar.plsql.file.suffixes=sql,up.sql,down.sql

None of the above worked.