Idera DBArtisan

Idera DBArtisan boxshot.

Idera DBArtisan

Published By:  Embarcadero

Database administration tool - write, profile and debug SQL, monitor performance, perform backup and recovery tasks, and more

Product Variants

Other product variants may be available, please contact us or request a call back if you cannot see what you are looking for.


DBArtisan provides comprehensive management of multiple database platforms including SQL Server, MySQL, Oracle, Sybase and DB2. DBArtisan provides database security management, SQL editing with support for performance execution analysis, SQL profiling (Oracle only) and debugging, a visual query builder, performance and storage management and more. The intuitive graphical editors and wizards help to improve productivity and provide a common interface to multiple tasks.

Available in a range of editions to suit your requirements and budget, DBArtisan can significantly improve your productivity and management capabilities.

Key benefits

  • Manage multiple platforms (Oracle, SQL Server, DB2, Sybase) all from one UI
  • Proactively manage space, data and performance using built-in analytics
  • Easily identify and fix performance issues using intelligent diagnostics
  • Move schema and table data across different platforms easily
  • Protect data security with view, grant and revoke of permissions

Database Management

Multi-Platform Administration

Proactively manage major DBMSs (Oracle, SQL Server, DB2 and Sybase) 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.

Proactive Diagnostics

View detailed metrics and identify performance, capacity planning, and storage management issues before they become major problems.

Performance Analyst

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.

Process Monitor

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.

Job Management

Integrates with Microsoft Windows Task Scheduler.

Schema Management

Object Management

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

Cross-Platform Schema Knowledge

Translate DBA skills across multiple platforms by leveraging full knowledge of the underlying DBMS system catalog, syntax, and alteration rules.

SQL and Data Management

Query Builder

Construct even the most complicated SQL statements with point and click ease.

ISQL Facility

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 statement execution.

Visual Data Editor

Add, change, and delete data from database tables with all referential integrity being enforced.

Data Migration

Migrate schema objects and associated table data using wizard-driven utilities.

Debugging and performance optimisation

SQL Debugger

Debugs programmable objects such as stored procedures, functions, packages and triggers.

SQL Profiler

Captures metrics of various PL/SQL programmable objects on Oracle 8.1.5 and higher.

Execution Plan

Graphical and user-customizable display of a database’s internal processing order and priorities for queries. Provides built-in explain and performance execution analysis.

Security Management,/p>

User Management

Manage users, logins, profiles, groups, aliases, and password security.

Role Management

Grant and revoke roles to users and to other roles, as well as system- and object-level privileges.

Permissions Management

Users, roles, and permissions modeling at the logical and physical level.

Data Classification

Categorise and label data and objects according the level of security and privacy that should be applied to that information.

Account Migration

Migrates accounts between the same or different database platforms.

Enterprise Management

Troubleshooting Assistance

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 Integration

LDAP environments are supported.

JDBC/ODBC and Unicode Support

Connect to those platforms with JDBC/ODBC drivers available. Full Unicode character support throughout the application.

Shopping Basket
    0 Item(s)

    View and amend your basket
    ISV Royalty Licensing