SAS ETL & Data Integration

Photo Daan van Beek
Author: Daan van Beek
SAS ETL expert
Table of Contents

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 Microsoft but quite worse than Informatica. Of all the categories in our research, SAS has the best performance in data management and scored the lowest on 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 their most popular products like SAS Viya, SAS Data Integration Studio, and SAS/ACCESS et cetera.

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

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, compared to other ETL & Data Integration tools. 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.

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

The SAS analysis was made possible by tapping into a lot of public big data and from there analyzed in-depth. More than 2,656 documents further we know that SAS excels in data management. In this analysis process, both AI models and a senior expert had a crucial role in finalizing the validation process.The ETL & Data Integration Guide 2024 Image of The ETL & Data Integration Guide 2024In our 100% vendor-neutral ETL & Data Integration Guide we have researched all the ins and outs of SAS for you. You will get access to many (short) courses, tutorials, tech talks, lectures, demos, and always have the latest ETL & Data Integration news at your fingertips. In addition, this guide will help you deepen your expertise in ETL & Data Integration.SAS in our ETL & Data Integration Guide

SAS and their complete ETL & Data Integration product portfolio

The vendor SAS has (a minimum of) 28 products in the field of ETL & Data Integration. Here, we list the most important products in order of popularity:

What is SAS Data Integration?

We do not display all the features here 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 Data Loader, SAS Business Rules Manager, SAS Data Preparation, SAS Clinical Data Integration, SAS Data Surveyor, 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, SAS Lineage, and SAS Event Stream Processing. This product/group of products can be defined by the following functionalities:

  • data cleansing
  • data integration
  • data marts
  • data sources
  • ELT
  • ETL
  • GIT
  • metadata
  • metadata management
  • SOA

Are you curious about all the functions (100+) of SAS Data Integration? Download the ETL & Data Integration Guide™ 2024 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 a beautiful SAS Data Integration application? 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
Figures 2, 3 and 4: Various figures show the operation of SAS Data Integration. Click on the image to make it bigger. Credits: SAS & partners.

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:

  • authentication
  • data management
  • data privacy
  • interoperability
  • master data
  • native cloud
  • open source
  • PDF
  • security
  • self-service data preparation

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

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

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:

  • data cleansing
  • data integration
  • data marts
  • data sources
  • ELT
  • ETL
  • job editor
  • metadata
  • metadata management
  • SOA

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

Screen shot of SAS Data Integration Studio software.
Picture of SAS Data Integration Studio tools.
SAS Data Integration Studio in action
Figures 8, 9 and 10: Overlying images illustrate the functionality of SAS Data Integration Studio. Click on the image to make it bigger. Credits: SAS & partners.

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:

  • data sources
  • hadoop
  • JDBC
  • linux
  • ODBC
  • salesforce
  • solaris
  • SQL
  • sql server
  • windows

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

Screen shot of SAS/ACCESS software.
Picture of SAS/ACCESS tools.
SAS/ACCESS in action
Figures 11, 12 and 13: Overlying images illustrate the functionality of SAS/ACCESS. Click on an image to enlarge it. Credits: SAS & partners.

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:

  • data governance
  • data integration
  • data management
  • data profiling
  • data quality
  • data sources
  • hadoop
  • master data
  • master data management
  • ODBC

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

Screen shot of SAS Dataflux Data Management software.
Picture of SAS Dataflux Data Management tools.
SAS Dataflux Data Management in action
Figures 14, 15 and 16: Overlying images illustrate the functionality of SAS Dataflux Data Management. Click on an image to magnify. Credits: SAS & partners.

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:

  • business rules
  • cloud data integration
  • data governance
  • data integration
  • data management
  • data quality
  • data quality management
  • data sources
  • hadoop
  • metadata

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

Screen shot of SAS Data Quality software.
Picture of SAS Data Quality tools.
SAS Data Quality in action
Figures 17, 18 and 19: Several images show the operation of SAS Data Quality. Click on the image to make it bigger. Credits: SAS & partners.

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:

  • big data
  • data cleansing
  • data integration
  • data management
  • data quality
  • data sources
  • metadata
  • security
  • SQL
  • sql server

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

