Altova DatabaseSpy Tool Review
Rating: 8 out of 10
IncentivizedUse Cases and Deployment Scope
Altova DatabaseSpy is used in 2 ways. First, it is used to access Oracle and SQL Server Database for various ad-hoc queries, mostly developing and running ad-hoc SQL statements. Second, the graphical database design is used to view and edit database structures. The database queries are used for a wide range of reasons, from interrogating the database for specific data elements to reporting general or specific data points to [query] specific tables. The graphical DB design editor is used to view and edit the various database structures through one UI.
Pros
- SQL templates
- SQL query results window
- Design editor shows graphic representation of DB structures
- Good performance
Cons
- Improved SQL query debugging capabilities
- Ability to nest queries
- Does not integrate with other DB administration tools or query tools
Likelihood to Recommend
Altova DatabaseSpy is well suited for dynamic environments that move quickly and have a need to develop and run small to medium-size ad-hoc queries quickly and easily. The tool is intuitive and relatively easy to learn and come up to speed. The tool may not be best suited for large and very large, and complex queries.
JM
John Mihaila
Software Manager in Information Technology at Santa Clara (Government Administration, 10,001+ employees)
Vetted Review
2 years of experience