Menu
Multiple-platform Database Administration
Multi-platform Database Administration
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
Why DBArtisan
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 teams across the organisation. Manage multiple Oracle-specific schema object types and SQL Server advanced object properties such as temporal tables, in-memory tables, and natively compiled triggers, procedures and functions.
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
View execution plans using a graphical and user-customizable display of the database’s internal processing order and priorities for queries. 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.
Manage Multiple Database Platforms
DBAs often must support multiple databases such as Oracle, SQL Server, DB2, and Sybase, just to name a few. Having a single consistent interface and tool like DBArtisan can greatly increase DBA productivity and job satisfaction. Simple DBA object management tasks such as creating, altering, copying and dropping database objects, may be easy, but often the repetition can reduce productivity. DBArtisan offers contextually intelligent screens and wizards to automate these repetitively mundane tasks.
Space, Data and Performance Management
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 and 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.
Create Complex Queries Quickly
While SQL may not be an overly complex language, its many options and alternatives can require a lot of effort. DBArtisan offers an easier and more efficient way to rapidly create complex SQL with a user-friendly graphical interface, permitting users to concentrate on what they want to do rather than SQL syntactical intricacies such as outer joins, sub-selects and many other constructs.
View Database Performance Dashboard