Screen shot of SAS Data Quality Server software.
Picture of SAS Data Quality Server tools.
SAS Data Quality Server in action
Figures 20, 21 and 22: Overlying figures show the operation of SAS Data Quality Server. Click on an image to enlarge it. Credits: SAS & partners.

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:

  • big data
  • data integrity
  • data quality
  • data quality management
  • hadoop
  • metadata
  • PDF
  • security
  • SQL
  • teradata

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

Screen shot of SAS Data Quality Accelerator software.
Picture of SAS Data Quality Accelerator tools.
SAS Data Quality Accelerator in action
Figures 23, 24 and 25: Overlying figures show the operation of SAS Data Quality Accelerator. Click on the image to make it bigger. Credits: SAS & partners.

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/group of products can be characterized by the following characteristics:

  • big data
  • data governance
  • data integration
  • data management
  • data quality
  • data warehouse
  • hadoop
  • master data
  • master data management
  • metadata

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

Screen shot of SAS Data Management software.
Picture of SAS Data Management tools.
SAS Data Management in action
Figures 26, 27 and 28: Various figures show the operation of SAS Data Management. Click on an image to enlarge it. Credits: SAS & partners.

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:

  • apache
  • apache hadoop
  • hadoop
  • metadata

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

Screen shot of SAS LASR Analytic Server software.
Picture of SAS LASR Analytic Server tools.
SAS LASR Analytic Server in action
Figures 29, 30 and 31: Several images show the operation of SAS LASR Analytic Server. Click on an image to enlarge it. Credits: SAS & partners.

What is SAS Metadata Server?

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

  • data management
  • metadata
  • metadata repository
  • operating system
  • security
  • windows
  • z/os

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

Screen shot of SAS Metadata Server software.
Picture of SAS Metadata Server tools.
SAS Metadata Server in action
Figures 32, 33 and 34: Overlying figures show the operation of SAS Metadata Server. Click on an image to enlarge it. Credits: SAS & partners.

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:

  • big data
  • data integration
  • data management
  • data sources
  • data warehouse
  • ETL
  • fact table
  • interoperability
  • metadata
  • SQL

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

Screen shot of SAS ETL software.
Picture of SAS ETL tools.
SAS ETL in action
Figures 35, 36 and 37: Overlying images illustrate the functionality of SAS ETL. Click on the image to make it bigger. Credits: SAS & partners.

What is SAS Data Loader?

In this section, we portray SAS Data Loader, including some of its features and any related products. SAS Data Loader can be characterized by the following features:

  • apache
  • big data
  • data integration
  • data quality
  • hadoop
  • JDBC
  • PDF
  • security
  • source table
  • windows

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

Screen shot of SAS Data Loader software.
Picture of SAS Data Loader tools.
SAS Data Loader in action
Figures 38, 39 and 40: Overlying figures show the operation of SAS Data Loader. Click on an image to enlarge it. Credits: SAS & partners.

What is SAS Business Rules Manager?

Under this heading, we give you insight into the key behaviors of SAS Business Rules Manager, including some of its features and any related products. This product can be best defined by the following characteristics:

  • business rules
  • data integration
  • data management
  • metadata
  • PDF
  • security

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

Screen shot of SAS Business Rules Manager software.
Picture of SAS Business Rules Manager tools.
SAS Business Rules Manager in action
Figures 41, 42 and 43: Various figures show the operation of SAS Business Rules Manager. Click on an image to enlarge it. Credits: SAS & partners.

What is SAS Data Preparation?

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

  • cloud data integration
  • data governance
  • data integration
  • data management
  • data quality
  • data sources
  • self-service data preparation

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

Screen shot of SAS Data Preparation software.
Picture of SAS Data Preparation tools.
SAS Data Preparation in action
Figures 44, 45 and 46: Overlying images illustrate the functionality of SAS Data Preparation. Click on the image to enlarge it. Credits: SAS & partners.

