No more typing reviews! Try our Samantha, our new voice AI agent.

BMC AMI DevX vs SSIS comparison

Why PeerSpot?
 

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:
 

ROI

Sentiment score
4.6
BMC AMI DevX boosts efficiency with faster build speeds, improved deployment, reduced debugging, and strong ROI based on studies.
Sentiment score
6.5
SSIS is cost-effective, enhancing data management efficiency and integration with SQL Server, providing significant operational and financial benefits.
Faster root cause identification helped me resolve incidents more consistently and reduced the amount of manual debugging effort.
DevOps Developer at a tech vendor with 10,001+ employees
I have seen debugging time decrease by around 20 to 30% because I can trace the COBOL programs and also inspect the variables.
Data Specialist at TCS
The tool has made us tremendously more efficient and saved us a significant amount of money.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
Managing Partner at Dynamis Informatica
 

Customer Service

Sentiment score
7.5
BMC AMI DevX customer service is responsive and effective, though users suggest a need for more experienced techs.
Sentiment score
6.0
Users find Microsoft support adequate for critical issues but often use online resources and community support for minor ones.
Every time I open a case, I get an immediate response.
Devops Engineer / Ispw Admin at a insurance company with 201-500 employees
BMC AMI DevX's technical support responds very well and takes all cases seriously.
Mainframe Modernization Co E & Transformation Lead at cmc
I think the hybrid CI/CD integration with existing enterprise DevOps tools in BMC AMI DevX is very good.
Product Engineer at Absa Group
The first line of support needs to be more knowledgeable.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
 

Scalability Issues

Sentiment score
7.4
BMC AMI DevX is scalable and efficient for mainframe development, supporting thousands on AWS with minor initial issues.
Sentiment score
6.7
SSIS is effective for small to medium enterprises but may face challenges with scalability and performance for large datasets.
From my perspective, I haven't seen BMC AMI DevX struggle in terms of workloads where it needs to be scaled up or scaled down.
Product Engineer at Absa Group
It can support multiple developers for COBOL applications as they debug different problems without changing the overall development process.
DevOps Developer at a tech vendor with 10,001+ employees
It has been scalable for our mainframe development and support needs, handling large COBOL programs and large workloads.
Data Specialist at TCS
I would rate the scalability of SSIS at a 7 because we are able to use various third-party items with it, allowing for functionality with a number of different things.
Tech Lead at a consultancy with 11-50 employees
 

Stability Issues

Sentiment score
8.7
BMC AMI DevX is stable, handles large tasks well, with minor bugs and integration challenges, enhancing user satisfaction.
Sentiment score
7.4
SSIS is highly rated for stability and performance, though minor issues and cloud discrepancies are occasionally noted by users.
I would rate BMC AMI DevX as a stable solution that I have been using for years and find working fine.
Mainframe Modernization Co E & Transformation Lead at cmc
BMC AMI DevX is very stable for a modern application processing huge workloads.
Product Engineer at Absa Group
It has been reliable for COBOL debugging, code analysis, and troubleshooting production incidents.
DevOps Developer at a tech vendor with 10,001+ employees
It processes large volumes of data quickly.
Managing Partner at Dynamis Informatica
 

Room For Improvement

BMC AMI DevX needs integration, user interface improvements, better debugging, and support for seamless transition from TSO to GUIs.
SSIS needs enhanced error logging, diverse data integration, user management, ease of use, scalability, and better documentation support.
Being able to step through the COBOL program, set breakpoints, and monitor variable values gives me a much clearer picture of what is happening during execution.
DevOps Developer at a tech vendor with 10,001+ employees
I have to put my cursor on the field and tap it to bring focus there, or use the tab key multiple times to get to a field on the screen.
Devops Engineer / Ispw Admin at a insurance company with 201-500 employees
To improve BMC AMI DevX, consideration should be given to cloud-style provisioning and development models, as well as integration of more AI capabilities.
Mainframe Modernization Co E & Transformation Lead at cmc
Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.
Managing Director at Knights Innovation Support Centre
SSIS has a difficult learning curve when dealing with complex transformations.
Managing Partner at Dynamis Informatica
The logging capabilities could be improved, particularly for error logging.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
 

Setup Cost

BMC AMI DevX offers competitive pricing for enterprises with customizable licensing and favorable agreements like Enterprise Agreements.
SSIS is economical with SQL Server licenses, offering favorable pricing and integration, though add-ons may increase costs.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
Managing Partner at Dynamis Informatica
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.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
However, it could be a bit cheaper.
Tech Lead at a consultancy with 11-50 employees
 

Valuable Features

