Passionned Group™

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 comes out on top in our research. SAS is vigorous in data infrastructure and the least strong in data replication. 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.

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
Open Table of Contents

Independent information about SAS Viya, SAS Data Integration Studio and SAS/ACCESS


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 2023. Do you want to know more about the design of our research? Check out our buyers guide for ETL & Data Integration.

In our comprehensive research 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 to the right 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 2,418 documents further we know that SAS excels in data infrastructure. 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) 27 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 Surveyor, SAS Data Preparation, SAS OLAP Server, SAS Data Governance, SAS Data Integration Server, SAS Data Explorer, SAS Data Studio, SAS Metadata Bridge, SAS Data Management Studio, SAS Data Warehouse and SAS Lineage. 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™ 2023 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 Server, SAS Data Quality, SAS Clinical Data Integration, Dataflux, SAS Data Preparation 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™ 2023 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™ 2023 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™ 2023 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™ 2023 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™ 2023 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™ 2023 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™ 2023 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™ 2023 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™ 2023 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™ 2023 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™ 2023 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™ 2023 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™ 2023 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™ 2023 here.

What is SAS Data Surveyor?

We do not display here all the features but, in this paragraph, we give you insight in the key behaviors of SAS Data Surveyor, 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 Surveyor? Download the ETL & Data Integration Guide™ 2023 here.

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

What is SAS Data Preparation?

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

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

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

What is SAS OLAP Server?

In this paragraph, we report the (main) characteristics of SAS OLAP Server, 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 OLAP Server? In that case order the ETL & Data Integration Guide™ 2023 here.

What is SAS Data Governance?

Under this heading, we report the (main) characteristics of SAS Data Governance, including some of its features and any related products. The SAS Data Governance can be defined by the following characteristics:

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

Screen shot of SAS Data Governance software.
Picture of SAS Data Governance tools.
SAS Data Governance in action
Figure 32, 33 and 34: These three images give a first impression of SAS Data Governance. Click on the image to magnify.

What is SAS Data Integration Server?

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

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

What is SAS Enterprise Data Integration Server?

This product is also known as: Enterprise Data Integration Server

In this section, we provide a description of SAS Enterprise Data Integration 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 Enterprise Data Integration Server? Download the ETL & Data Integration Guide™ 2023 here.

What is SAS Data Explorer?

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

Do you want to know the intricacies of all properties (100+) of SAS Data Explorer? Download directly our ETL & Data Integration Guide™ 2023 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 the image to make it bigger.

What is SAS Data Studio?

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

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

Screen shot of SAS Data Studio software.
Picture of SAS Data Studio tools.
SAS Data Studio in action
Figure 38, 39 and 40: Several images show the operation of SAS Data Studio. Click on an image to enlarge it.

What is SAS Metadata Bridge?

We do not display here all the features but, in this paragraph, we report the (main) characteristics of SAS Metadata Bridge, 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 Metadata Bridge? Download directly our ETL & Data Integration Guide™ 2023 here.

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™ 2023 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™ 2023 here.

What is SAS Lineage?

We do not display here all the features but, in this paragraph, we describe SAS Lineage, including some of its features and any related products. This product / group of products can be best defined by the following characteristics:

Are you curious about all characteristics (100+) of SAS Lineage? In that case order the ETL & Data Integration Guide™ 2023 here.

Screen shot of SAS Lineage software.
Picture of SAS Lineage tools.
SAS Lineage in action
Figure 44, 45 and 46: Several images show the operation of SAS Lineage. Click on the image to enlarge it.

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, self-service integration > self-service data integration and data integration > data flow > process flow diagrams.

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: cloud platforms, data integration projects, ods and big data management.

The advantages and disadvantages of SAS Data Integration

Tag cloud of the SAS Data Integration software.Figure 47: 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 (such as support for cloud data integration). 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 Infrastructure

100%