What is SAS Clinical Data Integration?

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

  • data cleansing
  • data integration
  • data management
  • data transformation
  • metadata
  • XML

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

Screen shot of SAS Clinical Data Integration software.
Picture of SAS Clinical Data Integration tools.
SAS Clinical Data Integration in action
Figures 47, 48 and 49: Various figures show the operation of SAS Clinical Data Integration. Click on the image to magnify. Credits: SAS & partners.

What is SAS Data Surveyor?

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

  • AIX
  • data integration
  • data replication
  • data sources
  • linux
  • metadata
  • operating system
  • salesforce
  • solaris
  • windows

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

Screen shot of SAS Data Surveyor software.
Picture of SAS Data Surveyor tools.
SAS Data Surveyor in action
Figures 50, 51 and 52: These three images give a first impression of SAS Data Surveyor. Click on the image to magnify. Credits: SAS & partners.

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:

  • apache
  • data quality
  • ETL
  • metadata
  • OLAP
  • OLAP cubes
  • operating system
  • security
  • solaris
  • SQL

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

Screen shot of SAS OLAP Server software.
Picture of SAS OLAP Server tools.
SAS OLAP Server in action
Figures 53, 54 and 55: Overlying images illustrate the functionality of SAS OLAP Server. Click on the image to magnify. Credits: SAS & partners.

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. SAS Data Governance can be defined by the following characteristics:

  • business rules
  • data governance
  • data management
  • data protection
  • data quality
  • hadoop

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

Screen shot of SAS Data Governance software.
Picture of SAS Data Governance tools.
SAS Data Governance in action
Figures 56, 57 and 58: These three images give a first impression of SAS Data Governance. Click on the image to magnify. Credits: SAS & partners.

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:

  • data integration
  • data management
  • data marts
  • data quality
  • data sources
  • data warehouse
  • linux
  • metadata
  • red hat
  • security

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

Screen shot of SAS Data Integration Server software.
Picture of SAS Data Integration Server tools.
SAS Data Integration Server in action
Figures 59, 60 and 61: Overlying images illustrate the functionality of SAS Data Integration Server. Click on the image to enlarge it. Credits: SAS & partners.

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:

  • apache
  • data governance
  • data integration
  • data management
  • data sources
  • linux
  • metadata
  • ODBC
  • solaris
  • windows

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

Screen shot of SAS Enterprise Data Integration Server software.
Picture of SAS Enterprise Data Integration Server tools.
SAS Enterprise Data Integration Server in action
Figures 62, 63 and 64: Several images show the operation of SAS Enterprise Data Integration Server. Click on an image to magnify. Credits: SAS & partners.

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:

  • data management
  • data preparation profiling
  • data sources
  • PDF
  • self-service data preparation
  • windows

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

Screen shot of SAS Data Explorer software.
Picture of SAS Data Explorer tools.
SAS Data Explorer in action
Figures 65, 66 and 67: Several images show the operation of SAS Data Explorer. Click on the image to make it bigger. Credits: SAS & partners.

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. The product SAS Data Studio can be defined by the following functionalities:

  • AWS
  • data integration
  • data management
  • data quality
  • data sources
  • google bigquery
  • metadata
  • PDF
  • real time
  • self-service data preparation

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

Screen shot of SAS Data Studio software.
Picture of SAS Data Studio tools.
SAS Data Studio in action
Figures 68, 69 and 70: Several images show the operation of SAS Data Studio. Click on an image to enlarge it. Credits: SAS & partners.

What is SAS Metadata Bridge?

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

  • data integration
  • data management
  • hadoop
  • impact analysis
  • metadata
  • ODBC
  • star schema
  • sybase
  • windows
  • windows server

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

Screen shot of SAS Metadata Bridge software.
Picture of SAS Metadata Bridge tools.
SAS Metadata Bridge in action
Figures 71, 72 and 73: Overlying images illustrate the functionality of SAS Metadata Bridge. Click on the image to magnify. Credits: SAS & partners.

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:

  • business rules
  • data flow
  • data management
  • data profiling
  • data quality
  • master data
  • PDF
  • windows

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

