Productos y Soluciones / Enterprise Data Access

SAS/ACCESS® Interface to Netezza

A convenient way to access and use your Netezza data

Las aplicaciones de almacenamiento de datos, están diseñados para integrar la base de datos, el servidor y el almacenamiento en una sola unidad. Están diseñados para reducir o eliminar las complejidades asociadas con la instalación, configuración, puesta en marcha y administración del hardware, el sistema operativo y el software de appliances mientras que se procesan terabytes de datos con solicitudes de extrema escalabilidad. (Los usuarios de SAS pueden tener acceso a estos appliances usando SAS/ACCESS to ODBC pero se beneficiarán de las funciones avanzadas a medida que las interfaces SAS/ACCESS de proveedores específicos salgan al mercado.)

Beneficios

  • Integrate data from Netezza with other data sources.
  • Access data directly, easily and securely with a native interface.
  • Gain faster performance and reduce network traffic.
  • Minimize data movement.
  • Support both technical and business users.

Leer más

Características

  • Seamless and transparent data access
  • Flexible query language support
  • Performance features
  • Metadata integration
  • Optimization

Leer más

Beneficios

  • Integrate data from Netezza with other data sources. SAS/ACCESS engines provide seamless and transparent read/write/update access to more than 60 data sources, including relational and nonrelational databases, PC files and data warehouse appliances. SAS Data Surveyors are specialized engines specifically for accessing enterprise applications. SAS can help you use all your enterprise data for competitive advantage.
  • Access data directly, easily and securely with a native interface. No SQL expertise or custom coding of extractions is 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, which facilitates interaction with SAS procedures, the SAS DATA step and SAS solutions. In addition, users are also able to interact directly with the data source using native data source capabilities.
  • Gain faster performance and reduce network traffic. SAS/ACCESS Interface to Netezza provides the ability to push down complex Netezza-specific SQL, as well as SAS formats and a number of SAS software's most popular procedures, to Netezza for processing so they can execute in Netezza without the need to first move the data into SAS. SAS formats are basically mapping functions that change an element of data from one format to another. You can also use SAS to define custom formats that replace raw data values with formatted character values.
  • Minimize data movement. A number of SAS software's most popular procedures are push-down-enabled for Netezza. This means that SAS processing can be translated into SQL queries that are sent directly to the appliance for processing rather than bringing the data back to SAS for processing. This potentially increases system performance by pushing data processing to the most appropriate resource and by minimizing data movement.
  • Support both technical and business users. These out-of-the-box access solutions require minimal training and knowledge transfer. 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 the data sources using SQL or other database-specific query languages.

Características

Seamless and transparent data access
  • Broad coverage of data sources and platforms enables you to integrate data from across your organization.
  • Provides the option to access data without detailed knowledge of the database or SQL. The appropriate SQL queries are generated from the interface and passed to the data source for execution.
  • Provides the option to use SQL if desired.
  • Can create federated queries that span multiple data sources. The queries are surfaced as a database object that can be used with all SAS solutions.
  • Makes use of security mechanisms inherent in the appliance.
Flexible query language support
  • A transparent access option surfaces data with minimal knowledge of the data or the SQL needed for access.
  • A custom SQL option lets users create their own SQL statements or modify automatically generated SQL.
  • Mapping of statements or functions specific to SAS to database-specific statements or functions enables all appropriate SQL statements to be processed directly inside the database, providing the best possible performance.
Performance features
  • Multithreaded read interface uses threaded kernel technology and native APIs.
  • Data read and writes are highly optimized with buffering, compressions, threading, etc.
  • Provides support for automatic partitioning.
  • Provides push-down optimization for SAS format publishing and the SAS_PUT() function as well as popular SAS procedures, including PROC FREQ, PROC RANK, PROC REPORT, PROC SORT, PROC SUMMARY, PROC MEANS and PROC TABULATE.
  • Includes transparent support for Netezza's bulk-load and bulk-unload utilities.
Metadata integration
  • Database metadata can be accurately maintained within the SAS Metadata Repository.
  • Data jobs are registered via the SAS Metadata Server so they can be used in a variety of SAS solutions. Register data once; then use it in many places.
Optimization
  • Supports native storage options, data types and table partitioning.
  • Translates native database data to the appropriate SAS data type for optimized processing.
  • Provides national language support.

Requerimientos del sistema

Host Platforms
  • HP/UX on Itanium: 11iv3 (11.31)
  • IBM AIX on POWER architectures: 6.1 and 7.1
  • Linux (32-bit): Novell SuSE 10 and 11; RHEL 5 and 6
  • Linux x64 (64-bit): Novell SuSE 10 and 11; RHEL 5 and 6
  • Microsoft Windows (32-bit): Windows XP Professional, Windows Vista*, Windows 7**, Windows Server 2003 family, Windows Server 2008 family
  • Microsoft Windows on x64 (64-bit): Windows XP Professional for x64, Windows Vista* for x64, Windows 7** for x64, Windows Server 2003 family for x64, Windows Server 2008 family for x64
  • Solaris on SPARC: Version 10 Update 8
  • Solaris on x64 (x64-86): Version 10 Update 8

* NOTE: Windows Vista supported editions are: Enterprise, Ultimate and Business.
** NOTE: Windows 7 supported editions are: Enterprise, Ultimate and Professional.

Desea más información?

Para hablar con un representante de SAS de inmediato, llame al 01800 1127 727 de 9:00 a.m. a 6:00 p.m. o solicite más información online.