SAS/ACCESS^® Interface to Neoview

Data Warehouse Appliances are designed to integrate the database, server and storage into one unit. They are architected to reduce or eliminate the complexities associated with the installation, configuration, initialization and administration of the hardware, operating system and appliance software while processing terabytes of data with claims of extreme scalability. (SAS users may access these appliances using SAS/ACCESS to ODBC if the appliance vendors supply the ODBC access. SAS customers will benefit from advanced capabilities as new vendor-specific SAS/ACCESS interfaces are released.)

SAS/ACCESS Interface to Neoview is an out-of-the-box solution that provides direct connectivity between SAS and the HP Neoview platform. SAS/ACCESS Interface to Neoview (SAS^® 9.2) also supports HP Neoview's upcoming support for bulk load and extract utilities.

SAS/ACCESS Interface to Neoview supports two means of integration: the LIBNAME engine and the Pass-Through Facility. The LIBNAME engine provides a seamless and transparent way to surface data and requires minimal knowledge of the data or the SQL required for surfacing it. The Pass-Through Facility provides greater flexibility, offering users the option to use their own custom SQL statements or to modify/keep automatically generated SQL (when available, for example, in SAS applications such as SAS Data Integration Studio) which will be passed directly to their Neoview server.

In all cases, by mapping SAS specific statements or functions to Neoview specific statements or functions, all appropriate SQL statements can be processed directly inside Neoview, providing the best possible performance.

The interface is supported on the following platforms for SAS^® 9.1.3:

• HP-UX Itanium
• Linux for x86 (x86-32)
• Solaris on SPARC
• Windows 32-bit

The interface is supported on the following platforms for SAS^® 9.2:

• AIX
• HP-UX Itanium
• Linux for x86 (x86-32)
• Solaris on SPARC
• Windows 32-bit