Screen shot of SAS Data Management Studio software.
Picture of SAS Data Management Studio tools.
SAS Data Management Studio in action
Figures 74, 75 and 76: Overlying figures show the operation of SAS Data Management Studio. Click on the image to enlarge it. Credits: SAS & partners.

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/group of products can be characterized by the following functionalities:

  • big data
  • BLOB
  • data management
  • data marts
  • data transformation
  • data warehouse
  • dimension tables
  • fact table
  • metadata
  • star schema

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

Screen shot of SAS Data Warehouse software.
Picture of SAS Data Warehouse tools.
SAS Data Warehouse in action
Figures 77, 78 and 79: Overlying images illustrate the functionality of SAS Data Warehouse. Click on an image to magnify. Credits: SAS & partners.

What is SAS Lineage?

We do not display all the features here 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:

  • API
  • authentication
  • data governance
  • data integration
  • data lineage
  • data management
  • impact analysis
  • metadata
  • rest API
  • teradata

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

Screen shot of SAS Lineage software.
Picture of SAS Lineage tools.
SAS Lineage in action
Figures 80, 81 and 82: Several images show the operation of SAS Lineage. Click on the image to enlarge it. Credits: SAS & partners.

What is SAS Event Stream Processing?

In this section, we display the details of SAS Event Stream Processing, including some of its features and any related products. This product/group of products can be best characterized by the following characteristics:

  • big data
  • BLOB
  • data sources
  • ETL
  • open source
  • real-time data
  • real time
  • security
  • streaming data
  • windows

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

Screen shot of SAS Event Stream Processing software.
Picture of SAS Event Stream Processing tools.
SAS Event Stream Processing in action
Figures 83, 84 and 85: Overlying images illustrate the functionality of SAS Event Stream Processing. Click on an image to magnify. Credits: SAS & partners.

Innovations of SAS Data Integration tools and the version history

Lately, we see a negative development in terms of ETL & Data Integration functionality and support for various platforms and data sources. The latest innovations are in the areas of > self-service integration, data integration > agile data integration, and data integration > data ingestion > big data ingestion.

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:

  • SAS Business Rules Manager: 3.3 3.2 3.1 2.2 2.1
  • SAS Clinical Data Integration: 2.63 2.6 2.5 2.2 2.1
  • SAS Data Explorer: 2.5 2.4 2.1
  • SAS Data Integration: March 07 360 9.4m7 9.4 9.3 9.2
  • SAS Data Integration Studio: 4.906 4.905 4.904 4.903 4.901 4.21 4.9 4.8 4.7m5 4.7 4.6 4.3 4.2 3.4
  • SAS Data Loader: 3.1m1 3.1 2.4 2.3 2.2 2.1
  • SAS Data Management: 2024
  • SAS Data Management Studio: 2.9
  • SAS Data Preparation: 2.5 2.2 2.1
  • SAS Data Quality: 3.4 3.3
  • SAS Data Quality Accelerator: 2.7 2.6 2.5
  • SAS Data Quality Server: 9.47 9.46 9.45 9.2
  • SAS Data Studio: 2.5 2.4 2.2 2.1
  • SAS Data Surveyor: 5.4 5.3 5.1 4.3 4.2
  • SAS Enterprise Data Integration Server: 2023 4.3
  • SAS Event Stream Processing: 6.2 3.1
  • SAS LASR Analytic Server: 2.83 2.8 2.6 1.6
  • SAS Lineage: 3.3 3.2 3.1
  • SAS Metadata Bridge: 71 69
  • SAS Metadata Server: 9.4
  • SAS OLAP Server: 9.4 9.1
  • SAS Viya: June 2024 2024.02 2021.1.4 2020.1.1 2020.1 3.5
  • SAS/ACCESS: 9.4

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 to run 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: database containers, data preparation profiling, self-service data management, big data governance, and data quality API.

