HP ConvergedSystem 300, Getting Started Manual, Page: 13 / 24

Table 3 Interfaces (continued)
Description Interface
dbadmin
user can run the Administration Tools. See Using
the Administration Tools in the HP Vertica Programmer’s
Guide .
Use the vsql client interface, or another client of your
choice, to run database queries and analytic functions.
A graphical, browser-based interface to monitor and
manage one or more HP Vertica clusters and perform other HP Vertica Management Console (MC)
database related tasks. See Management Console in the
HP Vertica Concepts Guide .
Industry standard drivers such as, ODBC, JDBC and
ADO.NET, let you connect your applications to HP Vertica. Client Drivers
After you connect, your application can load and exchange
data, generate reports, and complete other database tasks.
You also use client drivers to connect with third-party
applications, such as Cognos and MicroStrategy. See the
HP Vertica Client Libraries in the
HP Vertica Programmer’s
Guide .
Connecting to HP Vertica
TIP: For IP address details, see the file named
/opt/hp/CS300/HPCS300.xml
on the Linux
management server (r001mn001) as the example shown in “IP addresses” (page 8) .
Connecting to HP Vertica using a remote terminal client
To log in to the HP Vertica server as the database user (dbadmin), use an SSH, remote-terminal
client, such as PuTTY or a Cygwin bash shell.
1.
Launch the PuTTY application.
2. In the Host Name or IP dialog box, type the name of the host or IP address of the server to
which you want to connect.
3. Under Connection type , verify that SSH is selected and click Open .
4. At the PuTTY
log in as
prompt, type
dbadmin
and then enter the dbadmin password.
For more information see the Notes for Remote Terminal Users in the HP Vertica Administrator’s
Guide .
Connecting to HP Vertica using CLI-based Administration Tools
The HP Vertica CLI-based Administration Tools provide functionality that is not available in the
browser-based HP Vertica Management Console. To run CLI-based Administration Tools, you must
connect to a node that is running HP Vertica.
After you've logged in to HP Vertica as the dbadmin user, run the Administration Tools. The
Administration Tools connect to the database and transfer control to vsql.
For a comparison between Administration Tools and Management Console functionality, see
Administration Tools and Management Console in the
HP Vertica Administrator’s Guide .
You can run vsql from the command line to connect to a database from any Linux host, including
hosts that are not part of the HP Vertica database cluster.
For more information, see the following topics in the HP Vertica Programmer's Guide :
•
Connecting from the Administration Tools
•
Connecting from the Command Line
•
Connecting from a Non-Cluster Host
Accessing HP Vertica 13