BMC AMI Data vs. DBArtisan

BMC AMI Data mainframe products are well suited to mature mainframe environments staffed by experienced IT professionals who know and understand the database environments they're operating in. Those same products are less suited environments with staff whose primary experiences are with distributed platforms where there's less hands on work and a reliance on 'point and click' tools.

Incentivized

DBArtisan is excellent for large institutions with multiple mission-critical databases. It works especially well for cross-platforms RDBMS support. I am mostly familiar with Oracle, but less familiar with SQL Server and Sybase. So I certainly appreciate having a similar interface that allows me to manage those less familiar RDBMS, as this will mean a smaller learning curve. DBArtisan is mostly for DBAs, it is not suitable for developers, I believe the vendor has a separate tool for that

Incentivized

• Whatif Analys of sql, in a simple and fast way
• Navigation of Catalog Objects in a suitable way
• Seeing how consumption ae done inside Apptune

Incentivized

• 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.

Incentivized

• The only thing that I can say about BMC AMI tools that is even remotely negative is their cost. I've been involved at several companies over the years with converting from BMC products to those of competitors and there's never been an issue with the tools themselves, just their costs.

Incentivized

• 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.

Incentivized

It is very usable, but sometimes with rare and tricky commands, a more deep, help would be more useful.

Incentivized

I have never tried their support so the number above is meaningless

Incentivized

It is not my choice, management do. And I was very happy because i used BMC suite for almost 25 years, so a deep knowledge, helps in doing stuff. I used Broadcom in 2 shops, but for very short periods.

Incentivized

DBArtisan does not have an in-depth performance analyzer for databases.

Incentivized

• Costs savings, because we can do stuff in a shorter and reliable way.
• We can arrange job in a fast way, with all objects in
• Change manager helps even in simple tasks, for the Checks that it will do behind the curtains.

Incentivized

• 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

Incentivized