StreamSets vs WhereScape RED comparison

IBM and WhereScape are both solutions in the Data Integration category. IBM is ranked #9 with an average rating of 8.4, while WhereScape is ranked #49. IBM holds a 1.7% mindshare in DI, compared to WhereScape’s 1.0% mindshare. Additionally, 100% of IBM users are willing to recommend the solution, compared to 95% of WhereScape users who would recommend it.

StreamSets

Read 24 StreamSets reviews

3,109 Views
1,983 Comparison Views

100% willing to recommend

WhereScape RED

Read 15 WhereScape RED reviews

1,992 Views
1,358 Comparison Views

95% willing to recommend

StreamSets

WhereScape RED

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between StreamSets and WhereScape RED based on real PeerSpot user reviews.

Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed StreamSets vs. WhereScape RED Report (Updated: November 2024).

Buyer's Guide

StreamSets vs. WhereScape RED

November 2024

Download the complete report

Helped 816,406 peers since 2012

Categories and Ranking

StreamSets

Ranking in Data Integration

9th

Average Rating

8.4

Reviews Sentiment

7.5

Number of Reviews

Ranking in other categories

No ranking in other categories

WhereScape RED

Ranking in Data Integration

49th

Average Rating

8.2

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of November 2024, in the Data Integration category, the mindshare of StreamSets is 1.7%, up from 1.3% compared to the previous year. The mindshare of WhereScape RED is 1.0%, down from 1.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration

Featured Reviews

Reyansh Kumar

Technical Specialist at Accenture

We no longer need to hire highly skilled data engineers to create and monitor data pipelines

The things I like about StreamSets are its * overall user interface * efficiency * product features, which are all good. Also, the scheduling within the data engineering pipeline is very much appreciated, and it has a wide range of connectors for connecting to any data sources like SQL Server, AWS, Azure, etc. We have used it with Kafka, Hadoop, and Azure Data Factory Datasets. Connecting to these systems with StreamSets is very easy. You just need to configure the data sources, the paths and their configurations, and you are ready to go. It is very efficient and very easy to use for ETL pipelines. It is a GUI-based interface in which you can easily create or design your own data pipelines with just a few clicks. As for moving data into modern analytics systems, we are using it with Microsoft Power BI, AWS, and some on-premises solutions, and it is very easy to get data from StreamSets into them. No hardcore coding or special technical expertise is required. It is also a no-code platform in which you can configure your data sources and data output for easy configuration of your data pipeline. This is a very important aspect because if a tool requires code development, we need to hire software developers to get the task done. By using StreamSets, it can be done with a few clicks.

Read full review

reviewer1618884

BI Analyst DW Architect at a mining and metals company with 10,001+ employees

Quick to set up, flexible, and stable

The scheduling part I don't like due to the fact that it allows you to schedule as a parent and child and other things, however, the error trackability has to be a little more user-friendly. It's also not user-friendly in the sense that it loads all the jobs and there are not enough filters so that it doesn't need to load everything. If the job fails, you don't get any type of alert or email. It would be ideal if there was some sort of automated alert message. Technical support isn't the best. It would be ideal if we understood how to do it in a card exception regarding exclusion, where the card is captured separately rather than filling the whole process on the data inbound side. Certain workloads like this are organized in such a way where you seem to be doubling the work as opposed to streamlining the process.

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

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

"The UI is user-friendly, it doesn't require any technical know-how and we can navigate to social media or use it more easily."

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

"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 ability to have a good bifurcation rate and fewer mistakes is valuable."

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

"I have used Data Collector, Transformer, and Control Hub products from StreamSets. What I really like about these products is that they're very user-friendly. People who are not from a technological or core development background find it easy to get started and build data pipelines and connect to the databases. They would be comfortable like any technical person within a couple of weeks."

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

More StreamSets pros

"RED has provided us the ability to integrate, stage, and transform data from diverse sources into an enterprise-grade data warehouse which meets the needs of my organization, but it also enables us to easily and quickly make ETL or DW changes."

"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."

"I found the initial setup very easy."

"WhereScape's deployment package is a fantastic feature. The application allows for selecting specific objects that you would like to deploy from one environment to another rather than deploying the entire database."

"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."

"The tool supports multiple target update methods."

