contact
The pros and cons of SAS ETL & Data Integration
In-depth review of SAS ETL software. Click here for our independent ETL guide:

  • 100% independent information
  • SAS ETL compared on more than 250 criteria
  • Instant insight into SAS ETL qualities
to the online ETL guide

SAS ETL & Data Integration

In this background article we give an abstract of our recently updated, independent ETL & Data Integration study of the software vendor SAS and its portfolio of products (such as SAS Viya, SAS Data Integration Studio and SAS/ACCESS). SAS ETL & Data Integration scores better in our comprehensive research than SAP but slightly worse than Microsoft. SAS is vigorous in data connectivity and the least strong in master data management. Within the context of ETL & Data Integration, we have researched the pros and cons of SAS Data Integration, and listed them by theme (data integration, ETL, data replication and Data quality). We also display the distinguishing features of the most popular products like SAS Viya, SAS Data Integration Studio and SAS/ACCESS et cetera.

Read more
Open the Table of Contents

In this article 🕑 15 minutes

Hire SAS consultant

How does SAS ETL & Data Integration perform on certain components?

Score of SAS Data Integration software.Figure 1: Scorecard of the Data Integration provider SAS. A vendor can score a maximum of 100%. Reference: the ETL & Data Integration Guide 2022. Do you want to know more about the design of our research? Check out our buyers guide for ETL & Data Integration.

In our survey we looked in detail at the various software products of SAS software. We evaluated SAS ETL & Data Integration on no less than 290 criteria. The bar chart below illustrates the pros and cons of SAS Data Integration. Please note that Passionned Group is 100% independent of the suppliers in our guide. We are not a reseller, we do not make deals or have any ties to the vendor. Among other things, we help and advise organizations in selecting the right ETL & Data Integration platform.

The SAS analysis was made possible by tapping into a lot of public big data and from there it was analyzed in-depth. More than 1,712 documents further we know that SAS excels in data connectivity. In this analysis process both algorithms as a senior expert had a crucial role in finalizing the validation process.

SAS and their complete ETL & Data Integration product portfolio

The vendor SAS has (a minimum of) 26 products in the field of ETL & Data Integration. We list the most important products in order of popularity here:

What is SAS Data Integration?

We do not display here all the features but, in this paragraph, we provide a description of SAS Data Integration, including some of its features and any related products. This product group consists of SAS Viya, SAS Data Integration Studio, SAS/ACCESS, SAS Dataflux Data Management, SAS Data Quality, SAS Data Management, SAS LASR Analytic Server, SAS Metadata Server, SAS ETL, SAS Business Rules Manager, SAS Data Loader, SAS Clinical Data Integration, SAS Data Preparation, SAS Data Surveyor, SAS Data Governance, SAS Data Integration Server, SAS OLAP Server, SAS Metadata Bridge, SAS Data Explorer, SAS Data Studio, SAS Data Management Studio and SAS Data Warehouse. This product / group of products can be defined by the following functionalities:

Are you curious about all the functions (100+) of SAS Data Integration? Download the ETL & Data Integration Guide™ 2022 here.

Do you want to hire an experienced SAS Data Integration specialist?

Do you want to hire an interim SAS Data Integration specialist who can do a mountain of work for you and can help you to implement an SAS Data Integration application? Or do you want to develop an application for one of the related products like SAS Data Integration Studio, SAS Data Integration Server, SAS Data Management, SAS/ACCESS, SAS Data Quality, SAS Data Quality Server, SAS Viya, SAS Clinical Data Integration, sas platform and SAS DI Studio? You can do so using our interim services. Indeed, hiring SAS Data Integration developers is not always expedient. Drop a message here and we’ll get back to you quickly.

Screen shot of SAS Data Integration software.
Picture of SAS Data Integration tools.
SAS Data Integration in action
Figure 2, 3 and 4: Various figures show the operation of SAS Data Integration. Click on the image to make it bigger.

What is SAS Viya?

