TrustRadius: an HG Insights company

DBArtisan

Score8 out of 10

6 Reviews and Ratings

Get a Demo

What is DBArtisan?

DBArtisan from Embarcadero Technologies (acquired by Idera) is a database administration toolset.

Categories & Use Cases

Key Features

Learn about the best (and worst!) features DBArtisan has to offer, as determined by TrustRadius' reviewers.
Based on 6 ratings of DBArtisan's features
View all features

Top Performing Features

  • Schema maintenance

    Maintaining schema integrity via regular maintenance

    Category average: 8.6

  • Test data generation

    Generation of randomized or real-world test data

    Category average: 6.8

  • Version control tools

    Version control tools ensure code integrity is maintained in a team coding environment

    Category average: 7.9

Areas for Improvement

  • Database status reporting

    Detailed reports on database performance, configuration, security, vulnerabilities, etc.

    Category average: 8.2

  • Change management

    Automated scripts for implementing database changes

    Category average: 7.8

  • User management

    Tools to help manage user and role administration

    Category average: 8.4

Reviews

What users are saying about DBArtisan.
View all reviews

DBArtisan may be pricey, but its worth it

Incentivized
Zhann GoloborodkoView profile
Senior Programmer/Analyst in Information Technology at Investment Company Institute (51-200 employees employees)

Pros

  • IDE
  • DB Management

Cons

  • Locks up far too often
  • Licensing structure is expensive

Return on Investment

  • While it is expensive, it saves us a great deal of time in getting a lot of DB work done.
  • The front end is reasonably powerful and significantly more polished than any of the free alternatives

Alternatives Considered

Oracle SQL Developer and IntelliJ IDEA

Other Software Used

IntelliJ IDEA, Oracle SQL Developer

Enterprise Database Management at its Best!

Incentivized
Johnny WuView profile
Senior Oracle Database Administrator in Information Technology at New York University (10,001+ employees employees)

Pros

  • User interface is easy to use, and in some ways better than Toad. The left hand side shows all databases, and you can drill down to instance, storage, schemas, tablespaces, and performance views. The right hand side displays the details of the selected object.
  • This is the best tool if you want to manage multiple RDBMS platforms in a single tool using the same familiar interface. Other third party tools can do it also, but it's not nearly as integrated as this, and may require additional plug-ins installed. DBArtisan excels at this, and can perform cross-platform data migrations easily.
  • It has different DB analysts, which can help diagnose issues with performance, optimize storage, detect fragmentation, and plan for capacity growth. For almost any action you want to take, you can generate the DDL for preview, and/or schedule it to run at a specific time.

Cons

  • DBArtisan lacks a utility that does schema or object comparisons, which is a feature in Toad. I find this useful in some situations where I need to find out all differences between Prod and QA for a given schema, for example. DBArtisan doesn't seem to have the capacity to do this.
  • I wish there was a way for the tool to warn me before performing a long-running task. For example if I want to re-organize a large table or rebuild an index for a table with millions of rows, it should warn me before executing it, so that I may choose to do it in a different way. Sometimes if I let these long operations run for too long, it freezes the program and crashes DBArtisan. I would rather run it on the DB server, and run it in background so that it doesn't time out, if DBArtisan gave me a warning before execution.
  • Idera has taken over Embarcadero. I never heard of or dealt with Idera for support. I don't know if they have same the quality support as before.

Return on Investment

  • It has a positive ROI on our organization. It's better than OEM and SQL Developer. Although the license could be expensive, it is perfect for large organizations, especially with multiple RDBMS platforms.
  • Most features are redundant between DBArtisan and Toad. I would not recommend using both if you already own one of them. Just download the trial for the one you're not using, and see what works best for your organization.
  • DBArtisan is great for DBAs and would be my personal preference. Toad is good for developers and DBAs alike but I feel like sometimes the interface is too busy and too clumsy to use.

Other Software Used

Toad for Oracle, SQL Developer

DBArtisan is a good choice for database monitoring

Incentivized
Verified User
Analyst in Product Management (201-500 employees employees)

Pros

  • The free trial offer was great for me to test the software before purchasing it.
  • It monitors queries well and shows resource allocation, as well as detailed stats for each running query.

Cons

  • Local and peer support could be better.
  • The user interface could be improved to a more modern look.

Return on Investment

  • DBArtisan allows me to terminate queries that affect the performance of the database as a whole, which saves resources.
  • DBArtisan allows me to monitor database health, which helps us with the maintenance.

Alternatives Considered

SolarWinds Database Performance Analyzer

Other Software Used

SolarWinds Database Performance Analyzer, ER/Studio Data Architect, Oracle Commerce Cloud, Redgate SQL Monitor, InfoSphere Optim, AutoMate BPA Server, MIMIX Availability, Task Factory