DBArtisan Features

Listed product, feature, and database platform support varies based on product edition. For details, please visit the Product Editions page.

General Features
Multi-platform Support Supports all major DBMSs from a single interface. Ability to use the tools on all supported platforms from a single license.
Embarcadero® AppWave™ Enables centralized license management and tool deployment
Unicode Support Full Unicode character support throughout the application
Intuitive Interface Streamlines and automates common and repetitive tasks with an easy-to-use GUI and powerful wizards
JDBC/ODBC Support Supports connecting to those platforms with JDBC/ODBC drivers available
LDAP Integration Supports LDAP environments
Job Management Integrates with Microsoft Windows Task Scheduler
Schema, Data and Performance Management
Object Management Creates, drops, or alters a wide variety of database objects
Graphical Object Editors Moves effortlessly among disparate database schemas using standardized, multi-tabbed editors for each database object type
Cross-platform Schema Knowledge Translates DBA skills across multiple platforms by leveraging full knowledge of the underlying DBMS system catalog, syntax, and alteration rules
Visual Data Editor Adds, changes, and deletes data from database tables with all referential integrity being enforced
Data Migration Migrates schema objects and associated table data using wizard-driven utilities
Proactive Diagnostics Provides detailed metrics and identifies performance, capacity planning, and storage management issues before they become major problems
Process Monitor Monitors who is connected to each database along with each session's current activity and other session-related data
SQL Management
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.
SQL Analysis Provides built-in explain and performance execution analysis
Query Builder Constructs even the most complicated SQL statements with point-and-click ease
Security Management
User Management Manages users, logins, profiles, groups, aliases, and password security
Role Management Grants and revokes roles to users and to other roles, as well as system- and object-level privileges
Account Migration Migrates accounts between the same or different database platforms
Data Classification Categorizes and labels data and objects according the level of security and privacy that should be applied to that information
Permission Management Enables users, roles, and permissions modeling at the logical and physical level
DBArtisan Advanced Features
SQL Profiler Captures metrics of various PL/SQL programmable objects on Oracle 8.1.5 and higher. Available for Oracle only
SQL Debugger Debugs programmable objects such as stored procedures, functions, packages, and triggers. Available for Oracle, DB2 for LUW, Sybase, and SQL Server
Analyst Pack
Space Analyst Provides analysis of database space information to pinpoint space-related exceptions and provides assistance in diagnosing and reorganizing storage inefficiencies using an intelligent reorganization wizard
Performance Analyst Provides intelligent analysis of real-time database and OS performance diagnostic information to troubleshoot and remedy performance problems
Capacity Analyst Collects and stores key database metadata and performance metrics and performs trend analysis to forecast database growth and usage.
Data Governance*
Inline Metadata Gives users real-time metadata visibility in the SQL IDE and will gain valuable context in SQL query development with awareness of sensitive data. Examples of metadata attributes are: table descriptions, PII, data governance policy information, etc.
Centralized Datasource Repository Provides the functionality for users to work from a common, centralized datasource repository

* Data Governance features require CONNECT and ER/Studio