In this paragraph, we provide a description of SAS Viya, including some of its features and any related products. This product / group of products can be defined by the following characteristics:

Are you curious about all features (100+) of SAS Viya? Open the ETL & Data Integration Guide™ 2022 here.

Screen shot of SAS Viya software.
Picture of SAS Viya tools.
SAS Viya in action
Figure 5, 6 and 7: These three images give a first impression of SAS Viya. Click on an image to enlarge it.

What is SAS Data Integration Studio?

This product is also known as: SAS ETL Studio, SAS DI Studio

In this paragraph, we provide a description of SAS Data Integration Studio, including some of its features and any related products. This product / group of products can be best characterized by the following properties:

Do you want to know everything about all properties (100+) of SAS Data Integration Studio? Then download our ETL & Data Integration Guide™ 2022 here.

What is SAS/ACCESS?

In this paragraph, we provide a description of SAS/ACCESS, including some of its features and any related products. This product / group of products can be best defined by the following features:

Are you curious about all the functions (100+) of SAS/ACCESS? Open the ETL & Data Integration Guide™ 2022 here.

Screen shot of SAS/ACCESS software.
Picture of SAS/ACCESS tools.
SAS/ACCESS in action
Figure 8, 9 and 10: Overlying images illustrate the functionality of SAS/ACCESS. Click on an image to enlarge it.

What is SAS Dataflux Data Management?

This product is also known as: Dataflux

In this paragraph, we describe SAS Dataflux Data Management, including some of its features and any related products. This product can be defined by the following properties:

Are you curious about all the functionalities (100+) of SAS Dataflux Data Management? Download the ETL & Data Integration Guide™ 2022 here.

What is SAS Data Quality?

In this section, we provide a description of SAS Data Quality, including some of its features and any related products. This product group consists of SAS Data Quality Server and SAS Data Quality Accelerator. This product / group of products can be best characterized by the following properties:

Are you curious about all the functions (100+) of SAS Data Quality? Then order the ETL & Data Integration Guide™ 2022 here.

Screen shot of SAS Data Quality software.
Picture of SAS Data Quality tools.
SAS Data Quality in action
Figure 11, 12 and 13: Several images show the operation of SAS Data Quality. Click on the image to make it bigger.

What is SAS Data Quality Server?

In this paragraph, we provide a description of SAS Data Quality Server, including some of its features and any related products. The product SAS Data Quality Server can be best characterized by the following functionalities:

Are you curious about all the functions (100+) of SAS Data Quality Server? Then download our ETL & Data Integration Guide™ 2022 here.

What is SAS Data Quality Accelerator?

In this paragraph, we provide a description of SAS Data Quality Accelerator, including some of its features and any related products. SAS Data Quality Accelerator can be characterized by the following features:

Do you want to know the intricacies of all features (100+) of SAS Data Quality Accelerator? Download the ETL & Data Integration Guide™ 2022 here.

What is SAS Data Management?

In this paragraph, we provide a description of SAS Data Management, including some of its features and any related products. This product can be characterized by the following characteristics:

Are you now curious about all the functionalities (100+) of SAS Data Management? Then download our ETL & Data Integration Guide™ 2022 here.

Screen shot of SAS Data Management software.
Picture of SAS Data Management tools.
SAS Data Management in action
Figure 14, 15 and 16: Various figures show the operation of SAS Data Management. Click on an image to enlarge it.

What is SAS LASR Analytic Server?

This product is also known as: LASR

In this paragraph, we describe the key elements of SAS LASR Analytic Server, including some of its features and any related products. This product can be characterized by the following features:

Are you curious about all properties (100+) of SAS LASR Analytic Server? Then download our ETL & Data Integration Guide™ 2022 here.

Screen shot of SAS LASR Analytic Server software.
Picture of SAS LASR Analytic Server tools.
SAS LASR Analytic Server in action
Figure 17, 18 and 19: Several images show the operation of SAS LASR Analytic Server. Click on an image to enlarge it.

What is SAS Metadata Server?

