6 Running Neoview Script From Perl or Python

You can execute an SQL statement in Perl or Python by invoking the Neoview Script Perl or Python wrapper script. To use the Perl or Python wrapper script, see:

•“Setting the Login Environment Variables” (page 71)

•“Perl and Python Wrapper Scripts” (page 74)

•“Launching Neoview Script From the Perl or Python Command Line” (page 74)

•“Launching Neoview Script From a Perl or Python Program” (page 76)

These instructions assume that you installed the Neoview Script product. For more information, see Chapter 2 (page 23).

NOTE: Neoview Script provides a beta version of enhanced support for Perl and Python programs. This functionality enables multiple SQL statements to run in one database connection from a Perl or Python program. For more information, see the README in the Neoview Script samples directory.

Setting the Login Environment Variables

Before launching Neoview Script from Perl or Python, set these login environment variables:

Environment Variable

HPNVS_SERVER=host-name[:port-number]

HPNVS_SERVER=IP-address[:port-number]

HPNVS_USER=user-name

HPNVS_PASSWORD=password

HPNVS_DATASOURCE=data-source-name

Description

Specifies the host name or IP address of the database platform to which you want the client to connect. The host-nameshould include the domain name of the database platform if it is different from the domain of the client workstation. If you do not specify a port number, Neoview Script uses the default port number, which is 18650.

Specifies the user name to log in to the database platform.

Specifies the password of the user to log in to the database platform.

Specifies the name of a data source.

If you do not set these environment variables, Neoview Script prompts you to enter the host name, user name, and password each time you invoke Neoview Script on the Perl or Python command line. Invoking Neoview Script from within a Perl or Python program requires you to set these login environment variables.

To set the login environment variables, see the instructions for the operating system of the client workstation:

•“Setting the Login Environment Variables on Windows” (page 71)

•“Setting the Login Environment Variables on Linux or UNIX” (page 73)

Setting the Login Environment Variables on Windows

You can set the login environment variables for the session at command prompts, or you can set the login environment variables for the system or user by including them in the System Properties.

Setting Login Environment Variables on the Command Line

At each command prompt, enter one of these commands:

set HPNVS_SERVER=host-name:port-numberset HPNVS_USER=user-name

Setting the Login Environment Variables

71

Page 70 Page 72
Page 71
Image 71
HP NEOVIEW 544530-001 manual Running Neoview Script From Perl or Python, Setting the Login Environment Variables
Page 70 Page 72

NEOVIEW 544530-001 specifications

The HP Neoview 544530-001 is a sophisticated data warehousing solution that was designed to address the complex demands of modern businesses. Known for its robust architecture, it enables organizations to efficiently manage, store, and process vast amounts of data. This appliance offers a cohesive combination of hardware and software, configured to deliver high performance and reliability for business intelligence applications.

One of the standout features of the HP Neoview 544530-001 is its ability to support large-scale data analytics. The system utilizes a massively parallel processing architecture, which allows it to handle multiple data queries simultaneously, thereby enhancing the overall performance and response time. This characteristic is vital for businesses that rely on real-time data analysis to make informed decisions.

Another significant technology embedded in the Neoview 544530-001 is its advanced data storage capabilities. With generous storage capacity, it can accommodate extensive datasets, ensuring that organizations have the flexibility to grow their data without compromising system performance. The appliance also integrates advanced compression techniques, which optimize storage efficiency, reducing the physical space required and associated costs.

The HP Neoview is engineered with various data management features, including data quality tools that help ensure the integrity and accuracy of information. These tools can cleanse and normalize data, making it more reliable for analysis. Moreover, the system supports a wide array of data formats, facilitating easy integration with existing databases and applications.

Security is also a critical consideration for the HP Neoview 544530-001. The appliance incorporates robust security measures to protect sensitive data from unauthorized access. This includes encrypted connections and user authentication protocols, which are essential for compliance with industry standards.

In terms of scalability, the Neoview 544530-001 allows businesses to expand their data environment as their needs evolve. The system's modular architecture means that organizations can easily add hardware components, ensuring they can keep pace with increasing data volumes.

Overall, the HP Neoview 544530-001 provides organizations with a complete solution for data warehousing that combines powerful performance, extensive storage, advanced data management tools, and scalable architecture, making it an ideal choice for enterprises looking to leverage data for strategic advantage.
Top Page Image Contents