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
Recent Reviews
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 11 features
  • Connect to traditional data sources (10)
    8.6
    86%
  • Connecto to Big Data and NoSQL (9)
    8.1
    81%
  • Integration with data quality tools (9)
    7.6
    76%
  • Simple transformations (8)
    6.1
    61%
Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

8.3
Avg 8.2

Data Transformations

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

6.7
Avg 8.4

Data Modeling

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

6.7
Avg 8.2

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 and Ratings

(36)

Attribute Ratings

Reviews

(1-11 of 11)
Companies can't remove reviews or game the system. Here's why
Filippo Orlando | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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.
Larry Burns | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
SAS/Access is used in our department and university-wide to provide a connection to various databases to our SAS Viya and SAS 9.4 server setups as well as local based research servers. SAS/Access allows for greater, concerted efforts to connect multiple databases.
  • Secure connections to databases
  • Managed access to databases and data
  • Customized access to databases
  • Can be dense to understand
SAS/Access is best suited for large numbers of databases but can be easily used for single databases as well.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
My organization is using the SAS Data Management Platform at an enterprise-level i.e., across multiple companies. The business problem was to have a single source of data for reporting and analysis as well as creating a 360-degree customer view to identify common customers across companies to improve cross-sell and up-sell. As there are multiple systems across multiple systems, a common data management platform was required to create an EDW for the same.
  • Easy to use even for non-technical people
  • Connects to a variety of data sources
  • Statistical transformations available as part of the module
  • Graphical drag & drop interface
  • Requires third-party drivers to connect to common data sources like SFDC, MS SQL, Postgres.
  • Debugging errors from the logs is a complicated process.
  • E-mail alert system is very primitive and needs customization to make it more modern,
  • Cannot send SMS alerts for jobs.
SAS Data Management Platform is very well suited if you have common data sources like Oracle, SAP, MS SQL, etc.. Still, if there are a bit more obscure, then you need to purchase additional connectors to connect to those data sources. It is well suited when you don't have a business team with strong technical/coding background as the drag and drop interface makes creating jobs and scheduling them quite easy.
Jim Metcalf | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
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
  • 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.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
SAS has been used by many users in our organization, mainly business and retail users for running various modeling using SAS optimizer. It allows the user a wider range of capabilities to cleanse and manipulate the data.
  • Manipulation of data
  • Interact directly with visualizations that refine analyses
  • Wide range of delivery reports
  • Licenses are very costly
  • Its not easy to move SAS users to other open source products because of the easy programming in SAS.
SAS Enterprise Data Integration allows the user a wider range of capabilities to cleanse and manipulate the data. Not only can the data be pulled directly into SAS, but before it is finalized it can be transposed, graphed, or altered. Depending upon the number of use cases and business requirements, think before investing.
February 28, 2018

Trustworthy and Powerful

Donald Wildeboer | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
SAS Data Integration Studio is being used for one view of all our data across the organization. Pulling from our Oracle and SQL Servers the data is described in a fashion that users can know what they are looking at with only a little bit of effort. It also pulls from our major vendors' platforms, pulling both the data or metadata from their systems.
  • With SAS Data Integration Studio it doesn't matter to users where the data is originally from it all is presented in a consistent manner.
  • The SAS Data Integration Studio is fairly reliable it usually works well.
  • The visual design of reports our users even describe as fun.
  • Sometimes parts of the data are not available, although this is generally because it is connected to so many different systems.
  • Price, it's not the cheapest software, however the value for dollars spent does seem to be good.
  • Sometimes all the different systems and platforms and folders and so forth get a bit overwhelming for new users.
When data is in a system that needs a complex transformation to be usable for an average user. Such tasks as data residing in systems that have very different connection speeds. It can be integrated and used together after passing through the SAS Data Integration Studio removing timing issues from the users' worries. A part that is perhaps less appropriate is getting users who are not familiar with the source data to set up the load processes.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
SAS/Access is used by my main customer as an efficient way of bringing data from the enterprise data warehouse into SAS for crunching and general customer insight work. It's also used in some cases to reinject data into the warehouse so that people using other BI tools can access it. Using SAS for statistical analysis as well as an ETL tool allows the users to kill two birds with one stone. They can extract the data themselves and then transform it like they want.

The SAS users are located in several business units with the main ones being risk and marketing. For marketing, it's a question of getting data from several different platforms in order to get a clear customer picture. For risk, it's also about getting data from several platforms but the purpose is to size the risk associated with actual and future loans.
  • SAS supports the main database connection options that allow you to optimize the performance of your extracts and loads.
  • Simplicity of the syntax for a basic connection.
  • Ability to configure by an administrator in a BI environment so that all users can benefit from the connection without having to establish it by themselves.
  • Easier management in the administration platform. Connecting these can be a challenge.
Really best suited for tasks where some statistical analysis is needed.
Purely ETL work should be done with a different tool.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
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
  • 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.
September 22, 2017

Access Your Data

Nikardi Jallah | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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.
Robert Goodman | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
  • dfPower Studio connects to virtually any data source, and any dfPower Studio user in any department can use dfPower Studio to profile, cleanse, integrate, enrich, monitor, and otherwise improve data quality throughout the enterprise. dfPower Architect, an innovative job flow builder, enables users to build complex management workflows quickly and logically.
  • DataFlux Integration Server supports the ability to run batch dfPower Studio jobs in a client/server environment.
  • DataFlux Integration Server for SAS additionally enables allows SAS programs to invoke DataFlux batch jobs from a SAS program and allows SAS programs to call a business service that was designed in the dfPower Studio client environment.
  • DataFlux handled all of our data integration needs. It could be considered pricey when compared to Microsoft's bundled SSIS product.
Return to navigation