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.
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 In 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 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.
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
- security
- self-service data preparation
Are you curious about all features (100+) of SAS Viya? Open the ETL & Data Integration Guide™ 2024 here.
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.
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.
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.
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.
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.
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
- 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.
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.
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.
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.
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.
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
- 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.
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
- security
Are you curious about all the functionalities (100+) of SAS Business Rules Manager? Download directly our ETL & Data Integration Guide™ 2024 here.
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.
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.
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.
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.
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.
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.
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.
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
- 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.
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
- 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.
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.
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
- 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.
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.
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.
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.
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
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
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
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
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
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
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
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
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
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
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
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.