We do not display here all the features but, in this paragraph, we provide a description of SAS Metadata Server, including some of its features and any related products. This product can be characterized by the following features:

Do you want to know everything about all the functionalities (100+) of SAS Metadata Server? Then download our ETL & Data Integration Guide™ 2022 here.

Screen shot of SAS Metadata Server software.
Picture of SAS Metadata Server tools.
SAS Metadata Server in action
Figure 20, 21 and 22: Overlying figures show the operation of SAS Metadata Server. Click on an image to enlarge it.

What is SAS ETL?

In this paragraph, we describe SAS ETL, including some of its features and any related products. This product / group of products can be defined by the following features:

Do you want to know the intricacies of all the functionalities (100+) of SAS ETL? Then download our ETL & Data Integration Guide™ 2022 here.

What is SAS Business Rules Manager?

In this section, we portrait SAS Business Rules Manager, including some of its features and any related products. The SAS Business Rules Manager can be characterized by the following features:

Do you want to know the intricacies of all the functionalities (100+) of SAS Business Rules Manager? In that case order the ETL & Data Integration Guide™ 2022 here.

What is SAS Data Loader?

Under this heading, we give you insight in the key behaviors of SAS Data Loader, including some of its features and any related products. The SAS Data Loader can be best defined by the following characteristics:

Are you curious about all the functionalities (100+) of SAS Data Loader? Download directly our ETL & Data Integration Guide™ 2022 here.

Screen shot of SAS Data Loader software.
Picture of SAS Data Loader tools.
SAS Data Loader in action
Figure 23, 24 and 25: Various figures show the operation of SAS Data Loader. Click on an image to enlarge it.

What is SAS Clinical Data Integration?

We do not display here all the features but, in this paragraph, we describe the key elements of SAS Clinical Data Integration, including some of its features and any related products. The product SAS Clinical Data Integration can be best characterized by the following functionalities:

Do you want to know everything about all elements (100+) of SAS Clinical Data Integration? Then order the ETL & Data Integration Guide™ 2022 here.

What is SAS Data Preparation?

We do not display here all the features but, in this paragraph, we give you insight in the key behaviors of SAS Data Preparation, including some of its features and any related products. This product / group of products can be characterized by the following functionalities:

Do you want to know everything about all characteristics (100+) of SAS Data Preparation? Download the ETL & Data Integration Guide™ 2022 here.

Screen shot of SAS Data Preparation software.
Picture of SAS Data Preparation tools.
SAS Data Preparation in action
Figure 26, 27 and 28: Various figures show the operation of SAS Data Preparation. Click on the image to magnify.

What is SAS Data Surveyor?

We do not display here all the features but, in this paragraph, we provide a description of SAS Data Surveyor, including some of its features and any related products. The SAS Data Surveyor can be defined by the following characteristics:

Are you now curious about all features (100+) of SAS Data Surveyor? In that case order the ETL & Data Integration Guide™ 2022 here.

Screen shot of SAS Data Surveyor software.
Picture of SAS Data Surveyor tools.
SAS Data Surveyor in action
Figure 29, 30 and 31: These three images give a first impression of SAS Data Surveyor. Click on the image to magnify.

What is SAS Data Governance?

In this paragraph, we report the (main) characteristics of SAS Data Governance, including some of its features and any related products. This product can be characterized by the following characteristics:

Do you want to know everything about all properties (100+) of SAS Data Governance? In that case order the ETL & Data Integration Guide™ 2022 here.

Screen shot of SAS Data Governance software.
Picture of SAS Data Governance tools.
SAS Data Governance in action
Figure 32, 33 and 34: Overlying images illustrate the functionality of SAS Data Governance. Click on the image to magnify.

What is SAS Data Integration Server?

Under this heading, we report the (main) characteristics of SAS Data Integration Server, including some of its features and any related products. This product group consists of SAS Enterprise Data Integration Server. The SAS Data Integration Server can be defined by the following characteristics:

Are you now curious about all elements (100+) of SAS Data Integration Server? Then download our ETL & Data Integration Guide™ 2022 here.