"Naturally produces a way to easily debug your DW data solutions."

"WhereScape is really helpful in terms of architecture data. Everything is one of automation. Two people can do thousands of tables in one day or two. It saves a lot of time."

More WhereScape RED pros

Cons

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

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

"The software is very good overall. Areas for improvement are the error logging and the version history. I would like to see better, more detailed error logging information."

"Using ETL pipelines is a bit complicated and requires some technical aid."

"One thing that I would like to add is the ability to manually enter data. The way the solution currently works is we don't have the option to manually change the data at any point in time. Being able to do that will allow us to do everything that we want to do with our data. Sometimes, we need to manually manipulate the data to make it more accurate in case our prior bifurcation filters are not good. If we have the option to manually enter the data or make the exact iterations on the data set, that would be a good thing."

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

"I would like to see further improvement in the UI. In addition, upgrades are not automatic and they should be automated. Currently, we have to manually upgrade versions."

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

More StreamSets cons

"No support for change data capture or delta detection - that must be custom coded ."

"Project-based searching of data objects in the data warehouse browser needs to be improved."

"Customization could be better."

"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."

"The scheduled jobs which are run by the WhereScape scheduler seem to be a strangely separate animal. Unlike all other WhereScape objects, jobs cannot be added to WhereScape projects. Also, unlike all other objects, jobs also cannot be deleted using a WhereScape deployment application."

"Technical support isn't the best."

"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."

"Improve the object renaming ability (it works, but it could be more automated)."

More WhereScape RED cons

Pricing and Cost Advice

"It has a CPU core-based licensing, which works for us and is quite good."

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

"The overall cost for small and mid-size organizations needs to be better."

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

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

"I believe the pricing is not equitable."

"StreamSets is an expensive solution."

"The pricing is too fixed. It should be based on how much data you need to process. Some businesses are not so big that they process a lot of data."

More StreamSets pricing and cost advice

"Speed to market of a warehouse solution at a relatively inexpensive price point."

"Factor in the price of specialized consulting who know this product. They're hard to find and expensive."

"Our company purchased a corporate unlimited license."

"ROI is at least 10 times."

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

816,406 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

17%

Computer Software Company

13%

Manufacturing Company

Insurance Company

Financial Services Firm

17%

Government

10%

Insurance Company

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

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

See all answers

What needs improvement with StreamSets?

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

See all answers

What is your primary use case for StreamSets?

StreamSets is used for data transformation rather than ETL processes. It focuses on transforming data directly from sources without handling the extraction part of the process. The transformed data...

See all answers

Ask a question

Earn 20 points

Comparisons

Informatica PowerCenter vs StreamSets

Compared 13% of the time

IBM InfoSphere DataStage vs StreamSets

Compared 12% of the time

Fivetran vs StreamSets

Compared 10% of the time

webMethods.io vs StreamSets

Compared 9% of the time

Azure Data Factory vs StreamSets

Compared 8% of the time

More StreamSets Competitors

Informatica PowerCenter vs WhereScape RED

Compared 21% of the time

Azure Data Factory vs WhereScape RED

Compared 21% of the time

SSIS vs WhereScape RED

Compared 10% of the time

Matillion ETL vs WhereScape RED

Compared 10% of the time

Denodo vs WhereScape RED

Compared 7% of the time

More WhereScape RED Competitors

Product Reports

Buyer's Guide

StreamSets

October 2024

Download StreamSets product report

Buyer's Guide

WhereScape RED

October 2024

Download WhereScape RED product report

Learn More

Video not available

IBM

Video not available

WhereScape

Overview

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.

WhereScape is data warehouse software that automates the Data Warehouse lifecycle. From implementation to maintenance, WhereScape will ensure your data warehouse projects are completed up to 5x faster than manual coding.

Sample Customers

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

British American Tobacco, Cornell University, Allianz Benelux, Finnair, Solarwinds and many more.

Buyer's Guide

StreamSets vs. WhereScape RED

November 2024

Free Report: StreamSets vs. WhereScape RED

Find out what your peers are saying about StreamSets vs. WhereScape RED and other solutions. Updated: November 2024.

DOWNLOAD NOW

816,406 professionals have used our research since 2012.

See our StreamSets vs. WhereScape RED report.

See our list of best Data Integration vendors.

We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.