TrustRadius: an HG Insights company

SAS Data Management

Score8 out of 10

34 Reviews and Ratings

Get a Demo

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.

Categories & Use Cases

Key Features

Learn about the best (and worst!) features SAS Data Management has to offer, as determined by TrustRadius' reviewers.
Based on 34 ratings of SAS Data Management's features
View all features

Top Performing Features

  • Connect to traditional data sources

    Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications

    Category average: 8.7

  • Integration with MDM tools

    Integration with master data management tools to ensure data consistency across the organization

    Category average: 7.8

  • Connecto to Big Data and NoSQL

    Ability to connect to non-traditional data sources like Hadoop and other big data technologies, and NoSQL databases

    Category average: 7.7

Areas for Improvement

  • Simple transformations

    Simple data transformations are calculations, data type conversions, aggregations and search and replace operations

    Category average: 8.1

  • Testing and debugging

    Tool to debug and tune for optimal performance

    Category average: 6.9

  • Data model creation

    Ability to create and maintain data models using a graphical tool to define relationships between data

    Category average: 8.4

Reviews

What users are saying about SAS Data Management.
View all reviews

My SAS Enterprise Data Integration Server Review

Incentivized
Filippo OrlandoView profile
Advanced Analytics Manager in Information Technology at Unieuro S.p.A. (1001-5000 employees employees)

Pros

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

Return on Investment

  • Implementation time to be expected due to the expertise on SAS tools and its language.
  • Complete and very powerful tool, especially combined with other SAS products.
  • Modern product always in step with the times and needs, certainly not cheap.

Alternatives Considered

SAS Advanced Analytics and SAS Business Intelligence

Usability

Other Software Used

KNIME Analytics Platform, Oracle Application Express

SAS/Access gives you power to know

Incentivized
Larry BurnsView profile
Assistant Director of Institutional Research and Information Management at Oklahoma State University (5001-10,000 employees employees)

Use Cases and Deployment Scope

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.

Pros

  • Secure connections to databases
  • Managed access to databases and data
  • Customized access to databases

Cons

  • Can be dense to understand

Return on Investment

  • Increase of data across campus
  • Less downtime
  • More collaborate and federated data

Other Software Used

SAS Visual Analytics, SAS Enterprise Guide

Easy to use Data Integration Software for Business Users

Incentivized
Ravi Lagu
Senior Manager in Information Technology at Indiabulls Housing Finance Limited (5001-10,000 employees employees)

Use Cases and Deployment Scope

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.

Pros

  • 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

Cons

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

Return on Investment

  • The platform enabled us to have a single repository of customers to run campaigns on.
  • Feedback from various campaigns is stored in a single database, which makes running A/B analysis easier.
  • Helped improve data quality due to SAS Dataflux being a part of the SAS Data Management Platform.

Alternatives Considered

Informatica PowerCenter, IBM Netezza Data Warehouse Appliances and SQL Server Integration Services

Other Software Used

SAS Visual Analytics, SAS Enterprise Guide, Talend Cloud Integration, Oracle SQL Developer, PostgreSQL, Microsoft Dynamics 365 (formerly Microsoft Dynamics CRM), Salesforce Lightning Platform (formerly Salesforce App Cloud)

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

Incentivized
Jim MetcalfView profile
Chief Data Scientist in Research & Development at Desert Research Institute (11-50 employees employees)

Use Cases and Deployment Scope

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.

Pros

  • 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

Return on Investment

  • Priceless value.we could not conduct our research without SAS/Access.

Other Software Used

KNIME Analytics Platform, Weka.IO

Trustworthy and Powerful

Incentivized
Donald WildeboerView profile
Information Analyst in Research & Development at Agriculture Financial Services Corporation (501-1000 employees employees)

Use Cases and Deployment Scope

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.

Pros

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

Cons

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

Return on Investment

  • We have more users who can connect to the many different data sources.
  • Our users do have existing SAS programming knowledge and that can carry over.
  • Business functions are starting to rely on SAS Data Integration Studio work product shortly after introduction.

Alternatives Considered

Base SAS and Microsoft Systems Management Server

Other Software Used

Microsoft Systems Management Server, Oracle Access Management, SAS Data Management Platform