#1 most frequent
United States of America
64.0%55 installations of 86
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
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.9
Integration with MDM tools
Integration with master data management tools to ensure data consistency across the organization
Category average: 7.2
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.6
Areas for Improvement
Simple transformations
Simple data transformations are calculations, data type conversions, aggregations and search and replace operations
Category average: 8.8
Testing and debugging
Tool to debug and tune for optimal performance
Category average: 7.2
Data model creation
Ability to create and maintain data models using a graphical tool to define relationships between data
Category average: 8.4
Who Buys & Uses SAS Data Management
#2 most frequent
India
15.1%13 installations of 86
#3 most frequent
Australia
4.7%4 installations of 86
My SAS Enterprise Data Integration Server Review
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
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
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
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
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