What is SAS Enterprise Data Integration Server?

This product is also known as: Enterprise Data Integration Server

We don’t reveal everything here but, in this paragraph, we describe SAS Enterprise Data Integration Server, including some of its features and any related products. The product SAS Enterprise Data Integration Server can be characterized by the following features:

Are you now curious about all elements (100+) of SAS Enterprise Data Integration Server? Download the ETL & Data Integration Guide™ 2022 here.

What is SAS OLAP Server?

In this section, we provide a description of SAS OLAP Server, including some of its features and any related products. This product can be best characterized by the following characteristics:

Do you want to know everything about all the functionalities (100+) of SAS OLAP Server? Download the ETL & Data Integration Guide™ 2022 here.

What is SAS Metadata Bridge?

In this paragraph, we report the (main) characteristics of SAS Metadata Bridge, including some of its features and any related products. The product SAS Metadata Bridge can be best defined by the following characteristics:

Do you want to know the intricacies of all properties (100+) of SAS Metadata Bridge? Download directly our ETL & Data Integration Guide™ 2022 here.

What is SAS Data Explorer?

We don’t reveal everything here but, in this paragraph, we describe the key elements of SAS Data Explorer, including some of its features and any related products. SAS Data Explorer can be defined by the following functionalities:

Do you want to know everything about all properties (100+) of SAS Data Explorer? Download the ETL & Data Integration Guide™ 2022 here.

Screen shot of SAS Data Explorer software.
Picture of SAS Data Explorer tools.
SAS Data Explorer in action
Figure 35, 36 and 37: Several images show the operation of SAS Data Explorer. Click on an image to enlarge it.

What is SAS Data Studio?

We do not display here all the features but, in this paragraph, we report the (main) characteristics of SAS Data Studio, including some of its features and any related products. This product can be characterized by the following properties:

Are you curious about all characteristics (100+) of SAS Data Studio? Download directly our ETL & Data Integration Guide™ 2022 here.

Screen shot of SAS Data Studio software.
Picture of SAS Data Studio tools.
SAS Data Studio in action
Figure 38, 39 and 40: Overlying images illustrate the functionality of SAS Data Studio. Click on the image to magnify.

What is SAS Data Management Studio?

Under this heading, we describe SAS Data Management Studio, including some of its features and any related products. SAS Data Management Studio can be best characterized by the following functionalities:

Do you want to know everything about all the functions (100+) of SAS Data Management Studio? Download directly our ETL & Data Integration Guide™ 2022 here.

Screen shot of SAS Data Management Studio software.
Picture of SAS Data Management Studio tools.
SAS Data Management Studio in action
Figure 41, 42 and 43: Overlying figures show the operation of SAS Data Management Studio. Click on the image to enlarge it.

What is SAS Data Warehouse?

In this section, we describe the key elements of SAS Data Warehouse, including some of its features and any related products. This product can be characterized by the following functionalities:

Are you now curious about all characteristics (100+) of SAS Data Warehouse? Download the ETL & Data Integration Guide™ 2022 here.

Innovations of SAS Data Integration-tools and the version history

Lately, we see a stable development in terms of ETL & Data Integration functionality and support for various platforms and data sources. The latest innovations are in the areas of > data connectivity, data infrastructure > cloud platforms and data infrastructure > microservice > microservices architecture.

We investigated SAS’s latest updates of its product portfolio. Below you can see the successive versions of all the known versions of the ETL & Data Integration products of SAS:

Behind each product we mention the version numbers, the list is ordered by time.

Can you easily determine the licensing costs of SAS Viya, SAS Data Integration Studio and SAS/ACCESS?

In many cases, it can be difficult to determine the licensing costs of SAS ETL & Data Integration because it depends on the country, the number of users (or the number of CPUs in the case of server software), the connectors to data sources, and at what point in the year you request a quote. If you do this a few weeks before the end of SAS’s fiscal quarter, you may be in for a decent discount. In addition, nowadays it is recommended running the software in the cloud. You then only pay for what you actually use in resources. The purchase cost of SAS Viya, SAS Data Integration Studio and SAS/ACCESS may not be the single largest expense, but maintenance and support do show up in your budget every year.

