SAS Data Integration Server vs WhereScape RED comparison

SAS and WhereScape are both solutions in the Data Integration category. SAS is ranked #35 with an average rating of 7.5, while WhereScape is ranked #47. SAS holds a 0.5% mindshare in DI, compared to WhereScape’s 1.0% mindshare. Additionally, 83% of SAS users are willing to recommend the solution, compared to 95% of WhereScape users who would recommend it.

SAS Data Integration Server

Read 4 SAS Data Integration Server reviews

689 Views
614 Comparison Views

83% willing to recommend

WhereScape RED

Read 15 WhereScape RED reviews

1,674 Views
1,147 Comparison Views

95% willing to recommend

SAS Data Integration Server

WhereScape RED

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 19, 2024

WhereScape RED and SAS Data Integration Server are competitors in the data integration and warehousing industry. WhereScape RED has the upper hand for cost-effective solutions and fast deployment, while SAS Data Integration Server appeals to those needing extensive capabilities.

Features: WhereScape RED offers automation, rapid development, and ease of use. It enables quick deployment of data warehouses with minimal complexity. SAS Data Integration Server provides robust data transformation abilities and extensive integration options, suited for complex data needs. SAS offers a comprehensive toolkit for detailed data management.

Ease of Deployment and Customer Service: WhereScape RED provides a straightforward deployment, reducing downtime and resource usage. Its customer service is prompt and effective. SAS Data Integration Server has a more elaborate deployment, often needing specialized support. SAS supports detailed assistance and comprehensive documentation.

Pricing and ROI: WhereScape RED's lower setup costs and rapid deployment deliver favorable ROI quickly, benefiting cost-conscious businesses. SAS Data Integration Server demands a higher initial investment but provides substantial ROI through advanced features, ideal for substantial integration needs.

To learn more, read our detailed SAS Data Integration Server vs. WhereScape RED Report (Updated: February 2025).

Buyer's Guide

SAS Data Integration Server vs. WhereScape RED

February 2025

Download the complete report

Helped 837,501 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

SAS Data Integration Server

Ranking in Data Integration

35th

Average Rating

7.2

Reviews Sentiment

6.5

Number of Reviews

Ranking in other categories

No ranking in other categories

WhereScape RED

Ranking in Data Integration

47th

Average Rating

8.2

Reviews Sentiment

7.2

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of February 2025, in the Data Integration category, the mindshare of SAS Data Integration Server is 0.5%, up from 0.5% compared to the previous year. The mindshare of WhereScape RED is 1.0%, up from 0.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration

Featured Reviews

reviewer2937544

Works at a financial services firm with 5,001-10,000 employees

Offloads processes on the server side but needs better installation syntax

One area for improvement is the installation process. Another point could be the syntax, as it sometimes involves using syntax names that are not intuitive. For example, to calculate the difference between two dates, the general syntax in SAS is called the data difference or data net function. However, another name is used, such as NF and INK. Without knowledge of SAS programming, it becomes unclear what these functions mean. It is not good to define function names this way.

Read full review

it_user584544

Manager Data Warehousing at a university with 10,001+ employees

The architecture is based on metadata and documentation is automated.

I would love to see a GUI interface for defining dependencies between build processes. RED provides a spreadsheet like interface for defining the dependencies between builds. Once the dependencies are defined, RED can produce a nice dependency diagram to give a visualization of the dependency tree. It would be easier to define complex dependency relationships if the dependency diagram were interactive. Our legacy ETL tool provided this GUI dependency definition via a drag and drop diagram which was very useful. The solution provided by WhereScape does work, and the dependency diagrams generated are helpful. It would just be nice to have the ability to define dependencies via a diagram, since dependencies relationships are much easier to understand via a diagram.

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

"The solution offers very good data manipulation and loading."

"A key feature allows us to enhance job performance by offloading processing to the server side, rather than processing on the server itself."

"The solution is very stable."

"A key feature allows us to enhance job performance by offloading processing to the server side, rather than processing on the server itself."

