ALTOVI
Use Cases and Deployment Scope
test
Pros
- test
Cons
- test
Return on Investment
- test
Usability
Other Software Used
Google AdMob
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
Altova DatabaseSpy Tool Review
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
Altova DatabaseSpy Review
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.
Pros
- High performing system regardless of how many DBs are integrated
- Graphical DB design editor is useful for bird's eye view of the DB structure of the whole infrastructure
- Single point of reference / administration
Cons
- Since it is a DB administration tool, it works by itself. If you have existing system like this you might encounter some obstacle when integrating.
Most Important Features
- Graphical DB editor
- Centralized administration of DBs
Return on Investment
- No need to hire additional DB admins since this can be learned and administered by existing admins.
Alternatives Considered
mRemoteNG
Other Software Used
mRemoteNG, McAfee ePolicy Orchestrator, McAfee MOVE AntiVirus