Neoview Database Administrator's Guide (R2.5)

1 Introduction to the HP Neoview Platform
The HP Neoview platform provides enterprise-class, SQL data warehousing to support your
business intelligence needs. HP leverages industry-standard servers and 30 years of experience
with highly available, massively parallel processing in this platform, to provide availability,
scalability, and performance.
About This Guide
This guide is intended for those who perform standard database administration tasks, and it
provides basic task information. It is helpful to have knowledge of database and SQL concepts,
connectivity and data source concepts, and basic computer security concepts.
For More Information
See...For Information About...
Neoview documentation on the HP BSC portal: http://
www.hp.com/go/neoviewdocs
The Neoview platform, manuals, and READMEs
Neoview SQL Reference ManualNeoview SQL commands and syntax
HPDM Online Help
Neoview HP Database Manager (HPDM) User Guide
Displaying database objects
• Neoview Command Interface (NCI) Guide
• Neoview SQL Reference Manual
Managing database objects
• General: Neoview Query Guide
• Entering SQL commands and Scripts: Neoview
Command Interface (NCI) Guide
• SQL Commands and Syntax: Neoview SQL Reference
Manual
• Analysis:
— Neoview Performance Analysis Tools Guide
— NPAT Online Help
Queries
Neoview Workload Management Services GuideManaging Neoview platform workload and resources
Chapter 5 (page 25)Performing database operations such as updating statistics
or defragmenting
Chapter 4 (page 21)How to perform other administrator operations
• “Reconfiguring ODBC Client Data Sources” (page 31)
• “Configuring ODBC Client Data Sources for Update
Operations” (page 31)
• “Removing ODBC Client Data Sources” (page 31)
For detailed information about specific windows or
detailed information about how to perform specific tasks,
see the ODBC Data Source Administrator online help.
How to use the Microsoft ODBC Data Source
Administrator to manage ODBC client data sources
Performing Database Connectivity Tasks “Neoview
Database Connectivity Services (NDCS)” (page 32)
How to use NDCS to allow Neoview SQL to access an
HP SQL database.
The ODBC Programmer’s Reference on the Microsoft
website.
How to use Microsoft Open Database Connectivity
(ODBC)
About This Guide 11