"The most valuable feature of the solution is its amazing capabilities in regard to data handling."

"Support is absolutely excellent, efficient, and timely."

"I found the initial setup very easy."

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

"The tool supports multiple target update methods."

"The most valuable feature is the metadata generated code."

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

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

"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."

More WhereScape RED pros

Cons

"The transform tool has limited access. They should make it more flexible."

"The initial setup of SAS Data Integration Server was complex."

"The initial setup had issues, and even after using it for about one year, it was still not fixed."

"So I would like to see improved integration with other software."

"The initial setup had issues, and even after using it for about one year, it was still not fixed."

"One area for improvement is the installation process."

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

"Jobs cannot be deleted via the deployment package. When deploying from dev to QA or production, a job has to be retired. The job has to be manually removed from the target environment."

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

"The solution can be a little more user-friendly on enterprise-level where people use it."

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

"Technical support isn't the best."

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

More WhereScape RED cons

Pricing and Cost Advice

"It is an expensive program."

"ROI is at least 10 times."

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

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

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

837,501 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

27%

Computer Software Company

13%

Government

11%

Insurance Company

Financial Services Firm

19%

Insurance Company

Computer Software Company

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

What do you like most about SAS Data Integration Server?

The most valuable feature of the solution is its amazing capabilities in regard to data handling.

See all answers

What is your experience regarding pricing and costs for SAS Data Integration Server?

I don't handle the cost and budget part. From the tool's perspective, I can say that it is an amazing product.

See all answers

What needs improvement with SAS Data Integration Server?

See all answers

Ask a question

Earn 20 points

Comparisons

SSIS vs SAS Data Integration Server

Compared 28% of the time

Oracle Data Integrator (ODI) vs SAS Data Integration Server

Compared 25% of the time

Azure Data Factory vs SAS Data Integration Server

Compared 23% of the time

Palantir Foundry vs SAS Data Integration Server

Compared 14% of the time

AWS Glue vs SAS Data Integration Server

Compared 11% of the time

More SAS Data Integration Server Competitors

Informatica PowerCenter vs WhereScape RED

Compared 18% of the time

Azure Data Factory vs WhereScape RED

Compared 18% of the time

SSIS vs WhereScape RED

Compared 11% of the time

Matillion ETL vs WhereScape RED

Compared 7% of the time

dbt vs WhereScape RED

Compared 6% of the time

More WhereScape RED Competitors

Product Reports

Buyer's Guide

Data Integration

January 2025

Download SAS Data Integration Server product report

Buyer's Guide

WhereScape RED

January 2025

Download WhereScape RED product report

Also Known As

SAS Enterprise Data Integration Server, Enterprise Data Integration Server

No data available

Overview

SAS Data Integration Server is a powerful, configurable and comprehensive solution that can meet a wide variety of data integration requirements, from small tactical projects to strategic business initiatives. It can access virtually all data sources, support data warehousing, migration, synchronization, federation and provisioning initiatives. It can support both batch-oriented and real-time master data management solutions. It can create reusable data integration services in support of service-oriented architectures and data governance and extract, cleanse, transform, conform, aggregate, load and manage data.

SAS

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.

WhereScape

Sample Customers

Credit Guarantee Corporation, Cr_dito y Cauci‹n, Delaware State Police, Deutsche Lufthansa, Directorate of Economics and Statistics, DSM, Livzon Pharmaceutical Group, Los Angeles County, Miami Herald Media Company, Netherlands Enterprise Agency, New Zealand Ministry of Health, Nippon Paper, West Midlands Police, XS Inc., Zenith Insurance

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

Buyer's Guide

SAS Data Integration Server vs. WhereScape RED

February 2025

Free Report: SAS Data Integration Server vs. WhereScape RED

Find out what your peers are saying about SAS Data Integration Server vs. WhereScape RED and other solutions. Updated: February 2025.

DOWNLOAD NOW

837,501 professionals have used our research since 2012.

See our SAS Data Integration Server 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.