TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Oracle SQL Developer

    Score8.1 out of 10
    N/AOracle SQL Developer is an integrated development environment (IDE) which provides editors for working with SQL, PL/SQL, Stored Java Procedures, and XML in Oracle databases.N/A

    SonarQube for IDE

    Score8.1 out of 10
    N/ASonarQube for IDE is a free IDE plugin that helps developers by detecting and highlighting issues in their code in real time. Like a spell checker, SonarLint detects Bugs, code smells, and Security Vulnerabilities as code is written, and offers guidance.

    $0

    Pricing
    Oracle SQL DeveloperSonarQube for IDE
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    Oracle SQL DeveloperSonarQube for IDE
    Free Trial
    NoYes
    Free/Freemium Version
    YesYes
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    Oracle SQL DeveloperSonarQube for IDE
    Considered Both Products
    Oracle
    No answer on this topic
    SonarSource Sarl
    No answer on this topic
    Key User Insights
    Would buy again
    96%
    Would buy again
    22 Answers
    No answers on this topic
    Delivers good value for the price
    100%
    Delivers good value for the price
    22 Answers
    No answers on this topic
    Happy with the feature set
    96%
    Happy with the feature set
    22 Answers
    No answers on this topic
    Lived up to sales and marketing promises
    93%
    Lived up to sales and marketing promises
    13 Answers
    No answers on this topic
    Implementation went as expected
    100%
    Implementation went as expected
    20 Answers
    No answers on this topic
    Best Alternatives
    Oracle SQL DeveloperSonarQube for IDE
    Small Businesses
    No answers on this topic
    No answers on this topic
    Medium-sized Companies
    Redgate SQL Toolbelt Essentials
    Score9.6 out of 10
    No answers on this topic
    Enterprises
    Redgate SQL Toolbelt Essentials
    Score9.6 out of 10
    No answers on this topic
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Oracle SQL DeveloperSonarQube for IDE
    Likelihood to Recommend
    9.0
    (74 ratings)
    8.0
    (1 ratings)
    Likelihood to Renew
    9.0
    (5 ratings)
    -
    (0 ratings)
    Usability
    8.9
    (4 ratings)
    -
    (0 ratings)
    Support Rating
    7.0
    (2 ratings)
    -
    (0 ratings)
    Implementation Rating
    9.2
    (2 ratings)
    -
    (0 ratings)
    User Testimonials
    Oracle SQL DeveloperSonarQube for IDE
    Likelihood to Recommend
    Oracle
    Almost all development activities (the tool is called "SQL Developer", not "DBA Toolset") can be done easily and quick with [Oracle] SQL Developer. From data model creation (tables, views) to development (creation of procedures, functions, packages) and then testing (SQL Developer includes an easy to use debugger), all tasks can be performed in a single tool.
    It may not be as complete as other solutions for DBA tasks like instance monitoring, but it is usually OK for development and testing environments if you want to do some basic troubleshooting.
    Incentivized
    Read full review
    SonarSource Sarl
    No answers on this topic
    Pros
    Oracle
    • Object Browser in SQL Developer allows you to explore the contents of your database using the connection tree.
    • The SQL Worksheet is an editor that allows for execution of SQL statements, scripts, and PL/SQL anonymous blocks. SELECT statements can be executed to return results in a spreadsheet-like 'grid' or can be executed as a script such to emulate SQL*Plus behavior and output
    • DBA Console allows users with administrative privileges to access DBA features such as database init file configuration, RMAN backup, storage, etc.
    Incentivized
    Read full review
    SonarSource Sarl
    • SonarLint highlights all the issues in our codes and also displays the severity of each issue.
    • SonarLint also provides suggestions for how to fix those code issues which are highlighted.
    • SonarLint starts the processing of the file as soon as it is opened and highlights all the issues which it found.
    • When we fix the issue, we don't even need to create a new build or generate fresh code quality report, as soon as we save the file with the changes, it does the processing again and shows the result if the issue is fixed or not.
    • SonarLint saves a lot of time and effort by saving us from doing fresh build every time and generating new code quality report every time, thus increasing the efficiency and output which is in return beneficial for the client.
    Incentivized
    Read full review
    Cons
    Oracle
    • Inability to run multiple queries on the same database. You can only run one query on a given database.
    • Analytical models created from complex tables isn't accurate, and needs work.
    • Inability to view multiple tables of a database side-by-side. When trying to find correlations between tables, it would help to be able to see them at once on the same page.
    Incentivized
    Read full review
    SonarSource Sarl
    • Sometimes, SonarLint does not highlight the issues in the code correctly.
    • The severity of the issues highlighted is according to the default rules set, we should also be given authority to set the severity of the issues.
    • The default fixes which SonarLint provides should be more enhanced and there should be more fixes available.
    • Sometimes it takes a lot of time for processing of the file when any new file is loaded or changes are saved in a file.
    Incentivized
    Read full review
    Likelihood to Renew
    Oracle
    We had already thought of changing to TOAD, but we decided to stick with Oracle SQL Developer until the end.
    Incentivized
    Read full review
    SonarSource Sarl
    No answers on this topic
    Usability
    Oracle
    Oracle SQL Developer is very easy to use and there are a wide range of courses available which can help you get started just within a day. Data can be exported in multiple formats based on user requirements. Organizational data can be stored and management effectively using Oracle SQL Developer. All the data, tables, sequences, indexes can be easily created and updated in Oracle SQL Developer.
    Incentivized
    Read full review
    SonarSource Sarl
    No answers on this topic
    Support Rating
    Oracle
    Large user community support
    Incentivized
    Read full review
    SonarSource Sarl
    No answers on this topic
    Implementation Rating
    Oracle
    Just download and uncompress!
    Incentivized
    Read full review
    SonarSource Sarl
    No answers on this topic
    Alternatives Considered
    Oracle
    I have started to use Toad for Oracle recently because it is easier to sort and filter results, due to their memory sort feature that puts the results from your query in memory so that you don't have to rerun your query. I have used SQL Developer to easily update records in tables that I need to fix. I haven't found an easy way to do this in Toad other than writing SQL insert statements.
    Incentivized
    Read full review
    SonarSource Sarl
    SonarLint works along with SonarQube
    Incentivized
    Read full review
    Return on Investment
    Oracle
    • It gives 100% return on investment as it is free of cost.
    • No need to have multiple tools for each database
    • Considering the employee training, so one can save money on training, as it is not very hard to use so still savings.
    Incentivized
    Read full review
    SonarSource Sarl
    • SonarLint helps in achieving all the business requirements in a more efficient way.
    • It reduces the manual and redundant work which we would have to do else every time if we did not use SonarLint.
    • SonarLint helps in maintaining code quality, and thus also highlights the loopholes for the cyber attacks and phishing attacks.
    • SonarLint makes work easy and helps the developer to invest less time in manual work thereby increasing their capacity to deliver the maximum output to the client.
    Incentivized
    Read full review
    ScreenShots

    SonarQube for IDE Screenshots

    Screenshot of where SonarQube for IDE identifies and highlights issues in a Java project within VS Code. It also explains why this is an issue, how to fix it, and offers more educational content to help developers grow. SonarLint uncovers issues in over 30 languages, frameworks and IaC platforms. SonarLint is available for VS Code, Visual Studio, Eclipse and JetBrains IDEs.Screenshot of how when connected to either SonarCloud or SonarQube the developer can leverage  SonarQube for IDE to identify complex bugs, share code quality expectations with their team, perform deeper issue analysis, enjoy smart notifications, and unlock additional language analysis opportunities. Connecting is easy and guided for a rapid setup, as seen here in the image.