The advantages and disadvantages of SAS Data Integration

Tag cloud of the SAS Data Integration software.Figure 86: 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 quickbooks, data synchronization, data lakehouses, real-time data replication, and self-service 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 Management

100%

SAS has an excellent score in our objective ETL & Data Integration survey on the subject ‘Data Management’ (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: data sources, scheduling, data pipelines, source table, streaming data, automated data processing, and database containers. In doing so, we analyzed the following five products: SAS Data Management, SAS Data Integration Server, SAS Enterprise Data Integration Server, SAS Data Governance, and SAS Data Quality. In total, we examined 71 criteria in this category. Would you like to go into more depth with the subject ‘Data Management’? Then download here our ETL & Data Integration Guide.

2. SAS Metadata Management

100%

The vendor SAS has an excellent score in our 100% vendor-independent ETL & Data Integration survey of the theme ‘Metadata 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: metadata, data catalog, and data lineage. In doing so, we looked at the following two products: SAS Data Integration and SAS Data Integration Studio. In total, we examined 7 features within this discipline. Are you excited about the subject ‘Metadata Management’? Then download here our ETL & Data Integration Study 2024. Or learn more about the following topics:

3. SAS Self-service Integration

97%

The vendor SAS has an excellent score in our independent ETL & Data Integration survey of the theme ‘Self-service Integration’, given that they score 97% on this, compared to other vendors. We looked at the following criteria, among others: self-service data preparation, self-service data integration, self-service data warehouse, self-service data management, self-service data quality, self-service data profiling, and self-service data cleansing. In total, we examined 8 criteria within this section. Would you like to learn more about the subject ‘Self-service Integration’? Then download here our ETL & Data Integration Guide.

4. SAS Data Infrastructure

96%

The company has an excellent rating in our independent ETL & Data Integration survey on the subject ‘Data Infrastructure’ with a score of 96%, 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 87 criteria in this category. Would you like to become more proficient in the subject ‘Data Infrastructure’? Then download here our ETL & Data Integration Guide 2024. Or learn more about the following topics:

5. SAS Data Integration

93%

SAS has an excellent rating in our study on the subject ‘Data Integration’ with a score of 93%, 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 167 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 Connectivity

90%

SAS has an excellent performance in our 100% vendor-independent ETL & Data Integration survey of the theme ‘Data Connectivity’, given that they score 90% on this, compared to other vendors. We looked at the following criteria, among others: sql server, hadoop, and salesforce. In total, we examined 50 features within this discipline. Are you excited about the subject ‘Data Connectivity’? Then download here our ETL & Data Integration Study 2024.

7. SAS Data Governance

81%

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

8. SAS Data Quality Management

79%

The company has a good performance in our study on the section ‘Data Quality Management’. The score amounts to 79%, relative to other vendors. We considered the following factors: data quality, data profiling, and business rules. In doing so, we investigated the following products: SAS Data Quality. In total, we examined 28 criteria 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 2024. Or learn more about the following topics:

9. SAS Master Data Management

32%

The company has a moderate performance in our objective ETL & Data Integration survey on the section ‘Master Data Management’, given that they score 32% 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 products: SAS Dataflux Data Management. 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

26%

The vendor SAS has a poor rating in our current ETL & Data Integration survey on the subject ‘Data Replication’, given that they score 26% 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.

Want to know more? Then take a look at our ETL & Data Integration Guide™ 2024 here

The footprint of SAS ETL & Data Integration in different sectors

In our vendor-neutral ETL study, we also found out which industries a software vendor specializes in. These are the industries where SAS is most popular: agriculture, airlines, governments, 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/roles: business users, data engineers, data integration developer, and data stewards.

Hire a qualified SAS consultant

Courses and training SAS ETL & Data Integration

The specialists at Passionned Group organize various classes in the area of ETL & Data Integration but can also provide specific SAS training, for instance as in-company. You will be trained, for example, in 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 relatively few sectors, and has developed best in data management.

About Passionned Group

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

Get in touch with us