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

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

Download the complete report

Helped 850,236 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)

StreamSets

Average Rating

8.4

Reviews Sentiment

7.0

Number of Reviews

Ranking in other categories

Data Integration (16th)

Mindshare comparison

BMC Data Management for IMS and DB2 on zOS and StreamSets 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.
StreamSets, on the other hand, focuses on Data Integration, holds 1.6% mindshare, up 1.4% 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

Karthik Rajamani

Principal Engineer at Tata Consultancy Services

Integrates with different enterprise systems and enables us to easily build data pipelines without knowing how to code

There are a few things that can be better. We create pipelines or jobs in StreamSets Control Hub. It is a great feature, but if there is a way to have a folder structure or organize the pipelines and jobs in Control Hub, it would be great. I submitted a ticket for this some time back. There are certain features that are only available at certain stages. For example, HTTP Client has some great features when it is used as a processor, but those features are not available in HTTP Client as a destination. There could be some improvements on the group side. Currently, if I want to know which users are a part of certain groups, it is not straightforward to see. You have to go to each and every user and check the groups he or she is a part of. They could improve it in that direction. Currently, we have to put in a manual effort. In case something goes wrong, we have to go to each and every user account to check whether he or she is a part of a certain group or not.

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

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

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

"The most valuable feature is the pipelines because they enable us to pull in and push out data from different sources and to manipulate and clean things up within them."

"The entire user interface is very simple and the simplicity of creating pipelines is something that I like very much about it. The design experience is very smooth."

"The most valuable would be the GUI platform that I saw. I first saw it at a special session that StreamSets provided towards the end of the summer. I saw the way you set it up and how you have different processes going on with your data. The design experience seemed to be pretty straightforward to me in terms of how you drag and drop these nodes and connect them with arrows."

"StreamSets data drift feature gives us an alert upfront so we know that the data can be ingested. Whatever the schema or data type changes, it lands automatically into the data lake without any intervention from us, but then that information is crucial to fix for downstream pipelines, which process the data into models, like Tableau and Power BI models. This is actually very useful for us. We are already seeing benefits. Our pipelines used to break when there were data drift changes, then we needed to spend about a week fixing it. Right now, we are saving one to two weeks. Though, it depends on the complexity of the pipeline, we are definitely seeing a lot of time being saved."

"In StreamSets, everything is in one place."

"What I love the most is that StreamSets is very light. It's a containerized application. It's easy to use with Docker. If you are a large organization, it's very easy to use Kubernetes."

"The Ease of configuration for pipes is amazing. It has a lot of connectors. Mainly, we can do everything with the data in the pipe. I really like the graphical interface too"

"Also, the intuitive canvas for designing all the streams in the pipeline, along with the simplicity of the entire product are very big pluses for me. The software is very simple and straightforward. That is something that is needed right now."

More StreamSets 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."

"StreamSets should provide a mechanism to be able to perform data quality assessment when the data is being moved from one source to the target."

"If you use JDBC Lookup, for example, it generally takes a long time to process data."

"The documentation is inadequate and has room for improvement because the technical support does not regularly update their documentation or the knowledge base."

"One area for improvement could be the cloud storage server speed, as we have faced some latency issues here and there."

"One issue I observed with StreamSets is that the memory runs out quickly when processing large volumes of data. Because of this memory issue, we have to upgrade our EC2 boxes in the Amazon AWS infrastructure."

"We often faced problems, especially with SAP ERP. We struggled because many columns weren't integers or primary keys, which StreamSets couldn't handle. We had to restructure our data tables, which was painful. Also, pipeline failures were common, and data drifting wasn't addressed, which made things worse. Licensing was another issue we encountered."

"The logging mechanism could be improved. If I am working on a pipeline, then create a job out of it and it is running, it will generate constant logs. So, the logging mechanism could be simplified. Now, it is a bit difficult to understand and filter the logs. It takes some time."

"Currently, we can only use the query to read data from SAP HANA. What we would like to see, as soon as possible, is the ability to read from multiple tables from SAP HANA. That would be a really good thing that we could use immediately. For example, if you have 100 tables in SQL Server or Oracle, then you could just point it to the schema or the 100 tables and ingestion information. However, you can't do that in SAP HANA since StreamSets currently is lacking in this. They do not have a multi-table feature for SAP HANA. Therefore, a multi-table origin for SAP HANA would be helpful."

More StreamSets cons

Pricing and Cost Advice

Information not available

"The pricing is affordable for any business."

"There are two editions, Professional and Enterprise, and there is a free trial. We're using the Professional edition and it is competitively priced."

"We use the free version. It's great for a public, free release. Our stance is that the paid support model is too expensive to get into. They should honestly reevaluate that."

"There are different versions of the product. One is the corporate license version, and the other one is the open-source or free version. I have been using the corporate license version, but they have recently launched a new open-source version so that anybody can create an account and use it. The licensing cost varies from customer to customer. I don't have a lot of input on that. It is taken care of by PMO, and they seem fine with its pricing model. It is being used enterprise-wide. They seem to have got a good deal for StreamSets."

"StreamSets is an expensive solution."

"The overall cost is very flexible so it is not a burden for our organization... However, the cost should be improved. For small and mid-size organizations it might be a challenge."

"StreamSets Data Collector is open source. One can utilize the StreamSets Data Collector, but the Control Hub is the main repository where all the jobs are present. Everything happens in Control Hub."

"The licensing is expensive, and there are other costs involved too. I know from using the software that you have to buy new features whenever there are new updates, which I don't really like. But initially, it was very good."

More StreamSets 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,236 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

31%

Insurance Company

13%

Manufacturing Company

10%

Logistics Company

Financial Services Firm

13%

Computer Software Company

11%

Manufacturing Company

10%

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

What do you like most about StreamSets?

The best thing about StreamSets is its plugins, which are very useful and work well with almost every data source. It's also easy to use, especially if you're comfortable with SQL. You can customiz...

What needs improvement with StreamSets?

One issue I observed with StreamSets is that the memory runs out quickly when processing large volumes of data. Because of this memory issue, we have to upgrade our EC2 boxes in the Amazon AWS infr...

What is your primary use case for StreamSets?

We are using StreamSets for batch loading.

Informatica PowerCenter vs StreamSets

Comparisons

No data available

Compared 12% of the time

IBM InfoSphere DataStage vs StreamSets

Compared 12% of the time

webMethods.io vs StreamSets

Compared 9% of the time

Fivetran vs StreamSets

Compared 7% of the time

Azure Data Factory vs StreamSets

Compared 7% of the time

More StreamSets 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

StreamSets

Download StreamSets product report

Also Known As

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

No data available

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

StreamSets is a data integration platform that enables organizations to efficiently move and process data across various systems. It offers a user-friendly interface for designing, deploying, and managing data pipelines, allowing users to easily connect to various data sources and destinations. StreamSets also provides real-time monitoring and alerting capabilities, ensuring that data is flowing smoothly and any issues are quickly addressed.

IBM

Sample Customers

Airline Tariff Publishing Co (ATPCO), AtTask, MetaScale

Availity, BT Group, Humana, Deluxe, GSK, RingCentral, IBM, Shell, SamTrans, State of Ohio, TalentFulfilled, TechBridge

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