SAS has an excellent score in our objective ETL & Data Integration survey on the subject ‘Data Infrastructure’ (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: security, rest API, SDK, open source, operating system, SOA and sandbox. In total, we examined 87 criteria in this category. Would you like to go into more depth with the subject ‘Data Infrastructure’? Then download here our ETL & Data Integration Guide.

2. SAS Self-service Integration

100%

The vendor SAS has an excellent score in our 100% vendor-independent ETL & Data Integration survey of the theme ‘Self-service Integration’ (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: self-service data preparation, self-service data integration and self-service data warehouse. In total, we examined 8 features within this discipline. Are you excited about the subject ‘Self-service Integration’? Then download here our ETL & Data Integration Study 2023.

3. SAS Data Connectivity

97%

The vendor SAS has an excellent score in our independent ETL & Data Integration survey of the theme ‘Data Connectivity’, given that they score 97% on this, compared to other vendors. We looked at the following criteria, among others: sql server, salesforce, redshift, mysql, AWS, microsoft sql server and amazon redshift. In total, we examined 49 criteria within this section. Would you like to learn more about the subject ‘Data Connectivity’? Then download here our ETL & Data Integration Guide.

4. SAS Data Management

96%

The company has an excellent rating in our independent ETL & Data Integration survey on the subject ‘Data Management’ with a score of 96%, relative to other vendors. We looked at the following criteria, among others: data sources, scheduling, data pipelines, source table, streaming data, database containers and automated data processing. In doing so, we investigated the following five products: SAS Data Integration, SAS Data Integration Studio, SAS Data Management, SAS Data Integration Server and SAS ETL. In total, we examined 71 criteria in this category. Would you like to become more proficient in the subject ‘Data Management’? Then download here our ETL & Data Integration Guide 2023. Or learn more about the following topics:

5. SAS Data Integration

87%

SAS has an excellent rating in our study on the subject ‘Data Integration’ with a score of 87%, compared to other vendors. We considered the following factors: ETL, data warehouse and data flow. In doing so, we looked at the following five products: SAS Data Integration, SAS Data Integration Studio, SAS Clinical Data Integration, SAS Data Management and SAS Data Integration Server. In total, we examined 169 aspects in this category. Would you like to go into more depth with the subject ‘Data Integration’? Then download here our ETL & Data Integration Guide.

6. SAS Data Quality Management

83%

SAS has an excellent performance in our 100% vendor-independent ETL & Data Integration survey of the theme ‘Data Quality Management’, given that they score 83% on this, compared to other vendors. We looked at the following criteria, among others: data quality, data profiling and business rules. In doing so, we studied the following two products: SAS Data Management and SAS Data Quality. In total, we examined 28 features within this discipline. Are you excited about the subject ‘Data Quality Management’? Then download here our ETL & Data Integration Study 2023. Or learn more about the following topics:

7. SAS Data Governance

71%

SAS has a good rating in our independent ETL & Data Integration survey on the subject ‘Data Governance’ with a score of 71%, relative to other vendors. The following criteria were used: dataops, data protection and data privacy. In doing so, we analyzed the following five products: SAS Data Integration, SAS Data Management, SAS Data Integration Server, SAS Enterprise Data Integration Server and SAS Data Governance. In total, we examined 11 criteria within this section. Would you like to learn more about the subject ‘Data Governance’? Then download here our ETL & Data Integration Study 2023.

8. SAS Metadata Management

68%

The company has a good performance in our study on the section ‘Metadata Management’. The score amounts to 68%, relative to other vendors. We considered the following factors: metadata, data catalog and data lineage. In doing so, we investigated the following three products: SAS Data Integration, SAS Data Integration Studio and SAS Metadata Bridge. In total, we examined 7 criteria in this category. Would you like to go into more depth with the subject ‘Metadata Management’? Then download here our ETL & Data Integration Guide 2023. Or learn more about the following topics:

9. SAS Master Data Management

33%

The company has a moderate performance in our objective ETL & Data Integration survey on the section ‘Master Data Management’, given that they score 33% on this, relative to other vendors. We considered the following factors: master data, MDG and master data integration. In doing so, we looked at the following five products: SAS Data Management, SAS Data Governance, SAS Data Quality, SAS Data Quality Server and SAS Data Management Studio. In total, we examined 16 features within this discipline. Would you like to learn more about the subject ‘Master Data Management’? Then download here our ETL & Data Integration Study.

10. SAS Data Replication

28%

The vendor SAS has a poor rating in our current ETL & Data Integration survey on the subject ‘Data Replication’, given that they score 28% on this, compared to other vendors. We looked at the following criteria, among others: data synchronization, database replication, sql replication and transactional replication. In total, we examined 32 criteria in this category. Are you planning to specialize further in the subject ‘Data Replication’? Then download here our ETL & Data Integration Guide.

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, food, governments, health care, higher education, insurance, logistics, 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.

Hire SAS consultant

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 more than 15 features per year, is active (for now) in lots of different sectors, and has developed best in data infrastructure.

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
9.3
Number of consultants & teachers
___
Number of offices
3
Number of years active
18