Skip to main content
TrustRadius
SAS Data Management

SAS Data Management

Overview

What is SAS Data Management?

A suite of solutions for data connectivity, enhanced transformations and robust governance. Solutions provide a unified view of data with access to data across databases, data warehouses and data lakes. Connects with cloud platforms, on-premises systems and multicloud data sources.

Read more

Learn from top reviewers

Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is SAS Data Management?

A suite of solutions for data connectivity, enhanced transformations and robust governance. Solutions provide a unified view of data with access to data across databases, data warehouses and data lakes. Connects with cloud platforms, on-premises systems and multicloud data sources.

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

5 people also want pricing

Alternatives Pricing

N/A
Unavailable
What is Astera Data Pipeline Builder (Centerprise)?

Astera Data Pipeline Builder is a no-code solution for designing and automating data pipelines. It allows users to read and write data across various file formats, databases, and applications. Users can execute ETL and ELT pipelines manually, schedule automated reruns, or integrate them into…

What is Skyvia?

Skyvia is a no-code cloud data integration platform for ETL, ELT, Reverse ETL, data migration, one-way and bi-directional data sync, workflow automation, and real-time connectivity. Benefits of Using Skyvia:• Cost efficiency: With flexible pricing plans for each product, Skyvia suites for…

Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

8.3
Avg 8.3

Data Transformations

Data transformations include calculations, search and replace, data normalization and data parsing

6.7
Avg 8.1

Data Modeling

A data model is a diagram or flowchart that illustrates the relationships between data

6.7
Avg 7.9

Data Governance

Data governance is the practise of implementing policies defining effective use of an organization's data assets

7.9
Avg 8.2
Return to navigation

Product Details

What is SAS Data Management?

A suite of solutions for data connectivity, enhanced transformations and robust governance. Solutions provide a unified view of data with access to data across databases, data warehouses and data lakes. Connects with cloud platforms, on-premises systems and multicloud data sources.

Included Data Preparation solutions streamline data workflows and execute ELT, supporting data pipelines to ingest, transform and serve high-quality data with a low-code self-service visual designer. And governance solutions help users to ensure regulatory compliance.

SAS Data Management Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

A suite of solutions for data connectivity, enhanced transformations and robust governance. Solutions provide a unified view of data with access to data across databases, data warehouses and data lakes. Connects with cloud platforms, on-premises systems and multicloud data sources.

Reviewers rate Connect to traditional data sources highest, with a score of 8.6.

The most common users of SAS Data Management are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews From Top Reviewers

(1-5 of 11)

SAS/Access...the universal adapter that ties together all of your data sources across the enterprise

Rating: 10 out of 10
February 28, 2020
JM
Vetted Review
Verified User
SAS Data Management
17 years of experience
The Healthy Nevada Project (healthynv.org) uses SAS/Access to bind the SAS 9.4 analytics platform to electronic healthcare records stored in Microsoft SQL Server. SAS/Access is used across the entire project to extract research data. Without the capabilities of SAS/Access, we would be unable to deliver phenotypic data to geneticists so they can perform genome-wide association studies (GWAS). The product is incredibly robust. In the millions of extracts we have performed, we have never encountered a software defect with SAS/Access. As a result, SAS/Access is "invisible" to the team. It just works. Every. Single. Time. The ACCESS product line from SAS is rich in that there are twenty-five different "adapters" that let SAS connect to data sources as disparate Oracle, DB2, Sybase, Hadoop, Impala, SQL Server, MySQL, Greenplum, HAWQ, Netezza....and the list goes on. If your analytics platform is SAS and you have disparate data sources then SAS/Access is your best friend.
  • Seamless access to disparate data sources
  • Unparalleled data access speed
  • Frictionless
Cons
  • Syntax for the connection string can be tricky
  • Specification of the data source driver can be tricky
SAS/Access is incredibly well-suited for the enterprise-wide data access (read and write) to any data source in your enterprise, no matter the complexity of the schema.

Access Your Data

