Altova DatabaseSpy

Score9.1 out of 10

2 Reviews and Ratings

What is Altova DatabaseSpy?

Altova DatabaseSpy is a multi-database query, design, and conversion tool. It connects to all major databases, and aims to ease SQL editing and other tasks more affordably than single-database solutions. Features like chart generation, table browsing, data editing, SQL auto-completion, visual table design, database conversion, and more are combined to liberate data management.

Categories & Use Cases

Configuration Management Databases

John Mihaila

Software Manager in Information Technology at Santa Clara (10,001+ employees employees)

Use 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

Most Important Features

Smaller footprint
Easy to learn and easy to master
Can access multiple types of databases

Return on Investment

Enabled us to continue to provide excellent customer support with a smaller team
Lower cost helped us balance our budget
Reduced the need for spending extra funds on training

Alternatives Considered

Toad for Oracle

Other Software Used

Oracle SQL Developer, DbVisualizer

Verified User

Engineer in Information Technology (201-500 employees employees)

Use Cases and Deployment Scope

To have a single point of centralized management for our databases. With Altova DatabaseSpy, DB admins will have the ability to run scripts and queries in a at least 2 steps only thus increasing productivity.

Due to the need of daily reporting, this is done so easily on the UI with the use of scripts per each databases. We used the graphical design editor for reporting as well.