BMC AMI DevX vs. Pragmatic Workbench (discontinued)

It's pretty good at creating an extract of a whole table, but not the best at grabbing all related tables in my experience. Pretty intuitive on setting up your test data categories. I also really like that it can either run via ISPF or via Topaz which was included with our purchase.

Incentivized

Workbench Enterprise is consistent across devices and users so far. It works the same, and access is easy. I have a problem with its security. If you use an enterprise password to access databases, it's very easy to click the show password on the connection page and expose the enterprise password. You shouldn't allow users to use the same accounts to access the database because that means all users are sharing the same password.

Incentivized

• Extract/load data from one DB or table to another masking the data for testing.
• Compare extracts against each other to ensure good baselines.

Incentivized

• Querying is easy and quick.
• Updating tables is very easy.
• It gives us very accurate error messages.

Incentivized

• I find it more obtuse to use than IBM Optim.
• Related tables are difficult to incorporate.

Incentivized

• It has autocompleted, but I find it difficult to use or get to use.
• It doesn't automatically complete table names or field names.

Incentivized

Support has been amazing compared to Optim. Further, new features are very regular with File-AID - I can't remember the last time Optim had a significant update. File-AID support is very receptive to feature requests and reported bugs, including sending out hotfixes quickly.

Incentivized

Our team does the support for us. Sometimes we see download related issues that can easily be fixed by our team. Most issues you will see with one user in your org will probably happen to others, so keep a log and track those issues. Then have a fix for them somewhere that everyone has access to. This will save you a lot of time troubleshooting.

Incentivized

Optim is more user friendly in how it operates, in my opinion. It's less obtuse to figure out how to extract and mask the data required compared to File-AID. Further, Optim is easier to gather related tables, by far. I do prefer using File-AID via the Topaz GUI much more than using Optim via its GUI. Finally, I personally believe that File-AID is significantly faster to run than Optim - this could be a configuration issue.

Incentivized

• Saves time creating production like data for testing.
• Keeps that data safe from developers and need-to-know only.

Incentivized

• I personally like Workbench Enterprise, and I can do everything I need to do using it.

Incentivized