BMC Data Management for IMS and DB2 on zOS vs SSIS comparison

BMC Data Management for IMS and DB2 on zOS vs. SSIS

Download the complete report

Helped 850,043 peers since 2012

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 Data Management for IMS...

Average Rating

8.6

Reviews Sentiment

7.6

Number of Reviews

Ranking in other categories

Database Development and Management (21st)

SSIS

Average Rating

7.6

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

Data Integration (4th)

Mindshare comparison

BMC Data Management for IMS and DB2 on zOS and SSIS aren’t in the same category and serve different purposes. BMC Data Management for IMS and DB2 on zOS is designed for Database Development and Management and holds a mindshare of 0.4%, down 0.4% compared to last year.
SSIS, on the other hand, focuses on Data Integration, holds 7.9% mindshare, up 7.9% since last year.

Database Development and Management

Data Integration

Featured Reviews

RobertSamson

Technical Consultant at Services Robert Samson SCRS

Improves disaster recovery processes and offers an efficient CPU cycle optimization

Using BMC Data Management for IMS and DB2 on z/OS has greatly improved our database administration tasks. Although we don't test the database before production, we have experienced benefits in disaster recovery situations and capacity management. For instance, when facing capacity issues during peak transaction times, I've been able to quickly allocate additional resources to ensure smooth operations. This has been crucial, especially during times when the demand surges, such as peak flight hours.

Read full review

BobAmy

Sr. Architect - Data warehousing & BI at Molina Healthcare, Inc.

Robust and does a good job of handling overload conditions

We purchase an add-on called task factory primarily to allow bulk delete, update, and upsert capability. I'd like to see this be part of the standard package. I believe there are ways to build a model and set variables so that it can be a generic process. In my next system, I would like to have a generic process that would handle all the logging and processing in a model that can be modified and enhanced as the need for a better process, or different statistics to be logged is discovered. I'd want this in a way that the model can be changed and all the processes, with their unique parameters, could all be changed with the model upgraded. I believe they should add some features that help to create the code using a model. This would allow for continuous improvement of the model uses and easy replication of all the different programs that use the model.

Read full review

Quotes from Members

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

Pros

"I have worked with DB2's great features in the last five years. The IDAA feature transformed the vision of warehousing, business analytics, and big data at my bank. Besides the mainframe, I saw that this solution was evolutionary. It gives real-time information."

"BMC Data Management improved our data recovery process by simplifying it."

"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."

"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."

"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."

"The initial setup was easy."

"We like that this solution includes a developer edition, free of charge, to allow for training."

"It is easy to set up the solution."

"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."

"The performance and stability are good."

More SSIS pros

Cons

"DB2 is a hard tool to grasp. It's hard for users to learn how to use it. It's not easy to see how it works."

"One area for improvement with this product could be in providing clearer guidance and tools for disaster recovery planning and execution."

"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."

"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."

"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."

"SSIS is stable, but extensive ETL data processing can have some performance issues."

"SSIS has room for improvement, mainly because the overall package can be buggy. It often locks up, requiring a restart, which is annoying. However, since it's free, we tolerate these performance issues. I'd like to see better debugging tools in future releases and improvements in API calls; It would be helpful if SSIS had a built-in API engine so we wouldn't have to rely solely on database connections."

"The high prices attached to the product can be an area of concern where improvements are required."

"Integration and the user interface are areas with certain shortcomings that require some improvements."

"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."

More SSIS cons

Pricing and Cost Advice

Information not available

"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."

"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."

"This solution is included with the MSSQL server package."

"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."

"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 economical. You don't have to worry about the pricing as long as you're installing both services on the same server."

"It would be beneficial if the solution had a less costly cloud offering."

More SSIS pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.

See recommendations

850,043 professionals have used our research since 2012.

Comparison Review

it_user90069

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…

Read full review

Top Industries

By visitors reading reviews

Financial Services Firm

31%

Insurance Company

13%

Manufacturing Company

10%

Logistics Company

Financial Services Firm

19%

Computer Software Company

12%

Government

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

What do you like most about BMC Data Management for IMS and DB2 on zOS?

BMC Data Management improved our data recovery process by simplifying it.

What needs improvement with BMC Data Management for IMS and DB2 on zOS?

One area for improvement with this product could be in providing clearer guidance and tools for disaster recovery planning and execution. As someone involved in managing infrastructure, understandi...

What advice do you have for others considering BMC Data Management for IMS and DB2 on zOS?

From my perspective as an infrastructure guy, the most valuable aspect of BMC's data management solutions was their ability to optimize CPU cycles, improving IMS performance without directly impact...

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?

Utilizing SSIS involves no extra charges beyond the SQL Server license. It's an economical choice for my clients.

Informatica PowerCenter vs SSIS

Comparisons

No data available

Compared 19% of the time

Talend Open Studio vs SSIS

Compared 12% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 7% of the time

dbt vs SSIS

Compared 6% of the time

More SSIS Competitors

Product Reports

Database Development and Management

Download BMC Data Management for IMS and DB2 on zOS product report

BMC Data Management for IMS and DB2 on zOS report

SSIS

Download SSIS product report

Also Known As

BMC Data Management for IMS and DB2 on z/OS, Data Management for IMS and DB2 on z/OS

SQL Server Integration Services

Overview

Transform the management of your DB2 databases to meet the scale and complexity of digital business

Run DB2 utilities with BMC Next Generation Technology to optimize your data and improve application performance
Eliminate downtime and increase availability of business services
Ensure the integrity of structured and unstructured data
Take control with intelligent automation and policy-driven rules
Bridge the gap from green-screen to modern, secure, self-service user interfaces
Move to DB2 12 and beyond with confidence

BMC

SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.

Microsoft

Sample Customers

Airline Tariff Publishing Co (ATPCO), AtTask, MetaScale

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

BMC Data Management for IMS and DB2 on zOS vs. SSIS