Space, Data and Performance Management at Your Fingertips
DBArtisan provides comprehensive facilities to help you manage space, data and performance to help keep your database optimized and running. DBArtisan helps manage the performance of your databases with a built-in process monitor that helps administrators understand who is connected to your database along with each user's current activity and session-related data.
Manage Security Easily, Efficiently
Establish and maintain database security whether you are managing an existing production database or setting up a new environment. You'll find consistent support across all of the supported platforms as DBArtisan lets you view, grant, and revoke permissions or privileges. When you open a security-related object, such as user or role, the Permissions tab lets you assign permissions on an object-by-object basis.
Seamless Schema and Data Migrations
Advanced data management tools help to move schema and corresponding table data across the same or different platforms. The Migration Wizard guides administrators through a multi-step process that lets you select source and target data sources, select object types and specific objects to be migrated, specify a flexible set of migration options, and view progress of the operation.
The Analyst Series Give DBAs Greater Insight
For advanced space, capacity, and performance analysis and management, DBArtisan's optional Space, Capacity, and Performance Analyst components contain sophisticated diagnostics to help you pinpoint problems in your database. The series facilitates troubleshooting bottlenecks and performance inefficiencies that result in poor space management, tracking key database metadata and performance metrics over time, and provides intelligent diagnostic information with strong drilldown details.
Ensure Organizational Data Governance with Database Performance, Uptime, and Availability
Improve database performance, uptime and availability with DBArtisan's analytical and management capabilities. DBAs can utilize DBArtisan's Analyst Series for detailed analysis of database space, capacity, and performance. Functionality exists to create and modify database objects with DBArtisan's Schema and Object Wizards and Editors to improve database performance. Also, manage database security and permissions in your organization within the DBArtisan console.
| 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. |
System Requirements
Minimum hardware requirements:
- Pentium 4-level processor
- 1 GB of Memory
- 1 GB of free disk space
- 1024 x 768 display
DBArtisan supports the following operating systems:
- Windows XP SP2 (32-bit and 64-bit)
- Windows Vista (32-bit and 64-bit)
- Windows 7 (32-bit and 64-bit)
DBArtisan Product Editions
DBArtisan is available in three editions – Standard, Professional, and Workbench editions, all of which have platform-specific and XE versions.
Standard Edition – Designed for Database Developers or Project DBAs in need of capabilities to monitor and manage database processes and to set up database work environments.
Professional Edition – Designed for Production or Operational DBAs for robust management of their database environments.
Workbench Edition – Designed for Production or Operational DBAs for robust management of their database environments and analytical capabilities for greater insight into their environment.
| DBArtisan Standard | DBArtisan Professional | DBArtisan Workbench | DBArtisan XE |
| Designed for |
Database Developer / Project DBA |
Production or Operational DBAs |
Production or Operational DBAs |
Production/Operational DBAs working with multiple platforms |
| Latest Version |
9.2 |
9.2 |
9.2 |
XE3.5 |
| Previous Version |
March 2013 |
March 2013 |
March 2013 |
March 2013 |
| Schema/SQL/Data Management |
|
|
|
|
| Performance Management |
|
|
|
|
| Security Management |
|
|
|
|
| Security Design and Assessment |
|
|
|
|
| SQL Debugger/Profiler |
|
|
|
|
| Analyst Packs |
|
|
|
Optional |
| AppWave Licensing |
|
|
|
|
| Connect to all database platforms |
|
|
|
|
| Datasource Connections |
Limited |
Unlimited |
Unlimited |
Unlimited |
Platform-specific Versions – These products support one major platform. DBArtisan for Oracle, DBArtisan for SQL Server, DBArtisan for Sybase, and DBArtisan for DB2 are available.
XE Version – Grants the license holder the ability to connect to multiple supported database platforms within the same User Interface, with no need to purchase additional platform-specific software. These users can connect to Oracle, SQL Server, Sybase, and DB2 (LUW & z/OS) platforms simultaneously.
|