DBArtisan

Multiple Platform Management: Manage multiple platforms from one UI. Proactively manage all major relational database platforms (Microsoft SQL Server, Microsoft Azure SQL Database, Oracle Database, IBM Db2 LUW and z/OS, SAP Sybase ASE and IQ, MySQL, PostgreSQL, Pivotal Greenplum, Amazon Redshift, and Snowflake) from a single common graphical user interface. Reduce training requirements and streamline collaboration among different teams across the organization. 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.

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.

Protect Data Security: Ensure data security with sophisticated permissions management including view, grant and revoke. Create and manage permissions across multiple servers and/or objects at once. Gain valuable insights into how permissions are granted throughout the enterprise to better comply with internal or external security regulations and compliance requirements.

Automated Alerts and Event Responses: Monitor your database servers, and databases for availability, performance issues or other key events by setting up alerts to automatically notify you. Configure alerts to execute commands upon occurrence of monitored events that can proactively resolve emerging problems, send email notifications to specified recipients, log events into tables, and send SNMP Traps to network management consoles. Reduce downtime, improve response time, and mitigate risk by automating responses to key events. DBArtisan features an easy to use GUI, with no scripting required.

Define and Enforce Standards: Ensure team efficiency and compliance by defining and enforcing standards across all database platforms. Define standard tasks for execution, customize toolbars, limit object visibility based on user role, and manage which features a given user is allowed to access.

Generate Visually Appealing Reports: Generate visually appealing reports of database objects and data. Use templates to easily create and reuse comprehensive reports containing key details about database objects and data with consistent branding and layout. Reduce report generation from hours to minutes by scheduling report creation and distribution.