Enthought Canopy (discontinued) vs. SQL Server Management Studio (SSMS)

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.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

The tool is excellent for managing virtually all aspects of SQL Server - multiple servers, databases, hundreds of tables and procedures, dozens of SQL Agent jobs. We have not encountered any situations where it is not appropriate.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• 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.

• Database queries
• Database management
• Table design

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• 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.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Sorting of executed queries not available
• Quality of life improvements on folders and managment
• Some outdated tools that need revamping

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

It's very user friendly. If you know T-SQL then you can use this. Really even if you don't it's not that hard to figure out. You can create things visually as well.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

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.

SSMS is very efficient and aids to do multiple tabs easily

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• 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.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• SQL Server Management Studio is our go-to tool for almost everything we do with SQL Server. Highly efficient and flexible.
• Compared to other alternatives, I would say we save at least 25% of the overall time we need to spend working in SQL Server.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info