Try our new research platform with insights from 80,000+ expert users

BMC AMI DevX vs SSIS comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

BMC AMI DevX
Average Rating
8.0
Reviews Sentiment
7.2
Number of Reviews
19
Ranking in other categories
Software Configuration Management (1st), Debugging (8th), Database Development and Management (20th), Mainframe Application Development (1st), Test Data Management (7th), Mainframe Testing Tools (1st), Data Masking (8th)
SSIS
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
75
Ranking in other categories
Data Integration (2nd)
 

Mindshare comparison

BMC AMI DevX and SSIS aren’t in the same category and serve different purposes. BMC AMI DevX is designed for Test Data Management and holds a mindshare of 6.9%, up 3.9% compared to last year.
SSIS, on the other hand, focuses on Data Integration, holds 5.7% mindshare, down 7.7% since last year.
Test Data Management Market Share Distribution
ProductMarket Share (%)
BMC AMI DevX6.9%
Perforce Delphix28.3%
Informatica Test Data Management (TDM)15.3%
Other49.5%
Test Data Management
Data Integration Market Share Distribution
ProductMarket Share (%)
SSIS5.7%
Informatica PowerCenter6.0%
Azure Data Factory5.2%
Other83.1%
Data Integration
 

Featured Reviews

Brian Westerman - PeerSpot reviewer
Helps to make mainframe data management process easier and saves manhours
We plan to replace BMC Compuware File-AID due to its price. Two years back, we paid 11,000 dollars. However, the current price is 27,900 dollars. The price has increased to at least eight times its initial cost. We would need to pay around 60,000 dollars to have all three products together. We also encountered issues during version updates.
Chris Farris - PeerSpot reviewer
User-friendly interface facilitates efficient data migration and reduces operational overhead
Its usability and ease of use are standout features. It is really easy to use - almost too easy at times. Users don't have to be experts to use their tool set and utilize the clicking mechanisms, drop down boxes, and other features to build a package and run it. The configuration is very easy and the system is very stable. I would rate it at a 10 as it is highly reliable; we have never had any problems with it. Very little maintenance is required on my side. While you need to keep the product up to date, the maintenance requirements are minimal. SSIS integrates with all Microsoft tools seamlessly. We have used it against Oracle, DB2 and SQL. It integrates and can move data around from any data platforms, making it very diverse in that standpoint. It is a very robust tool that can work with many data sources, and its main strength is that it is extremely easy to use.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"We had parallel development before, but the way ISPW implements it is better. It has more control and oversight of the process, whereas before, it was like the Wild West. Everybody could have their own package with their own version of the component in it... ISPW is constantly aware of it. It notifies when someone else is using or has a different version of that component."
"I like the ability to flow through the source and see what happens to the data as the statements are executed. If there is a fault, it will track the event, and we can then look back to see why it may have caused the fault. You can also reverse engineer your test. You can set it so that you can go backward as well as forward in your test. This is something that I haven't done here at my company. Compuware Xpediter is one of the best debugging tools for mainframe software development. We have currently licensed only the COBOL language for Xpediter, but I know they have other languages, including Assembler, PL/I."
"One of the features that the developers like is that they can retrieve what they need with the tool. They don't have to go through some process or request something be done by another team. They can get the programs they need, compile them, retrieve the JCL and alter the JCL if they need to, and put these programs wherever they need to go for their testing."
"BMC Data Management improved our data recovery process by simplifying it."
"The most valuable feature of Topaz is Xpediter. It's more flexible than Xpediter through MVS."
"From a user perspective, the GUIs make it easier for people to see and interact with files on the mainframe."
"It helps our staff work by speeding up their documentation process."
"We can develop in parallel today on ISPF, but it's giving us the advantage of the newer interface into the mainframe programming languages that younger programmers can use and are familiar with, rather than using the ISPF green screen."
"It is easy to set up. The deployment is also very quick."
"SSIS is easy to use."
"The performance and stability are good."
"The technical support is very good."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"The initial setup was easy."
"It is easy to set up the solution."
 

Cons

