- Manage multiple platforms (Oracle, SQL Server, DB2, Sybase) from one UI
- Proactively manage space, data and performance with built-in analytics
- Easily find and fix performance issues using intelligent diagnostics
- Move schema and table data across different platforms with ease
- Protect data security with view, grant and revoke of permissions
Manage Multiple Platforms with One Interface
Proactively manage all major DBMSs (Oracle, SQL Server, DB2 and Sybase) from a single common interface. Reduce training requirements and streamline collaboration among different database teams across the organization.
Manage Space, Data and Performance Analytics
Comprehensive tools help you manage space, data and performance to keep your databases optimized and available. Manage the performance of your databases with a built-in process monitor that helps you understand who is connected to your database along with each user's current activity and session-related data. Sophisticated diagnostics help you pinpoint performance inefficiencies that result in poor space management, tracking key database metadata and performance metrics over time.
Identify and Resolve Performance Issues
Probe into the performance of SQL statements by providing visibility and insight as to how syntax, cardinality, index usage and data skew affect and vary performance over time in a variety of situations.
Simplify 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.
Manage Database Security Access and Permissions
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.
Proactively manage all major DBMSs (Oracle, SQL Server, DB2 and Sybase) from a single common interface. Ability to use the tools on all supported platforms from a single license. Streamline and automate common and repetitive tasks with an easy-to use GUI and powerful wizards.
See intelligent analysis of real-time database and OS performance diagnostic information to troubleshoot and remedy performance problems. Plus get built-in explain plan and performance execution analysis.
View detailed metrics and identify performance, capacity planning, and storage management issues before they become major problems.
Space & Capacity Planning
See analysis of database space information to pinpoint space-related exceptions. Get assistance in diagnosing and reorganizing storage inefficiencies using an intelligent reorganization wizard. Collect and store key database metadata and performance metrics and perform trend analysis to forecast database growth and usage.
Monitor who is connected to each database along with each session's current activity and other session-related data.
Monitoring & Alert Notifications
Improve responsiveness and reduce downtime with centralized basic health monitoring and alert teams on availability, performance and storage.
Integrate with Microsoft Windows Task Scheduler.
Create, drop, or alter a wide variety of database objects.
Graphical Object Editors
Move effortlessly among disparate database schemas using standardized, multi-tabbed editors for each database object type.
Cross-Platform Schema Knowledge
Translate DBA skills across multiple platforms by leveraging full knowledge of the underlying DBMS system catalog, syntax, and alteration rules.
SQL & Data Management
Construct even the most complicated SQL statements with point and click ease.
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.
Visual Data Editor
Add, change, and delete data from database tables with all referential integrity being enforced.
Migrate schema objects and associated table data using wizard-driven utilities.
Manage users, logins, profiles, groups, aliases, and password security.
Grant and revoke roles to users and to other roles, as well as system- and object-level privileges.
Users, roles, and permissions modeling at the logical and physical level.
Categorize and label data and objects according the level of security and privacy that should be applied to that information.
Captures metrics of various PL/SQL programmable objects on Oracle 8.1.5 and higher (Oracle only).
Debug programmable objects such as stored procedures, functions, packages and triggers.
Centralized Data Source Repository
Simplify access and improve data source management. Designate Team Server as the data source catalog, and login to your data sources with Team Server credentials.
LDAP environments are supported.
JDBC/ODBC and Unicode Support
Connect to those platforms with JDBC/ODBC drivers available. Full Unicode character support throughout the application.