Proactively manage major relational database platforms (Microsoft SQL Server, Microsoft Azure SQL Database, Oracle Database, IBM Db2 LUW and z/OS, SAP Sybase ASE and IQ, MySQL, PostgreSQL, Pivotal Greenplum, Amazon Redshift, and Snowflake) from a single common interface. Use the tool on all supported platforms from a single license. Streamline and automate common and repetitive tasks with an easy-to use GUI and powerful wizards.
View detailed metrics and identify performance, capacity planning, and storage management issues before they become
Provides intelligent analysis of real-time database and OS performance diagnostic information to troubleshoot and
remedy performance problems.
Server Storage List
View aggregate details of databases installed in a SQL Server instance, including File Groups, Data Files, Log
Files, for better visibility and summary of database storage usage.
Space & Capacity Planning
See analysis of database space information to pinpoint space-related exceptions. Get assistance in diagnosing and
reorganizing storage inefficiencies using an intelligent reorganization wizard. Collect and store key database
metadata and performance metrics and perform trend analysis to forecast database growth and usage.
Monitor who is connected to each database along with each session's current activity and other session-related data.
Monitoring & Alert Notifications
Improve responsiveness and reduce downtime with centralized basic health monitoring and alert teams on availability,
performance and storage.
Integrates with Microsoft Windows Task Scheduler.
Create, drop, or alter a wide variety of database objects, including Oracle-specific schema object types and SQL
Server advanced object properties.
Graphical Object Editors
Move effortlessly among disparate database schemas using standardized, multi-tabbed editors for each database object
Cross-Platform Schema Knowledge
Translate DBA skills across multiple platforms by leveraging full knowledge of the underlying DBMS system catalog,
syntax, and alteration rules.
Construct even the most complicated SQL statements with point and click ease.
Allows users to create, save, and execute all SQL code against databases with ease. SQL editor offers on the fly
syntax checking for code and object names, object lookup and code complete, bind variable support, selective
Visual Data Editor
Add, change, and delete data from database tables with all referential integrity being enforced.
Migrate schema objects and associated table data using wizard-driven utilities.
Debugs programmable objects such as stored procedures, functions, packages and triggers.
Captures metrics of various PL/SQL programmable objects on Oracle 8.1.5 and higher.
Graphical and user-customizable display of a database’s internal processing order and priorities for queries.
Provides built-in explain and performance execution analysis.
Manage users, logins, profiles, groups, aliases, and password security.
Grant and revoke roles to users and to other roles, as well as system- and object-level privileges.
Users, roles, and permissions modeling at the logical and physical level.
Categorize and label data and objects according the level of security and privacy that should be applied to that
Migrates accounts between the same or different database platforms.
Use the automated IDERA Error Report feature to create a zip file containing important details
about your Oracle or SQL Server installation, such as product information, hardware metrics, and necessary database
information for troubleshooting.
LDAP environments are supported.
JDBC/ODBC and Unicode Support
Connect to those platforms with JDBC/ODBC drivers available. Full Unicode character support throughout the
Starts at $4,459.00 $3,567.00 per user (workstation)
Save at least 20% on all online purchases. Volume discounts available. Add to Cart Request a Quote
Live Product Demo
See DBArtisan Database Administration Solution in action with a seasoned pro.