What makes SAS ETL & Data Integration worth considering

In our study, we see that SAS in the field of ETL & Data Integration software has a few specific features which are worth weighing in a tool selection. This makes SAS Data Integration more or less unique: big data preparation, sql join, left join, data integration projects and self-service data preparation.

The advantages and disadvantages of SAS Data Integration

Tag cloud of the SAS Data Integration software.Figure 44: Tag cloud of the pluses and minuses of SAS ETL & Data Integration

In the following paragraphs, we name all the pros and cons of SAS ETL & Data Integration, SAS Viya, SAS Data Integration Studio and SAS/ACCESS, et cetera. These are not necessarily definitive because: SAS can currently work on improving current functions and adding a new functionality that closes the gaps in the product portfolio. Or a certain feature is not (yet) (well) documented.

Share your experience

Leave a review about SAS ETL & Data Integration here. Your experiences can then start to count in an even better assessment of the performance of SAS Data Integration.

1. SAS Data Connectivity

100%

SAS has an excellent score in our objective ETL & Data Integration survey on the subject ‘Data Connectivity’ (for this section SAS comes out as the absolute market leader in our research), given that they score 100% on this, compared to other vendors. We considered the following factors: sql server, salesforce, mysql, redshift, AWS, microsoft sql server and amazon redshift. In total, we examined 49 criteria in this category. Would you like to go into more depth with the subject ‘Data Connectivity’? Then download here our ETL & Data Integration Guide.

2. SAS Data Management

100%

The vendor SAS has an excellent score in our 100% vendor-independent ETL & Data Integration survey of the theme ‘Data Management’ (for this section SAS comes out as the absolute market leader in our research), given that they score 100% on this, relative to other vendors. We considered the following factors: CDC, data sources and scheduling. In doing so, we looked at the following five products: SAS Data Management, SAS Data Quality, SAS Viya, SAS Data Integration and SAS Data Management Studio. In total, we examined 71 features within this discipline. Are you excited about the subject ‘Data Management’? Then download here our ETL & Data Integration Study 2022.

3. SAS Data Governance

97%

The vendor SAS has an excellent score in our independent ETL & Data Integration survey of the theme ‘Data Governance’, given that they score 97% on this, compared to other vendors. We looked at the following criteria, among others: dataops, data protection, data privacy, test data and data anonymization. In doing so, we analyzed the following four products: SAS Data Governance, SAS Data Quality, SAS Data Management and SAS Dataflux Data Management. In total, we examined 12 criteria within this section. Would you like to learn more about the subject ‘Data Governance’? Then download here our ETL & Data Integration Guide.

4. SAS Data Infrastructure

95%

The company has an excellent rating in our independent ETL & Data Integration survey on the subject ‘Data Infrastructure’ with a score of 95%, relative to other vendors. We looked at the following criteria, among others: security, rest API, SDK, open source, operating system, SOA and sandbox. In total, we examined 91 criteria in this category. Would you like to become more proficient in the subject ‘Data Infrastructure’? Then download here our ETL & Data Integration Guide 2022. Or learn more about the following topics:

5. SAS Data Quality Management

92%

SAS has an excellent rating in our study on the subject ‘Data Quality Management’ with a score of 92%, compared to other vendors. We considered the following factors: data quality, data profiling and business rules. In doing so, we looked at the following two products: SAS Data Quality and SAS Data Management. In total, we examined 29 aspects in this category. Would you like to go into more depth with the subject ‘Data Quality Management’? Then download here our ETL & Data Integration Guide.

6. SAS Data Integration

91%