Rating: 9 out of 10
September 22, 2017
NJ
Vetted Review
Verified User
SAS Data Management
3 years of experience
I currently use SAS/Access to analyze data coming in from the state level Behavioral Health Risk Factor Surveillance System and the Youth Risk Behavior Survey. I focus on tobacco data and SAS is extremely important when looking at this data. I use SAS STAT to analyse the data using survey procedures. Because BRFSS and YRBS are complex surveys I must use the survey procedures in SAS to get weighted frequencies, means and estimates. It is extremely easy to use SAS for these analyses, because the procedures are pretty repetitive. However, I do wish that the strata, weight, and cluster variables did not have to be typed with each procedure done. When using STATA or SPSS these variables are entered once, and the weighted results are automatically given when writing procedure. No need to enter them in for each. However, I am more comfortable with SAS coding and really like that it is user friendly. The online support for SAS is wonderful as well.
  • SAS/Access is great for manipulating large and complex databases.
  • SAS/Access makes it easy to format reports and graphics from your data.
  • Data Management and data storage using the Hadoop environment in SAS/Access allows for rapid analysis and simple programming language for all your data needs.
Cons
  • SAS/Access coding is not as simple as SQL query language. SAS/Access requires the user to have prior knowledge of SAS coding and data-set manipulation.
  • SAS/Access support is not as good as Base SAS support, there is not much help if you want to do a specific format or data merge with your datasets.
  • SAS/Access is a bit expensive compared to SQL, but if you already have Base SAS it is not as expensive.
SAS/Access is well suited for companies who need to manipulate and analyze large databases and data-sets. It does the same thing as SQL, and if you already know basic SAS coding it is easier to pick up. SAS/Access works well with analyzing data from multiple data-sources at once, including large databases stored in external and virtual environments like Hadoop. Data can be easily reassembled from relational databases for use by the user. SAS/Access is not necessary if you are only pulling data from one database that you have the physical file for.

Best server for making the data lakes and using the data from it for analytics.

Rating: 8 out of 10
February 20, 2020
Vetted Review
Verified User
SAS Data Management
4 years of experience
This is used department-wide for different clients. There are very limited people who are using it because for handling this tool some experience is required. We use it to make data lakes for fetching data and using it for analyzing patterns.
  • It can process multiple data sources together.
  • It works very fast and is highly scalable.
Cons
  • It hangs a lot, that means that while loading huge data it sometimes slows down.
  • No modelling options available in the tool.
It is suited for taking data from multiple sources simultaneously like for example the streaming data of transactions in retail stores. It processes the data at a pretty high pace and gives high results every time.

It is less appropriate sometimes because it hangs sometimes and does not have a large user community available over the internet.

My SAS Enterprise Data Integration Server Review

Rating: 7 out of 10
September 11, 2020
FO
Vetted Review
Verified User
SAS Data Management
3 years of experience
The product is used by our company to meet specific needs in the analytics field, for our CRM. In our case, it's used to manage customer segmentation logics and CRM targeting. I think it is the ideal solution, but may not find it's place in other areas or projects.
  • Integrability with different data sources. The provision of native connectors is complete and there is the possibility of implementing new ones.
  • Flexibility in power sources, thanks to the connectors with the main DB and the integration of all types of formats (XML, CSV, JSON, etc.)
  • End-to-end process with the SAS suite. Products such as SAS Visual Analytics allows the visualization of the data produced, or Visual Data Mining and Machine Learning which allows you to perform advanced analysis.
Cons
  • It is a versatile product but sometimes difficult to use due to the very close link with the proprietary programming language where specific knowledge is required.
  • Compared to competitors on the market that offer the same functions for the integration perimeter, it is certainly very expensive.
  • It is very simple to use when combined with products from the SAS suite, less so it is being used stand-alone or integrated with other well-known brands.
I believe that in the field of Data Integration, the SAS product is very suitable if the company uses SAS products for all the steps of the data. It is less suitable if used as a stand-alone tool. In our case, to manage customer segmentation logics and CRM targeting, it is the ideal solution.

SAS/Access to extract data from large databases

Rating: 10 out of 10
February 20, 2018
We are using SAS/Access to extract and join data from a variety of platforms to create new datasets in a form usable by business partners.
  • Able to read a variety of databases e.g. Teradata
  • Can use familiar SQL statements to extract the data
  • Can be used to extract data from a wide variety of platforms
Cons
  • SAS/Access currently meets my needs and I expect will evolve as new data sources and platforms emerge.
Extracting from large databases in order to subset and filter for specific purposes is a suitable use for SAS/Access.
Return to navigation