TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Clear Analytics

    Score8.8 out of 10
    Small Businesses (1-50 employees)
    Clear Analytics is a business intelligence solution that enables non technical end users to perform analytics by leveraging existing knowledge of Excel coupled with a built in query builder. Some key features include: Dynamic Data Refresh, Data Share and In-Excel Collaboration.

    $29

    Per Seat per Month

    DbVisualizer

    Score9.6 out of 10
    N/ADbVisualizer is a universal database client and SQL tool for developers, analysts, DBAs, data engineers, and anyone who works with data, from beginner developers and startups to professional teams managing complex database environments. It provides a graphical interface for exploring database structures, managing schemas and database objects, and running SQL queries across multiple database systems through JDBC drivers, including MySQL, PostgreSQL, SQL Server,…

    $0

    Pricing
    Clear AnalyticsDbVisualizer
    Editions & Modules
    Personal
    $29
    Per Seat per Month
    Team
    $165
    upto 10 Seat per Month
    Department
    $265
    upto 25 Seat per month
    Organization
    $565
    Upto 100 per seat per month
    DbVisualizer Free
    $0
    DbVisualizer Pro with Basic support - Renewal
    $89
    per year per user
    DbVisualizer Pro with Premium support - Renewal
    $119
    per year per user
    DbVisualizer Pro with Basic support
    $199
    per year per user
    DbVisualizer Pro with Premium support
    $229
    per year per user
    Offerings
    Pricing Offerings
    Clear AnalyticsDbVisualizer
    Free Trial
    YesYes
    Free/Freemium Version
    NoYes
    Premium Consulting/Integration Services
    YesNo
    Entry-level Setup Fee$800 Initial OnBoardingOptional
    Additional DetailsCertain Enterprise level features can be made available to Small Business edition at additional cost. Such services include Scheduler and OLAP connectivity. Custom adapters can also be created to connect to SaaS services.New license cost includes a perpetual license, software upgrades and support for the length of the term. 1, 2 & 3 year terms are offered. Once license expires the user may access all Pro versions released before the license expiry indefinitely. To gain access to Pro versions released after the license expired, license renewal is offered. Volume discounts apply to both new and renewal licenses.
    More Pricing Information
    Community Pulse
    Clear AnalyticsDbVisualizer
    Considered Both Products
    Clear Analytics
    No answer on this topic
    DbVis Software AB
    No answer on this topic
    Key User Insights
    Would buy again
    100%
    Would buy again
    8 Answers
    100%
    Would buy again
    60 Answers
    Delivers good value for the price
    100%
    Delivers good value for the price
    8 Answers
    98%
    Delivers good value for the price
    57 Answers
    Happy with the feature set
    100%
    Happy with the feature set
    8 Answers
    98%
    Happy with the feature set
    59 Answers
    Lived up to sales and marketing promises
    100%
    Lived up to sales and marketing promises
    7 Answers
    98%
    Lived up to sales and marketing promises
    47 Answers
    Implementation went as expected
    100%
    Implementation went as expected
    8 Answers
    100%
    Implementation went as expected
    55 Answers
    Features
    Clear AnalyticsDbVisualizer
    BI Standard Reporting
    Comparison of BI Standard Reporting features of Clear Analytics and DbVisualizer
    Feature
    Clear Analytics
    9.0
    8 Ratings
    10% above category average
    DbVisualizer
    -
    Ratings
    Pixel Perfect reports9.08 Ratings00 Ratings
    Customizable dashboards9.18 Ratings00 Ratings
    Report Formatting Templates8.78 Ratings00 Ratings
    Ad-hoc Reporting
    Comparison of Ad-hoc Reporting features of Clear Analytics and DbVisualizer
    Feature
    Clear Analytics
    8.9
    8 Ratings
    11% above category average
    DbVisualizer
    -
    Ratings
    Drill-down analysis9.28 Ratings00 Ratings
    Formatting capabilities8.78 Ratings00 Ratings
    Report sharing and collaboration8.98 Ratings00 Ratings
    Report Output and Scheduling
    Comparison of Report Output and Scheduling features of Clear Analytics and DbVisualizer
    Feature
    Clear Analytics
    9.0
    8 Ratings
    9% above category average
    DbVisualizer
    -
    Ratings
    Publish to Web9.08 Ratings00 Ratings
    Publish to PDF9.17 Ratings00 Ratings
    Report Versioning8.98 Ratings00 Ratings
    Report Delivery Scheduling8.87 Ratings00 Ratings
    Data Discovery and Visualization
    Comparison of Data Discovery and Visualization features of Clear Analytics and DbVisualizer
    Feature
    Clear Analytics
    9.0
    8 Ratings
    12% above category average
    DbVisualizer
    -
    Ratings
    Pre-built visualization formats (heatmaps, scatter plots etc.)8.98 Ratings00 Ratings
    Location Analytics / Geographic Visualization9.18 Ratings00 Ratings
    Access Control and Security
    Comparison of Access Control and Security features of Clear Analytics and DbVisualizer
    Feature
    Clear Analytics
    9.3
    8 Ratings
    9% above category average
    DbVisualizer
    -
    Ratings
    Multi-User Support (named login)9.48 Ratings00 Ratings
    Role-Based Security Model9.08 Ratings00 Ratings
    Multiple Access Permission Levels (Create, Read, Delete)9.48 Ratings00 Ratings
    Mobile Capabilities
    Comparison of Mobile Capabilities features of Clear Analytics and DbVisualizer
    Feature
    Clear Analytics
    8.6
    6 Ratings
    11% above category average
    DbVisualizer
    -
    Ratings
    Mobile Application8.54 Ratings00 Ratings
    Dashboard / Report / Visualization Interactivity on Mobile8.76 Ratings00 Ratings
    Database Development
    Comparison of Database Development features of Clear Analytics and DbVisualizer
    Feature
    Clear Analytics
    -
    Ratings
    DbVisualizer
    7.4
    49 Ratings
    14% below category average
    Performance optimization tools00 Ratings7.144 Ratings
    Schema maintenance00 Ratings7.846 Ratings
    Database Administration
    Comparison of Database Administration features of Clear Analytics and DbVisualizer
    Feature
    Clear Analytics
    -
    Ratings
    DbVisualizer
    7.2
    36 Ratings
    11% below category average
    User management00 Ratings7.533 Ratings
    Database security00 Ratings6.427 Ratings
    Database status reporting00 Ratings7.526 Ratings
    Best Alternatives
    Clear AnalyticsDbVisualizer
    Small Businesses
    Cyfe
    Score4 out of 10
    DBeaver
    Score8.6 out of 10
    Medium-sized Companies
    Qlik Cloud Analytics (Qlik Sense)
    Score8.1 out of 10
    DBeaver
    Score8.6 out of 10
    Enterprises
    Sisense
    Score6.9 out of 10
    DBeaver
    Score8.6 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Clear AnalyticsDbVisualizer
    Likelihood to Recommend
    9.0
    (8 ratings)
    8.7
    (60 ratings)
    Likelihood to Renew
    -
    (0 ratings)
    9.1
    (3 ratings)
    Usability
    9.1
    (8 ratings)
    8.2
    (30 ratings)
    Support Rating
    9.5
    (8 ratings)
    9.1
    (2 ratings)
    Implementation Rating
    -
    (0 ratings)
    8.4
    (2 ratings)
    User Testimonials
    Clear AnalyticsDbVisualizer
    Likelihood to Recommend
    Clear Analytics
    Clear Analytics has almost all the features which are mostly required by the organizations for their data analytics and transformation activities. Clear Analytics is built on the support of a parallel query engine which makes it handle large volume requests and also provides optimized results. However, every solution has some limitations, Clear Analytics lacks advanced features such as Predictive Analytics which is a very demanding feature in the market as most organizations are adopting AI/ML automation for their businesses. Also, it needs to add a lot of advanced visualizations so that the user has the choice of selection. Overall a good solution to be recommended.
    Incentivized
    Read full review
    DbVis Software AB
    Seamlessly querying PostgreSQL/PostGIS, Oracle, SQL Server, and SQLite from one interface without switching tools. The intelligent autocomplete and schema browsing make it ideal for writing queries and understanding unfamiliar databases. Complex performance tuning, deep monitoring, and automated backup/recovery require specialized DBA tools. Performance degrades with tens or hundreds of thousands of rows; command-line tools or ETL solutions are better suited to bulk data processing.
    Incentivized
    Read full review
    Pros
    Clear Analytics
    • Quick management of the data through Excel thanks to the tools Clear Analytics provides such as filtering different information for an easier view.
    • Ability to add new KPIs to measure different areas of our business.
    • Drag and drop tool which makes an easier usage of Excel.
    • Cost-effective. I find Clear Analytics to be affordable considering the number of features added and the unlimited sharing and editing it provides.
    Incentivized
    Read full review
    DbVis Software AB
    • Out-of-the-box support for many different databases.
    • Intuitive UI for interacting with data.
    • Flexibility of SQL Commander for writing scripts.
    • Great support for working with JSON data in recent updates.
    • Database connections over SSH.
    • Table relationship visualization is very helpful.
    • The tree view is well organized in how it splits out schemas.
    Read full review
    Cons
    Clear Analytics
    • For Charts and Graphs , getting the Power Point Deck would be helpful. As of now we use the data from Excel Reports
    Incentivized
    Read full review
    DbVis Software AB
    • Small, but noticeable: it would be nice to be able to highlight just one column of a data output for copy/paste by clicking on the column header (a feature some of us are accustomed to from SQL Server Management Studio)
    • Is there an ability to bulk import an excel file to a table in a connected SQL Server in DbVis? If so, I haven't figured that out yet. I still largely use Microsoft SSMS to import data to our team's personal SQL Server, but can easily query that server via DbVis)
    • (I really don't have any major complaints - our company has tried to steer users toward DBeaver for YEARS, which I cannot stand. DbVis knocks the beaver out of the water)
    Read full review
    Likelihood to Renew
    Clear Analytics
    No answers on this topic
    DbVis Software AB
    We never had problems with it. It is able to connect to all data sources (Oracle, Informix, DB2, SQL Server) that we currently use.
    Incentivized
    Read full review
    Usability
    Clear Analytics
    I have really enjoyed working with Clear Analytics. This platform has contributed to increased production and reliable data control processes. It has flexible user interface that can be operated by any organization member. Reports are shared on simple and transparent way in the dashboard for easy access. Data analytics from all departments have created manageable working environment that have increased production.
    Incentivized
    Read full review
    DbVis Software AB
    It does what we need it for, which is manipulate data, check connections, visualize database structures, check on user rights, or even just version checks on the used databases. The 'type to get to table name' feature is often irrational in behaviour, which leads to frustration. The start-up time could be much better, and the UI changes between versions are sometimes a hassle for us when buttons are suddenly moved or their appearance changes. We use a wide variety of DBVis versions on customer installations (which use the once-bought version), and differences in the look and feel between versions sometimes slow us down.
    Read full review
    Support Rating
    Clear Analytics
    I have had multiple scenarios where I had to reach out to the support team of Clear Analytics, be it access-related, general queries, during initial implementation, etc. My overall experience has always been good. I got the needed support every time without any delay. I can definitely recommend Clear Analytics simply on the basis of its excellent support team.
    Incentivized
    Read full review
    DbVis Software AB
    Never used
    Incentivized
    Read full review
    Alternatives Considered
    Clear Analytics
    There are other great tools that are out there but Clear Analytics is reasonable for our business and provides a lot of features that we specifically needed
    Incentivized
    Read full review
    DbVis Software AB
    [DbVisualizer] is pretty easy to use compared to IntelliJ because of it's simplicity. The performance is very good, it feels as good as a native application compared to the other two softwares I used for the same purpose. It's very cheaper compared to the other two tools and that's a big selling point.
    Incentivized
    Read full review
    Return on Investment
    Clear Analytics
    • Super useful to get started immediately
    • Didn't have to rely on migrating data
    • Easy to add members
    • Easy to learn and build charts
    Incentivized
    Read full review
    DbVis Software AB
    • Positive: Real time saver when working across multiple databases. At least 30-40 mins a day are saved
    • Positive: Helpful for the 'quick DBA' tasks without switching to the native tools: approx 1-2 hours saved weekly
    • Positive: Easy switch between environments / schemas / etc without hassle: saved at least an hour daily
    Read full review
    ScreenShots

    Clear Analytics Screenshots

    Screenshot of Clear Analytics integrated Excel panel essentially transforms standalone Excel into an enterprise strength, fully auditable, collaborative and centralized business intelligence platform.Screenshot of Users have the ability to dynamically query systems and render that data in any way they like.  No more waiting on IT to create reports.Screenshot of Your firms existing knowledge of Excel enables the firm to be product from day 1. Use the skills already present in your organization and don't pay for outside reporting consultants to create reports for you.Screenshot of Leverage the integration capability of Microsoft's Power BI to extend the reach of your data to web and mobile devices.Screenshot of Leverage all of Excels capabilities, from it's slicers to miniature spark-line charts to create incredibly informative and responsive dashboards.

    DbVisualizer Screenshots

    Product screenshotScreenshot of SQL formattingScreenshot of ERD diagramScreenshot of Auto completeScreenshot of Database connectionScreenshot of Database connection