SAS has an excellent performance in our 100% vendor-independent ETL & Data Integration survey of the theme ‘Data Integration’, given that they score 91% on this, compared to other vendors. We looked at the following criteria, among others: ETL, data warehouse and data flow. In doing so, we studied the following five products: SAS Data Integration, SAS Data Integration Studio, SAS Clinical Data Integration, SAS ETL and SAS Data Integration Server. In total, we examined 171 features within this discipline. Are you excited about the subject ‘Data Integration’? Then download here our ETL & Data Integration Study 2022. Or learn more about the following topics:

7. SAS Metadata Management

83%

SAS has an excellent rating in our independent ETL & Data Integration survey on the subject ‘Metadata Management’ with a score of 83%, relative to other vendors. The following criteria were used: metadata, data catalog and data lineage. In doing so, we analyzed the following products: SAS Data Integration Studio. In total, we examined 7 criteria within this section. Would you like to learn more about the subject ‘Metadata Management’? Then download here our ETL & Data Integration Study 2022.

8. SAS Self-service Integration

80%

The company has an excellent performance in our study on the section ‘Self-service Integration’. The score amounts to 80%, relative to other vendors. We considered the following factors: self-service data preparation, self-service data integration and self-service data warehouse. In total, we examined 8 criteria in this category. Would you like to go into more depth with the subject ‘Self-service Integration’? Then download here our ETL & Data Integration Guide 2022.

9. SAS Data Replication

53%

The company has a good performance in our objective ETL & Data Integration survey on the section ‘Data Replication’, given that they score 53% on this, relative to other vendors. We considered the following factors: data synchronization, database replication and sql replication. In total, we examined 32 features within this discipline. Would you like to learn more about the subject ‘Data Replication’? Then download here our ETL & Data Integration Study.

10. SAS Master Data Management

50%

The vendor SAS has a good rating in our current ETL & Data Integration survey on the subject ‘Master Data Management’, given that they score 50% on this, compared to other vendors. We looked at the following criteria, among others: master data, master data integration, master data quality and master data replication. In doing so, we analyzed the following four products: SAS Data Management, SAS Data Governance, SAS Data Management Studio and SAS Dataflux Data Management. In total, we examined 17 criteria in this category. Are you planning to specialize further in the subject ‘Master Data Management’? Then download here our ETL & Data Integration Guide. Or learn more about the following topics:

The footprint of SAS ETL & Data Integration in different sectors

In our vendor-neutral ETL study, we also looked at which industries a software vendor moves to. These are the industries where SAS is most popular: banking, education, energy, financial services, governments, health care, higher education, insurance, public sector, retail and telecom.

SAS software is most used by…

The ETL & Data Integration software from SAS is most often mentioned in combination with the following functions: business analysts, data integration developer and ETL developer.

Courses and training SAS ETL & Data Integration

The specialists of Passionned Group organize various classes in the area of ETL & Data Integration but can also provide specific SAS training, for example as incompany. For example, you can think about the following software: SAS Viya, SAS Data Integration Studio and SAS/ACCESS. Of course, such training is framed with the ideas of the intelligent, data-driven organization.

In conclusion: SAS Data Integration scores eminent

SAS has a extensive product portfolio with which it scores eminent in our ETL & Data Integration survey. SAS ETL & Data Integration innovates (approximately) at an average rate of less than 5 features per year, is active (for now) in many different sectors, and has developed best in data connectivity.

About Passionned Group

logo of Passionned Group, the SAS ETL & Data Integration specialistPassionned Group has specialized in 100% independent ETL & Data Integration consulting and the implementation of ETL & Data Integration solutions. We help small and larger organizations to advance as a smart, data-driven business.

Get in touch with us

A selection of our customers

Become a customer with us now

Do you also want to become a customer of ours? We are happy to help you with data-driven working or other things that will make you smarter.

Daan van Beek - Business Partner

DAAN VAN BEEK MSc

Business Partner

Contact me directly

Fact sheet

Number of organizations serviced
___
Number of training courses
___
Number of participants trained
___
Overall customer rating
8.9
Number of consultants & teachers
___
Number of offices
3
Number of years active
17
EDIT POST