DBArtisan vs. Fortra’s Automate

DBArtisan is functional and suitable for any sized organization that needs to monitor its database resources and running queries.

Incentivized

It's great for repetitive or regularly scheduled activities like reports or file transfers. However, it's not so good for on-demand activities. It doesn't support task shortcuts to run specific tasks. If it did it would be perfect.

Incentivized

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

Incentivized

• Very detailed task builder. Easy to read step by step a task's operation even if you don't have much programming knowledge.
• Scheduling for automation jobs is very flexible. Allows us to create all kinds of job schedules as needed.
• Organization of jobs, tasks, conditions is done well. Allows us to easily manage our items.

Incentivized

• Locks up far too often
• Licensing structure is expensive

Incentivized

• A reporting capability on tasks: enabled, disabled, by folder, by trigger, etc. Currently there is none.
• An "OR" in their conditional statements - currently there is only "AND".
• Some kind of temporary backup when changing a task - separate from the current back up/restore functionality (which works well).

Incentivized

It's just very easy to use, extremely versatile, and very reliable. It's hard to find use cases where it won't work.

Incentivized

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

Incentivized

Support is very helpful and responsive, although using the tool is very user-friendly, so I hardly use the service.

Incentivized

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

Incentivized

Incentivized

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

Incentivized

• It's been a net positive as AutoMate requires less eyes on specific tasks so that people can focus attention elsewhere and do more analysis.
• Less manual work also decreases the chances of mistakes and/or missed jobs. Since Automate can schedule everything, send email notifications, etc., there is less time wasted.

Incentivized