Schema Management
DBArtisan Workbench provides unparalleled database object management capabilities. Its database platform- and version-specific graphical object editors and wizards allow you to create, drop or alter a wide variety of database objects, including tables, constraints, indexes, views, users, procedures, functions, triggers, groups, roles, profiles, and packages.
DBArtisan Workbench includes standardized, multi-tabbed, graphical object editors, for each database object type, which allow you to move effortlessly from managing a SQL Server or Sybase schema to managing an Oracle schema and vice-versa. The product contains full knowledge of the underlying DBMS system catalog, syntax, and alteration rules. In terms of documenting your schemas, wizard-driven report facilities can help you create frame-based web sites that contain one object or an entire database’s definition.
Security Management
DBArtisan Workbench can help you efficiently establish and maintain database security. Whether you're managing an existing production database or setting up a new one, you'll find powerful functionality to:
- Manage users, roles, logins, profiles, groups, and aliases
- Migrate accounts between the same or different database platforms
- Manage password security
- Grant and revoke roles to users and to other roles, as well as system and object-level privileges
- Set privileges for multiple users in a single operation
- Administer Microsoft SQL Server and Sybase remote servers
Space Management
Managing space is vital to ensuring the availability and performance of your databases. DBArtisan Workbench incorporates many built-in space features that enable you to smartly manage and exploit all aspects of your database’s storage.
For advanced space analysis, DBArtisan Workbench includes Embarcadero Space Analyst. The Space Analyst is a sophisticated diagnostics product that helps you pinpoint all space-related problems in your database. It also includes an intelligent reorganization wizard that can reorganize all or selected parts of your database.
SQL Management
DBArtisan Workbench offers powerful visual tools for creating and analyzing complex SQL statements and server-side code objects such as stored procedures, triggers, etc. Using the Query Builder, you can construct even the most complicated SQL statements with point-and-click ease. As you select the objects and methods to use for SQL statements, DBArtisan Workbench automatically generates the code. The built-in syntax checking facility ensures that all SQL statements are built and run correctly the first time. DBArtisan Workbench's feature-rich ISQL facility allows you to create, save, and execute all SQL code against your databases with ease. Built-in hotkeys and code completion features help you code SQL as quickly as possible.
To analyze and debug your code, DBArtisan Workbench provides built-in explain and performance execution analysis as well as cross-platform code debuggers that you can use to troubleshoot server-side code objects. For unattended Oracle SQL capture and execution analysis, DBArtisan Workbench includes the SQL Profiler component. Finally, to tune inefficient SQL code, DBArtisan Workbench integrates with Embarcadero SQL Tuner, allowing you to automatically rewrite poorly performing code into fully optimized SQL.
Job Management
Tasks, like large reorganizations or critical database alteration scripts, often need to run during off-hours. DBArtisan Workbench offers two different ways to help you get a handle on job management:
DBArtisan Workbench freely integrates with the Microsoft Windows Task Scheduler, which allows you to schedule virtually any task to run on your own computer whenever and how often you’d like.
For those wishing more robust job management capabilities, DBArtisan Workbench integrates fully with the Embarcadero Job Scheduler. From your DBArtisan desktop, you can build and schedule any command line or SQL job to run on any Windows, UNIX, or Linux machine in your job scheduler network. Within DBArtisan, you can deploy a SQL job to run on any machine in your environment. If you use UNIX or Linux, imagine no more CRON files. You also have full control over every job you create and can stop, start, and analyze the output of any job you choose.
Data Management
DBArtisan Workbench provides comprehensive facilities to help you manage the data in all your databases. A visual data editor helps you add, change, and delete data from your database tables with all referential integrity being enforced. You can create insert statements for tables using current data and also extract data as XML documents for certain databases.
DBArtisan Workbench also offers wizard-driven utilities for migrating schema objects and associated table data from one database server to another. You can copy a single database object, all objects owned by a specific schema user, or an entire database. Alternatively, you can define a custom migration job that will migrate any group of database objects. DBArtisan Workbench can also perform combinations of cross-DBMS platform migration for common database objects, such as tables, data, users, indexes and views.
Performance Management
As a busy DBA, you can’t waste time trying to figure out critical performance bottlenecks in your database. Instead, you need tools that take all the guesswork out of performance management and help you make things right again. DBArtisan Workbench offers a number of different options to help you manage the performance of your key databases.
DBArtisan Workbench ships with a built-in process monitor that helps you understand who is connected to your database along with each session’s current activity. Locking details and other session-related data is also provided.
For those wishing more robust performance details, the DBArtisan Workbench includes Embarcadero Performance Analyst, a powerful client-side database monitor that runs fully contained inside the DBArtisan Workbench console. Embarcadero Performance Analyst provides intelligent diagnostic information and strong drill down details to help you get to the heart of any episode of performance degradation. Embarcadero Performance Analyst integrates completely with DBArtisan Workbench so you can fix any found performance problems with a few mouse clicks.
If you need 24 x 7 unattended coverage of your critical databases, then you will want to look into the Embarcadero Performance Center. Performance Center is a separate enterprise-wide performance solution that can notify you around-the-clock of any performance problem requiring your attention and integrates fully with DBArtisan Workbench to help you fix identified performance bottlenecks.
Capacity Management
Planning for the future of your critical databases used to be a difficult task. However, the DBArtisan Workbench Capacity Analyst tool makes it easy to understand where your databases are today and where they are heading in the future. Embarcadero Capacity Analyst lets you track key database metadata and performance metrics over time so you can perform trend analysis on key areas like database growth, object fragmentation, database I/O, and session load. Smart forecasting mechanisms built intoEmbarcadero Capacity Analyst allow you to predict when your databases will run out of space or when an object will need to be reorganized.
Non-invasive Installation
Unlike other DBA tools that require many objects be installed on every managed server, DBArtisan Workbench only installs a few objects needed for Embarcadero Performance Analyst and Embarcadero Capacity Analyst. These objects are used to monitor or to collect, retain, and analyze historical database information.
DBArtisan comes in three editions so you can easily choose the database administration solution that fits your needs and environment:
DBArtisan
Provides standard cross-platform database administration facilities for a specified number of databases.
DBArtisan Professional
Provides cross-platform database administration facilities for an unlimited number of databases and includes the Embarcadero SQL Debugger and SQL Profiler for troubleshooting SQL code.
DBArtisan Workbench
The ultimate database administration solution! Provides cross-platform database administration facilities for an unlimited number of databases, includes the Embarcadero SQL Debugger and SQL Profiler for troubleshooting SQL code, and also contains the Embarcadero Analyst components for advanced storage and performance management.