Seamless, transparent data integration
Access the most popular databases on common platforms without detailed knowledge of the database or SQL.
Ensure that business decisions are supported by complete, consistent, up-to-date and accurate data.
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 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.
Check out these products related to SAS/ACCESS software, built on the powerful SAS® Platform.
Back to Top