SAS ETL & Data Integration

Business Partner
Author: Daan van Beek MSc
Business Partner
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 the 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 [survey name] 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 it was analyzed in-depth. More than 2,585 documents further we know that SAS excels in data management. In this analysis process both algorithms as a senior expert had a crucial role in finalizing the validation process.The ETL & Data Integration Guide The ETL & Data Integration GuideIn 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 so on and always have the latest ETL & Data Integration news at your fingertips. In addition, this guide helps you in deepening your expertise in ETL & Data Integration.SAS in our ETL & Data Integration Guide 2024

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

  • AWS
  • data integration
  • data sources
  • ELT
  • ETL
  • GIT
  • metadata
  • PDF
  • SOA
  • SQL

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 an 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
Figure 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:

  • API
  • authentication
  • data management
  • data quality
  • data transfer
  • interoperability
  • linux
  • open source
  • real time
  • 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
Figure 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 management
  • data sources
  • ELT
  • ETL
  • GIT
  • 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
Figure 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:

  • AIX
  • data sources
  • google bigquery
  • JDBC
  • mysql
  • ODBC
  • solaris
  • SQL
  • UNIX
  • 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
Figure 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:

  • API
  • data integration
  • data management
  • data profiling
  • data quality
  • data sources
  • master data
  • master data management
  • ODBC
  • rest API

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
Figure 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
  • data integration
  • data management
  • data quality
  • data quality management
  • data sources
  • hadoop
  • location data
  • metadata
  • teradata

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
Figure 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 quality
  • data cleansing
  • data integration
  • data management
  • data pipelines
  • data quality
  • data sources
  • metadata
  • 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
Figure 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
Figure 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 can be characterized by the following characteristics:

  • big data
  • cloud platforms
  • data integration
  • data management
  • data quality
  • data sources
  • master data
  • master data management
  • source table
  • teradata

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
Figure 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:

  • big data
  • linux
  • 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
Figure 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 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:

  • 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
Figure 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:

  • AWS
  • big data
  • data integration
  • data management
  • data sources
  • data warehouse
  • ETL
  • interoperability
  • metadata
  • teradata

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
Figure 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 portrait SAS Data Loader, including some of its features and any related products. The SAS Data Loader can be characterized by the following features:

  • apache
  • big data
  • data integration
  • data quality
  • hadoop
  • hadoop hive
  • PDF
  • self-service data preparation
  • 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
Figure 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 in the key behaviors of SAS Business Rules Manager, including some of its features and any related products. The SAS Business Rules Manager can be best defined by the following characteristics:

  • business rules
  • data integration
  • data management
  • hadoop
  • 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
Figure 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 here all the features 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
  • PDF
  • self-service data integration
  • self-service data preparation
  • streaming data

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
Figure 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 here all the features but, in this paragraph, we give you insight in 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:

  • business rules
  • 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
Figure 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 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:

  • data integration
  • data replication
  • data sources
  • linux
  • metadata
  • ODBC
  • 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
Figure 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
  • ETL
  • metadata
  • OLAP
  • OLAP cubes
  • operating system
  • SQL
  • sql server
  • SSAS
  • UNIX

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

  • business rules
  • data governance
  • data integration
  • data management
  • data protection
  • data quality
  • data virtualization
  • mongodb
  • teradata
  • windows

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
Figure 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
Figure 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:

  • AIX
  • AWS
  • data governance
  • data integration
  • data management
  • data sources
  • linux
  • metadata
  • ODBC
  • 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
Figure 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 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
Figure 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. SAS Data Studio can be defined by the following functionalities:

  • data cleansing
  • data integration
  • data management
  • data quality
  • data sources
  • metadata
  • mongodb
  • self-service data preparation
  • source table
  • teradata

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
Figure 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 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:

  • API
  • AWS
  • big data
  • data integration
  • data management
  • hadoop
  • impact analysis
  • metadata
  • rest API
  • star schema

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
Figure 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 integration
  • data management
  • data quality
  • master data
  • master data management
  • metadata
  • mongodb
  • real time
  • teradata

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
Figure 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 can be characterized by the following functionalities:

  • AIX
  • big data
  • data management
  • data warehouse
  • metadata
  • ODBC
  • star schema
  • teradata
  • UNIX
  • windows

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
Figure 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 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:

  • data governance
  • data integration
  • data lineage
  • data management
  • data quality
  • impact analysis
  • metadata
  • metadata management
  • operating system
  • 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
