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.