RAD Studio 11 is now available! Learn more

Discover The Getit Page

Deep discounts available on InterBase 2020 for OEM or VARs – Contact sales

Renew your Update Subscription license now Read more

DBArtisan 2016 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
Performance Management (Optional)
Performance IQ Add On Reduces performance troubleshooting efforts by providing embedded intelligence & insights to help investigate, identify & resolve performance issues.
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.
DB Team Server Collaboration
Centralized Data Source Management Simplifies access an improve management. Share data sources across DBA teams and gain insights with powerful search capabilities.
Monitoring And Alert Notifications Improve responsiveness and reduce downtime with centralized basic health monitoring and alert teams on availability, performance and storage.
Team Collaboration Streamline communication and knowledge sharing with team members. With access to data source repositories, health metrics and DB Password Locker. Capture knowledge and leverage best practices from others.
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 ER/Studio Enterprise Team Edition.

The World’s Leading Companies Rely on Software Built With Embarcadero Products