Get out-of-the-box connectivity and integration between SAS and third-party data sources, including data warehouse appliances, enterprise applications, mainframes (nonrelational data sources), Hadoop, PC files and relational databases. Highly optimized data access engines enable SAS solutions to read, write and update data regardless of source or platform. Because the data appears native to SAS, there is no need to learn SQL or any other database-specific query languages.
Integrate more data sources from more platforms.
Get seamless and transparent read/write/update access to more than 60 data sources, including relational, nonrelational, big data sources (including Hadoop), PC files and data warehouse appliances. SAS helps you take advantage of all your enterprise data.
Gain fast performance and reduce network traffic.
SAS/ACCESS software provides high-performance read, write and load capabilities. The ability to pass database queries, joins and many functions to a target data source for processing reduces network traffic and speeds data access.
Get direct, secure data access with native interfaces.
SQL expertise or custom coding of extractions is not required. You get a high degree of control over data security because SAS/ACCESS honors and augments the native security of the target data source. SAS enables a transparent approach by making data sources appear as though they are a native SAS data type. This facilitates interaction with SAS procedures, the SAS DATA step and SAS solutions. You can also interact directly with the data source using native data source capabilities.
Minimize data redundancy and replication.
Integrate data from multiple disparate data sources across the enterprise by presenting a virtualized view of data for on-demand and real-time consumption by a wide range of business solutions. SAS presents a federated view of data to applications that are consuming the data by securely accessing, querying and abstracting away the complexities of disparate data.
Incorporate your data into all SAS products and solutions with support for industry standards.
Support for industry standards, including ODBC, JDBC and OLE DB, enables you to use your third-party data with any SAS product or solution.
Minimize training for business and technical users.
These out-of-the-box access solutions are designed to support both technical and business users. Business users will typically use SAS reporting and analytical capabilities, which can seamlessly access third-party data. Technical users may also access the data transparently, or they can interact directly with data sources using SQL or other database-specific query languages.
- Seamless, transparent and federated data access
- Flexible query language support
- Performance capabilities
- Metadata integration