"The solution could be improved by being better integrated with the open world. In the next release, I would like to have the ability to work in an open environment whilst remaining integrated with the legacy environment."
"We plan to replace BMC Compuware File-AID due to its price. Two years back, we paid 11,000 dollars. However, the current price is 27,900 dollars. The price has increased to at least eight times its initial cost. We would need to pay around 60,000 dollars to have all three products together. We also encountered issues during version updates."
"It's not as intuitive as it should be. In terms of navigation, there is a large training curve for using it. For a millennial it might be better, if they're used to Eclipse. But coming from a non-Eclipse environment and using Eclipse, though I have experience with Eclipse, it might be cumbersome."
"It often doesn't play well with other plugins in the environment."
"It would be good if the vendors would work together or at least have some collaboration between them, so they would know what would work and what wouldn't work. Right now, the way things are working, they're relying on the customer to make everything work."
"The ability to edit source code that has special characters is limited. The ability to incorporate or convert REXX into macros that are usable under the Topaz software is not there. And the REXX macros that I have developed over 40 years of work are useless, so I have a toolbox I can't use or deploy using the Topaz technology, while I can use it under MVS."
"I'm always looking for improvement in things like the documentation, to make things a little bit easier and simpler to understand, a place where people can go to troubleshoot issues."
"When you're setting up the parameters for how ISPW will work in your shop, there are a lot of questions that have to be answered... BMC Compuware should have more in-depth explanations about what the choices in each question mean. If you pick A, what does that mean has to happen? What does that impact? If you pick B, what does that mean? What does that impact?"
"The security could be improved, as it is more important in our context."
"Tuning using this solution requires extensive expertise to improve performance."
"The high prices attached to the product can be an area of concern where improvements are required."
"Video training would be a helpful addition."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"The solution could improve by having quicker release updates."
"Future releases should improve the data lineage, as it currently is not good."
 

Pricing and Cost Advice

"The price point is great."
"The only thing I would mention related to the licensing and/or the pricing, is that they have some visualization features in there that are licensed by concurrent users. We're starting to trip up on that. We're looking to probably increase the number of concurrent licenses that we have. But those types of licensing strategies, where they license by concurrent users or the number of seats is confusing for some people. They don't understand why it works sometimes and doesn't work other times."
"In terms of pricing, there isn't an extra charge for the parts of it we use. It comes with the licenses we purchased for other products, so no complaints there. The licensing is built in with the other products that you purchase from Compuware."
"I like the seat-based licensing much more than MSU-based licensing, and that the cost has been competitive."
"It has saved our developers time and effort when working on documentation, which is now more readable and fluent."
"In general, Compuware tools are very competitive."
"Our license with SSIS is annual."
"The solution comes free of cost."
"We purchased the standard edition of SQL Server and SSIS came with it free of charge."
"People have to opt for a perpetual-based licensing model."
"The solution is available at a lesser price than that of Informatica."
"SSIS' licensing is a little high, but it gives good value for money."
"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."
"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."
report
Use our free recommendation engine to learn which Test Data Management solutions are best for your needs.
869,566 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Financial Services Firm
36%
Insurance Company
12%
Computer Software Company
7%
Manufacturing Company
7%
Financial Services Firm
18%
Computer Software Company
10%
Government
8%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business6
Large Enterprise16
By reviewers
Company SizeCount
Small Business26
Midsize Enterprise19
Large Enterprise57
 

Questions from the Community

What do you like most about Compuware File-AID?
The product has made our mainframe data management process easier. It has helped us save manhours. The tool's most valuable feature is the ability to edit tape files. Its ability to clone files is ...
What needs improvement with Compuware File-AID?
We plan to replace BMC Compuware File-AID due to its price. Two years back, we paid 11,000 dollars. However, the current price is 27,900 dollars. The price has increased to at least eight times its...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
What do you like most about SSIS?
The product's deployment phase is easy.
What is your experience regarding pricing and costs for SSIS?
It was included in our licensing for SQL server, and our licensing for SQL server was extremely cheap, making it a very good price point for us.
 

Comparisons

 

Also Known As

File-AID, Data for Db2, Code Debug, Data Studio, Workbench for Eclipse, Code Pipeline
SQL Server Integration Services
 

Overview

 

Sample Customers

Helvetia, The IMT Group, Hapag-Lloyd, Royal Bank of Canada, Chunghwa Telecom
1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
Find out what your peers are saying about BMC AMI DevX vs. SSIS and other solutions. Updated: September 2025.
869,566 professionals have used our research since 2012.