DbVisualizer vs. Enthought Canopy

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
DbVisualizer
Score 8.8 out of 10
N/A
DbVisualizer is a multi-database tool for developers, analysts and database administrators, providing a single interface across a wide variety of operating systems. Boasting an easy-to-use and clean interface, DbVisualizer runs on all major operating systems and supports all major RDBMS that are available. Users only need to learn and master one application. DbVisualizer integrates transparently with the operating system being used.
$0
Enthought Canopy
Score 7.0 out of 10
N/A
Austin based Enthought offers their flagship scientific Python distribution, Canopy. The Canopy Geoscience (or Canopy Geo) variant of the product is a data analysis, exploration and visualization package optimized for geologists & geophysicists, and researchers in petroleum science.N/A
Pricing
DbVisualizerEnthought Canopy
Editions & Modules
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
No answers on this topic
Offerings
Pricing Offerings
DbVisualizerEnthought Canopy
Free Trial
YesNo
Free/Freemium Version
YesNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeOptionalNo setup fee
Additional DetailsNew 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
DbVisualizerEnthought Canopy
Features
DbVisualizerEnthought Canopy
Database Development
Comparison of Database Development features of Product A and Product B
DbVisualizer
7.8
40 Ratings
9% below category average
Enthought Canopy
-
Ratings
Performance optimization tools7.735 Ratings00 Ratings
Schema maintenance7.938 Ratings00 Ratings
Database Administration
Comparison of Database Administration features of Product A and Product B
DbVisualizer
7.3
28 Ratings
14% below category average
Enthought Canopy
-
Ratings
User management7.725 Ratings00 Ratings
Database security7.322 Ratings00 Ratings
Database status reporting6.721 Ratings00 Ratings
Best Alternatives
DbVisualizerEnthought Canopy
Small Businesses
DBeaver
DBeaver
Score 9.2 out of 10
PyCharm
PyCharm
Score 9.2 out of 10
Medium-sized Companies
DBeaver
DBeaver
Score 9.2 out of 10
PyCharm
PyCharm
Score 9.2 out of 10
Enterprises
DBeaver
DBeaver
Score 9.2 out of 10
PyCharm
PyCharm
Score 9.2 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
DbVisualizerEnthought Canopy
Likelihood to Recommend
8.8
(47 ratings)
6.0
(2 ratings)
Likelihood to Renew
9.1
(2 ratings)
-
(0 ratings)
Usability
8.2
(17 ratings)
-
(0 ratings)
Support Rating
9.1
(1 ratings)
-
(0 ratings)
Implementation Rating
9.1
(1 ratings)
-
(0 ratings)
User Testimonials
DbVisualizerEnthought Canopy
Likelihood to Recommend
DbVis Software AB
Whenever you have to access data sources from more than one database engine provider, you should consider using DbVisualizer for the task. Switching between multiples IDE consumes time and resources (memory), and you also need to learn menus, shortcuts, etc., for each IDE, while using DbVisualizer allows you to work consistently no matter which database engine you are connecting. You can use it to simply navigate through data structures, write SQL sentences or even create new tables and views, develop stored procedures, etc.
Read full review
Enthought
Enthought Canopy is best suites for scripting data analytical concepts. It has a wide range of data analytical libraries and also is good for data visualization. I would not recommend using Enthought Canopy only as an IDE, there may be better options available. If you're looking for a good data simulation & visualization package, Canopy it is.
Read full review
Pros
DbVis Software AB
  • Timed queries that add their result to the result grid for every execution are helpful. Creation of graphs also extremely helpful.
  • Query history and auto-recover feature makes sure we don't lose our queries.
  • Actions like exporting grids to Excel or other tools is a very easy task.
Read full review
Enthought
  • Providing scientific libraries, both open source and Enthought's own libraries which are excellent.
  • Training. They provide several courses in python for general use and for data analysis.
  • Debugging tools. Several IDEs provides tools for debugging, but I think they are insufficient or too general. Canopy has a special debugging tool, specially design for python.
Read full review
Cons
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
Enthought
  • Canopy does not support Python 3
  • There were times the Python shell crashed, and I would have to restart it
  • Some Python libraries are slow.
Read full review
Likelihood to Renew
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.
Read full review
Enthought
No answers on this topic
Usability
DbVis Software AB
I find it very user-friendly, everything is easily viewable and the fact that I can move modules around and customize the colors and appearance of things really helps make it more usable. I also find the default keyboard shortcuts intuitive and the in-program descriptions are easy to follow and understand.
Read full review
Enthought
No answers on this topic
Support Rating
DbVis Software AB
Never used
Read full review
Enthought
No answers on this topic
Alternatives Considered
DbVis Software AB
DbVisualizer provides a good value when compared against other 3rd party products with similar features as well as products with similar functionality made by the database vendors. The user interface is good and user friendly / intuitive and easy to learn. It doesn't take too long for an experienced DBA / database developer to come up to speed.
Read full review
Enthought
Before Canopy with its python we were working with Matlab. We decided for Canopy against Matlab for two reasons: First, we believe that python together with NumPy or SciPy can achieve the objectives with less code and therefore less training, and second the prizes are much lower than matlab which is most robust, expensive and less intuitive. It's clear we are making the comparison with python and it has nothing to with canopy. But with Canopy you feel you have all those tools close together without the problem of configuration, besides a lot of personalized libraries that complements a typical python environment.
Read full review
Return on Investment
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
Enthought
  • Its easier to define KPI's with Enthought
  • It is good for reiteration and building on top of existing scripts
  • Its dedicated Python console makes it easier to execute projects.
Read full review
ScreenShots

DbVisualizer Screenshots

Screenshot of Screenshot of SQL formattingScreenshot of ERD diagramScreenshot of Auto completeScreenshot of Database connectionScreenshot of Database connection