Ensure that business decisions are supported by complete, consistent, up-to-date and accurate data.
Give technical and business users fast, easy access to the data they need.
SAS/ACCESS provides seamless and transparent read, write and update rights to more than 60 data sources, including relational and nonrelational databases, PC files, Hadoop, Amazon Redshift and data warehouse appliances. Our out-of-the box solution empowers business users to use the technology with minimal training. Technical users who want more control can interact directly with the data source using native interfaces, such as SQL. The software passes database queries, joins and other functions to the target data source, reducing network traffic and speeding data processing times. Native bulk-load utilities enable even faster load times.
Get direct, secure access with native interfaces and integration standards.
Get easy, highly secure access to source data – no custom coding or expertise in SQL or other query languages required. The software honors the native security of the target data source, and provides transparent access by making data sources appear as though they are a native SAS data type. This facilitates integration across sources and with SAS procedures, SAS DATA step and SAS solutions. SAS/ACCESS engines are tightly integrated and used by all SAS solutions for third-party data integration. Supported integration standards include ODBC, JDBC, Spark SQL (on SAS Viya) and OLE DB.
Explore More on SAS/ACCESS® Beyond
- White Paper White Paper gratuito - Trasferisci il potere di SAS® in HadoopHadoop è sinonimo di framework open-source a supporto di applicazioni distribuite con elevato accesso ai dati. Permette elaborazioni rapide e la capacità di gestire, virtualmente in modo illimitato, molteplici attività in parallelo. Un complemento a basso costo per la tradizionale infrastruttura dati aziendale. SAS integra le sue capacità analitiche per ricavare informazioni di business da queste attività.
- Articolo Data lake and data warehouse – know the differenceData lake – is it just marketing hype or a new name for a data warehouse? Find out what a data lake is, how it works and when you might need one.
Check out these products and solutions related to SAS/ACCESS software.
- SAS/ACCESS® Interface to HadoopGet out-of-the-box connectivity between SAS and Hadoop, via Hive.
- SAS/ACCESS® Interface to ImpalaGain low-latency response times and work faster with this out-of-the-box solution connecting SAS and Impala.
- SAS® In-Database TechnologiesShorten the time needed to perform key data quality and analytic processes by carrying out these functions within the database.
- SAS® Viya®Vinci qualsiasi sfida analitica, dalle sperimentali alle più rilevanti, con un unico ambiente pronto per il cloud e disponibile per tutti, dai data scientist ai business analyst, dagli sviluppatori agli executive.