Figure 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
Figure 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 data integration > cloud data integration, data connectivity > apache > apache kafka and data quality management > data quality API.

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
  • SAS Clinical Data Integration: 2.63 2.5 2.2 2.1
  • SAS Data Explorer: 2.5 2.4 2.1
  • SAS Data Integration: March 07 9.4m7 9.4 9.3 9.2
  • SAS Data Integration Studio: 4.906 4.905 4.903 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 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.2
  • SAS Data Studio: 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 1.6
  • SAS Lineage: 3.3 3.2 3.1
  • SAS Metadata Bridge: 69
  • SAS Metadata Server: 9.4
  • SAS OLAP Server: 9.4
  • SAS Viya: 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 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: data preparation profiling, self-service data management, process flow diagrams, transformations tree and big data appliances.

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, siebel, data lakehouses and 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 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, database containers and automated data processing. In doing so, we analyzed the following five products: SAS Data Integration Studio, SAS Data Management, SAS Data Integration Server, SAS Enterprise Data Integration Server and SAS Data Governance. 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 Data Infrastructure

98%

The vendor SAS has an excellent score in our 100% vendor-independent ETL & Data Integration survey of the theme ‘Data Infrastructure’, given that they score 98% on this, relative to other vendors. We considered the following factors: security, API and rest API. In total, we examined 87 features within this discipline. Are you excited about the subject ‘Data Infrastructure’? Then download here our ETL & Data Integration Study 2024. Or learn more about the following topics:

3. SAS Metadata Management

92%

The vendor SAS has an excellent score in our independent ETL & Data Integration survey of the theme ‘Metadata Management’, given that they score 92% on this, compared to other vendors. We looked at the following criteria, among others: enterprise data catalog, business glossary, metadata repository and impact analysis. In doing so, we analyzed the following two products: SAS Data Integration and 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 Guide.

4. SAS Data Integration

92%

The company has an excellent rating in our independent ETL & Data Integration survey on the subject ‘Data Integration’ with a score of 92%, relative to other vendors. We looked at the following criteria, among others: data warehouse, data ingestion, data integration projects, customer data integration, data integration patterns, enterprise data fabric and salesforce data integration. In doing so, we investigated the following five products: SAS Data Integration, SAS Data Integration Studio, SAS Clinical Data Integration, SAS Data Integration Server and SAS ETL. In total, we examined 167 criteria in this category. Would you like to become more proficient in the subject ‘Data Integration’? Then download here our ETL & Data Integration Guide 2024. Or learn more about the following topics:

5. SAS Self-service Integration

90%

SAS has an excellent rating in our study on the subject ‘Self-service Integration’ with a score of 90%, compared 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 aspects 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.

6. SAS Data Connectivity

87%

SAS has an excellent performance in our 100% vendor-independent ETL & Data Integration survey of the theme ‘Data Connectivity’, given that they score 87% 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 Quality Management

82%

SAS has an excellent rating in our independent ETL & Data Integration survey on the subject ‘Data Quality Management’ with a score of 82%, relative to other vendors. The following criteria were used: data quality, data profiling and business rules. In doing so, we analyzed the following products: SAS Data Quality. In total, we examined 28 criteria within this section. Would you like to learn more about the subject ‘Data Quality Management’? Then download here our ETL & Data Integration Study 2024.

8. SAS Data Governance

80%

The company has an excellent performance in our study on the section ‘Data Governance’. The score amounts to 80%, relative to other vendors. We considered the following factors: dataops, data protection and data privacy. In doing so, we investigated the following three products: SAS Enterprise Data Integration Server, SAS Data Governance and SAS Lineage. In total, we examined 16 criteria in this category. Would you like to go into more depth with the subject ‘Data Governance’? Then download here our ETL & Data Integration Guide 2024.

9. SAS Master Data Management

31%

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

18%

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

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: agriculture, airlines, governments and logistics.

SAS software is most used by…

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

Hire a qualified 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 instance as incompany. 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 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

You May Also Like

Microsoft ETL & Data Integration
Microsoft ETL & Data Integration
SAS consultant
SAS consultant
Data Integration
Data Integration

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 PartnerDAAN VAN BEEK MScBusiness Partner

Contact me directly

Fact sheet

___
customers
___
training courses
___
people trained
4.7
stars customer satisfaction
___
consultants & teachers
3
offices
19
years of experience