Embarcadero DBArtisan XE4

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 licence.
• Embarcadero AppWave - enables centralised 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 standardised, 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 - categorises 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 (optional)

• Space analyst - provides analysis of database space information to pinpoint space-related exceptions and provides assistance in diagnosing and reorganising storage inefficiencies using an intelligent reorganisation 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.