Vertica OnDemand Getting Started
Guide
HPE Vertica Analytic Database
Software Version: 7.2.x
Document Release Date: 12/15/2015
Legal Notices
Warranty
The only warranties for Hewlett Packard Enterprise products and services are set forth in the express warranty statements accompanying such products and services. Nothing herein should be construed as constituting an additional warranty. HPE shall not be liable for technical or editorial errors or omissions contained herein.
The information contained herein is subject to change without notice.
Restricted Rights Legend
Confidential computer software. Valid license from HPE required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor's standard commercial license.
Copyright Notice
© Copyright 2015 Hewlett Packard Enterprise Development LP
Trademark Notices
Adobe™ is a trademark of Adobe Systems Incorporated.
Microsoft® and Windows® are U.S. registered trademarks of Microsoft Corporation.
UNIX® is a registered trademark of The Open Group.
This product includes an interface of the 'zlib' general purpose compression library, which is Copyright © 1995- 2002 Jean-loup Gailly and Mark Adler.
HPE Vertica Analytic Database (7.2.x) Page 2 of 11
Contents
Introduction 5
Audience 5
Create An HPE SaaS Account 5
Order Services 5
Check Order Status 6
Download And Install Client Drivers 6
Install Vertica Client 6
Access The Database 7
Syntax 7
Example 7
Access The Management Console 7
Security 8
Backup 8
Vertica On Demand Available Features 8
Send Documentation Feedback 11
Page 4 of 11 HPE Vertica Analytic Database (7.2.x)
Vertica OnDemand Getting Started Guide
Introduction
HP Vertica OnDemand combines the power of Vertica Analytics with the ease and flexibility of a cloud service. This guide describes the Vertica OnDemand setup process.
Audience
This document is for customers subscribing to (or trying) Vertica OnDemand. The document assumes that you are familiar with using Vertica. If you are need more guidance about creating, modifying and querying your Vertica database, the complete documentation set is available here:
http://www.vertica.com/documentation
Create An HPE SaaS Account
Saas.hpe.com is an online marketplace for a number of HPE software products and services, including Vertica and Vertica OnDemand.
You must create an HPE SaaS account before you can purchase Vertica OnDemand or begin a free trial.
If you have already signed up for Vertica OnDemand, skip this section.
To create an HPE SaaS account:
1. Go tosaas.hpe.comand clickSign Inin the upper right corner.
2. ClickSign Up.
3. Enter your information.
4. ClickSign Up.
Order Services
To order Vertica OnDemand:
1. From the HPE SaaS home page, click theProductstab.
2. SelectVertica.
3. Choose one of the Vertica OnDemand offerings or sign up for a free trial.
Vertica OnDemand Getting Started Guide
Check Order Status
Once you submit your order, Vertica provisions your cluster automatically. You can check on the status of your order in theMy Productspage of your HPE SaaS account.
When your cluster is fully provisioned, HPE sends you an email containing your cluster information with the subject line:Your Vertica OnDemand database cluster is ready for use.
Note: Provisioning a cluster typically takes about one hour. While the provisioning process executes, you can continue by downloading the client driver you need to connect to Vertica.
Download And Install Client Drivers
Connect to your database using a vsql client to issue vsql commands and perform administrative tasks. You can also connect to your database from other applications using industry-standard client drivers (ODBC, JDBC, ADO.NET). You cannot SSH into a Vertica OnDemand cluster.
Download vsql and drivers frommy.vertica.com. You can download the drivers individually, or as packages that contain ODBC, JDBC, and vsql clients.
Note: The Windows client package does not include the ADO.NET driver. If you need this driver, you must download it separately.
To download the individual drivers or client packages:
1. Navigate tomy.vertica.com.
2. Sign In. If you do not have a My Vertica account, you can register for a Community Edition account for free.
3. Click theDownloadstab.
4. Select the appropriate package for your operating system and hardware.
Install Vertica Client
Once your download completes, install the drivers.
For more information about installing client drivers, refer to theinstalling the Vertica Client Driverssection of the full documentation.
Vertica OnDemand Getting Started Guide
HPE Vertica Analytic Database (7.2.x) Page 6 of 11
Access The Database
Now that you have installed the Vertica client package, you can connect to your Vertica OnDemand cluster.
To continue, you will need the cluster and credentials provided in your welcome email.
To connect to your Vertica OnDemand database:
1. Start the vsql client.
2. Connect to your Vertica OnDemand database using the-hstatement.
Syntax
vsql -h clusterIP -d databasename -U userID -w password
Example
vsql -h 199.666.1.1 -d verticanow -U ver123456789 -w mypassword If you connect to the database successfully, you will see a vsql welcome statement.
Access The Management Console
You can use the Vertica Management Console (MC) user interface to manage and monitor your database. MC is set up and automatically configured as part of your cluster provisioning process.
Your welcome email provides the URL you should use to access MC, as well as the login credentials to your main MC account.
To access MC:
1. In a browser, access MC using the URL provided in your email.
2. Log in to MC using the provided credentials.
Note: Your MC site uses a self-signed SSL certificate. Your browser may display a warning page because of this. Ignore the warning message about reaching an unsafe site. The warning is expected.
After logging in, you’ll be able to manage and monitor your Vertica OnDemand database. Yourverticanow database is automatically created when your cluster is provisioned. You cannot create a new database from MC.
Vertica OnDemand Getting Started Guide
Security
Vertica OnDemand provides comprehensive cloud security for you automatically with little further configuration.
To prevent unauthorized access, you can assign privileges directly to users or to roles through a series of GRANT statements issued in the VSQL client. For example, you can create additional users and grant them various levels of access to your database.
Additionally, a Management Console administrator (either you, or anyone you grant administrator privileges to) can grant MC users access to one or more Vertica databases through the MC interface.
For more information about access control, seeManaging Users and Privilegesin the Administrator's Guide.
Backup
Vertica OnDemand creates backups of your cluster automatically. HPE SaaS performs a full backup of your database every day. You can restore your database from any daily backup point within the last 7 days.
Vertica On Demand Available Features
This guide supplements the full Vertica documentation. For more detailed information, refer towww.vertica.com/documentation.
Some features described in the full documentation do not apply to Vertica OnDemand.
The following table lists which features are currently supported.
Feature Available in HPE Vertica OnDemand?
Admintools No
Client Driver Access Yes Command Line Access Yes Create a New Databass No
Dbadmin Access No
Management API No
Vertica OnDemand Getting Started Guide
HPE Vertica Analytic Database (7.2.x) Page 8 of 11
Management Console Yes Secure Shell Access No
vsql Client Yes
Vertica OnDemand Getting Started Guide
Page 10 of 11 HPE Vertica Analytic Database (7.2.x)
Vertica OnDemand Getting Started Guide
Send Documentation Feedback
If you have comments about this document, you cancontact the documentation teamby email. If an email client is configured on this system, click the link above and an email window opens with the following information in the subject line:
Feedback on Vertica OnDemand Getting Started Guide (Vertica Analytic Database 7.2.x)
Just add your feedback to the email and click send.
If no email client is available, copy the information above to a new message in a web mail client, and send your feedback to [email protected].
We appreciate your feedback!