BMC AMI DevX enhances productivity with seamless code management, modern tools integration, and efficient cloud data handling capabilities.
SSIS offers efficient, scalable ETL with seamless Microsoft integration, user-friendly interface, flexibility, and cost-effectiveness, enhancing data processes.
The CI/CD offering allows integration of quality checks and unit test processes into the pipeline, which improves compliance and enhances productivity, enabling developers to focus on development while the pipeline automates integration.
Mainframe Modernization Co E & Transformation Lead at cmc
BMC AMI DevX's tools have affected my developers' productivity and efficiency by helping with the speed.
Product Engineer at Absa Group
BMC AMI DevX positively impacts my organization with its modern VS Code and Eclipse development environment, integrated debugging, AI-assisted code understanding, automated CI/CD pipelines, and end-to-end mainframe DevOps workflow.
Full Stack Developer at imsnoida
I would rate it at a 10 as it is highly reliable; we have never had any problems with it.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
Managing Partner at Dynamis Informatica
SSAS is included in the base installation of SQL Server.
Managing Director at Knights Innovation Support Centre
 

Categories and Ranking

BMC AMI DevX
Average Rating
8.0
Reviews Sentiment
6.6
Number of Reviews
25
Ranking in other categories
Software Configuration Management (1st), Debugging (2nd), Database Development and Management (11th), Mainframe Application Development (1st), Test Data Management (4th), Mainframe Testing Tools (1st), Data Masking (3rd), AI Software Development (30th)
SSIS
Average Rating
7.6
Reviews Sentiment
6.7
Number of Reviews
76
Ranking in other categories
Data Integration (3rd)
 

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 12.3%, up 6.8% compared to last year.
SSIS, on the other hand, focuses on Data Integration, holds 4.0% mindshare, down 5.7% since last year.
Test Data Management Mindshare Distribution
ProductMindshare (%)
BMC AMI DevX12.3%
Perforce Delphix16.0%
Broadcom Test Data Manager13.6%
Other58.1%
Test Data Management
Data Integration Mindshare Distribution
ProductMindshare (%)
SSIS4.0%
Informatica Intelligent Data Management Cloud (IDMC)3.8%
Informatica PowerCenter3.6%
Other88.6%
Data Integration
 

Featured Reviews

AkshayChaudhari - PeerSpot reviewer
Data Specialist at TCS
Modern workflow has improved COBOL debugging and simplifies understanding complex legacy code
The most valuable feature is the integrated COBOL debugging and code analysis capability. Being able to step through programs, set breakpoints, and monitor variable values to understand how the program flow operates makes troubleshooting much easier and more structured. I also appreciate the modern development environment for editing COBOL, browsing datasets, and submitting JCL jobs without constantly switching between different tools. The code navigation and AI-assisted code understanding capabilities are also useful for working with unfamiliar legacy applications. The code understanding features have been useful when I need to work with unfamiliar COBOL applications. They help me explain existing code, identify the relationships and dependencies between programs and copybooks, and make it easier to understand the overall program flow. Instead of manually tracking every section of a large legacy application, I can use the AI assistance to get a quicker understanding of what the code is doing and where a change may have an impact. This reduces the time to get familiar with older code and makes maintenance and troubleshooting more straightforward and efficient.
reviewer2318280 - PeerSpot reviewer
Tech Lead at a consultancy with 11-50 employees
Reporting has become streamlined for year-end data checks but integration still needs improvement
When I talk about SQL Server, I am working with SSIS, the data integration tool. I am not entirely sure if I use SSIS as a library of transformations or if I personally work with an extensive library of transformations. I have integrated SSIS with SQL Server Management Studio, and I am very satisfied with the integration as it is integrated well. I am not using the debugging feature in SSIS because the developers would be the ones that would actually utilize it. I have noticed that in 2022, AI functionality has actually been implemented already. I would rate this review overall at a 7.
report
Use our free recommendation engine to learn which Test Data Management solutions are best for your needs.
915,341 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
BI Expert at a healthcare company with 1,001-5,000 employees
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
29%
Manufacturing Company
8%
Insurance Company
8%
Construction Company
7%
Financial Services Firm
13%
Construction Company
8%
Manufacturing Company
8%
Outsourcing Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business9
Midsize Enterprise1
Large Enterprise24
By reviewers
Company SizeCount
Small Business27
Midsize Enterprise19
Large Enterprise58
 

Questions from the Community

What is your experience regarding pricing and costs for BMC Compuware Topaz Enterprise Data?
My understanding is that BMC AMI DevX is an enterprise product with custom licensing, so pricing is typically negotiated based on factors such as the modules purchased, organization size, and usage...
What needs improvement with BMC AMI DevX?
BMC AMI DevX is a strong platform, but there are a few areas where it could improve, such as simplifying the initial installation and configuration, especially for first-time users. It could also i...
What is your primary use case for BMC AMI DevX?
My main use case for BMC AMI DevX is to work with COBOL and JCL development on IBM. I mainly use it for editing, browsing data sets, submitting jobs, and debugging applications. I appreciate the Ec...
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 is your experience regarding pricing and costs for SSIS?
Pricing is pretty reasonable, so I would rate it at a 5. However, it could be a bit cheaper.
What needs improvement with SSIS?
SSIS could be integrated with more services, such as Power BI, to make the reporting structures more user-friendly. The initial setup for SSIS is somewhat complex in the beginning, but once you und...
 

Also Known As

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

Overview

 

Sample Customers

NRB, Iberdrola, Consorzio Servizi Bancari 
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 Perforce, Informatica, Broadcom and others in Test Data Management. Updated: September 2026.
915,341 professionals have used our research since 2012.