Vertica Initial Setup

Sima Alexandru - PeerSpot reviewer
Support Specialis at Orion Innovation Romania

The product's initial setup phase is extremely simple.

The solution is deployed on the cloud.

View full review »
SE
Project Manager at Bank of Africa

The initial setup is straightforward. The deployment took four days.

View full review »
SO
Senior Database Architect at a real estate/law firm with 501-1,000 employees

Actually, the setup of the product itself was straightforward and really quick. 

Once it was up and running and ingesting data we created our first customer facing reports very quickly. Replacing scheduled reports took us eight or nine hours on a Sunday and did not allow any real drill-down could be executed in milliseconds pm Vertica with a lot more flexibility. What takes time is building our dashboards, communication with the customers, introductions to the new products, document the reports.  

I found it really straightforward to set up and run. I would say within two months of setting it up, I had all of my ingestion routines in place and everything was formalised. It ended up that it was one of the easiest database products I have ever had to set up.  

We deployed without any external help except maybe a few tech support calls.

View full review »
Buyer's Guide
Vertica
March 2024
Learn what your peers think about Vertica. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,578 professionals have used our research since 2012.
SR
Pathways Operations Manager at a retailer with 10,001+ employees

Regarding the initial setup, I don't have direct involvement in it and cannot provide much comment. It's something that my team handles, and while they found it easy to set up, I don't have many specific insights to share.

View full review »
it_user514728 - PeerSpot reviewer
Senior DBA at a local government with 1,001-5,000 employees

Initially when I first started, the documentation, etc. available was scarce. However, this has improved substantially.

I was used to OLTP and DWH solutions based on technology such as Oracle, so some of the concepts are quite different.

View full review »
it_user550089 - PeerSpot reviewer
Vertica Support Engineer at a media company with 10,001+ employees

Installation is recommended for someone familiar with Linux (the only OS available for Vertica). For developers with a Linux background, the issues are very manageable. Documentation is good for the installation, so follow it carefully, step-by-step.

View full review »
SK
Group DWH and BI Senior Manager at Virgin Mobile Middle East and Africa

The installation is not simple, if you go through the documents that are provided you should manage to do it. However, having some technical knowledge would be recommended. 

The time it took to do the implementation was approximately 45 minutes. There is additional software or features that we needed to deploy as part of the migration.

View full review »
TE
Senior Manager, Systems and Network Engineering at a computer software company with 11-50 employees

The initial setup was straightforward for me, it's not complex at all. You need to be at least a bit of a database administrator and really get certified on Vertica in order to use it. 

View full review »
it_user453681 - PeerSpot reviewer
BI Manager, Vertica ASE Certified DBA at a marketing services firm with 1,001-5,000 employees

The initial setup was straightforward. We used an HPE-affiliated vendor to purchase and properly set up the equipment, completed a PoC, and then we had HPE Professional Services assist with the transition from our old system to Vertica.

Our Linux team loves it as one of the best installation packages. Initiate on one node, and the RPM propagates automatically to all other nodes.  

View full review »
AA
Staff Database Developer at a manufacturing company with 10,001+ employees

The initial setup of Vertica is straightforward.

View full review »
it_user428343 - PeerSpot reviewer
Managing Partner at Thorium Data Science

It takes some time to come to grips with the various considerations. I’d suggest bringing in a consultant if you don’t have the time or inclination to do it yourself as it takes going through and install and configuration one or two times to really understand the implications of the different options.

View full review »
BD
System Architect at a comms service provider with 10,001+ employees

We had no issues deploying it.

View full review »
AG
Director at Decision Science

Once you got your cluster setup and nodes properly working, it is very simple to set up Vertica.

View full review »
YZ
Sr DBA/ DBA Tech Lead at a non-profit with 1,001-5,000 employees

The initial setup is okay. You will need some knowledge and some training. I'd say learning takes a couple of months. We use one person to maintain the database side. With the DevOps team, everyone has a different role. But for our database, it's just one person.

View full review »
it_user464571 - PeerSpot reviewer
Senior Data Warehouse Architect at a media company

The documentation and install procedures cannot be any more straightforward. You get all the information you need from the documentation in a well structured form. We also got support from Vertica for the first setup. They made hardware configuration suggestions and involved us in any details to help us to understand the overall process. During installation, the scripts were check numerous hardware and software settings to help you achieve the best performance for your environment.

View full review »
PI
Vertica Database Architect at a tech consulting company with 51-200 employees

It's pretty straightforward to get the cluster up and running - assuming you follow the vendor recommendations closely. Getting your data in, setting up projections, optimizing queries, etc. is not as straightforward. If you’ve never used it before, save yourself hours of frustration and hire a Vertica consultant.

View full review »
it_user110262 - PeerSpot reviewer
Architect with 501-1,000 employees

It seemed to be very straightforward. However, we had an experienced consult to do the setup.

View full review »
ERICK RAMIREZ - PeerSpot reviewer
CEO at Imexperts Labs

The initial setup is straightforward. 

View full review »
MW
Director - Big Data, IoT and Analytics at a tech services company with 11-50 employees

Vertica is known for its ease of administration. I would say that the initial setup is easier than most.

View full review »
it_user102651 - PeerSpot reviewer
Lead Software Engineer - Theatrical Global at a marketing services firm with 1,001-5,000 employees

Setup and administration are very easy. Vertica was designed to be operational with minimal Database Administrator effort.

View full review »
it_user418314 - PeerSpot reviewer
Associate at a tech services company with 501-1,000 employees

It is straightforward if you read the documents and have mid to senior-level knowledge of Linux. Non-Linux admins will find the setup complex and cumbersome since most are Windows admin and they want point-and-click.

View full review »
it_user450444 - PeerSpot reviewer
BI Architect / Software Engineer at a tech services company with 51-200 employees

Initial setup of the database was straightforward.

View full review »
Jelson-Ghigonetto - PeerSpot reviewer
Senior Solution Architect at Grupo Cimcorp

The initial setup is straightforward and easy deployment.

View full review »
MW
Director - Big Data, IoT and Analytics at a tech services company with 11-50 employees

Setting up Vertica is pretty straightforward. There's nothing super fancy about deploying Vertica. Depending on what you're doing, deployment can take anywhere from 10 to 15 minutes to several hours. It's quick if you want to use the automatic tools, which work very well. And if you want to do your own thing or do it on-prem, then it's going to take you a little bit longer. And you don't need large teams to administer it afterward.

View full review »
it_user70134 - PeerSpot reviewer
Senior business Intelligence consultant at Asociación SevillaUP

No, the documentation is scarce on non standard setups. We had to create a virtual machine locally, set it up and then upload it to AWS.

View full review »
JG
Creator and Manager of Intelligent Water Loss Management Models at Qintess

The product is not easy to set up because you need a lot of training. It has less to do about the product itself, but the knowledge on how to use it. For example, the spreadsheet product Excel, If you don't know mathematics, you will have difficulty to make big Excel model and that's the same with the Vertica. It's just only a tool and depending on your capabilities to design what you need. 

View full review »
it_user505299 - PeerSpot reviewer
Management Consultant at a computer software company with 51-200 employees

Straightforward. Good docs helped a lot.

View full review »
it_user471384 - PeerSpot reviewer
CIO at a tech services company with 1,001-5,000 employees

There's a lot of complexities with the upgrade and costs of data failures. That was last year. It was kind of good that I forgot about those pain points.

View full review »
it_user427470 - PeerSpot reviewer
Technical Team Lead, Business Intelligence at a tech company with 501-1,000 employees

HP Vertica was in place when I joined the company, but it wasn't used as extensively as it is now.

View full review »
it_user515835 - PeerSpot reviewer
Solution Engineering and Arcitect - Big Data, Data Science and Cloud Computing at a tech services company with 1,001-5,000 employees

Initial setup was straightforward through the command line.

View full review »
it_user417525 - PeerSpot reviewer
Software Engineer at a marketing services firm with 51-200 employees

The initial setup was complex.

View full review »
JS
Sr. SW Engineer - Databases with 201-500 employees

Just getting Vertica running is straightforward. However, with an increasing number of customers, we had to develop our own tooling. For example:

  • Automated deployment
  • Monitoring, alerting
  • Backup/restore.
View full review »
it_user531828 - PeerSpot reviewer
Software and Data Architect at a computer software company with 1,001-5,000 employees

Pretty straightforward, the installation was simple and we added more nodes easily as we grew.

View full review »
it_user504552 - PeerSpot reviewer
Sr. Developer, Big Data at a comms service provider with 51-200 employees

Setup was very simple

View full review »
it_user624996 - PeerSpot reviewer
Architect at a comms service provider with 1,001-5,000 employees

Initial setup is straightforward.

View full review »
it_user505182 - PeerSpot reviewer
Data Scientist at a tech services company with 501-1,000 employees

Straightforward, very easy.

View full review »
Ricardo Díaz - PeerSpot reviewer
COO at a tech services company with 11-50 employees
MunkhsaikhanBayar - PeerSpot reviewer
Project Lead - Digital Transformation Unit at Bodi Electronics LLC

The initial setup is straightforward. 

View full review »
it_user692295 - PeerSpot reviewer
Staff Dev Lead - Analytics Data Storage at a tech services company with 1,001-5,000 employees

The setup per se was pretty straightforward. However, it took us some time to design the most efficient loading pattern from Hadoop.

View full review »
it_user567630 - PeerSpot reviewer
Senior Vice President Data at Adform

I wasn’t involved with that, but I think that those who did it were happy with the support.

View full review »
it_user539511 - PeerSpot reviewer
Database Administrator (DBA) at a computer software company with 501-1,000 employees

The installation procedure was reasonably straightforward, but earlier versions of Vertica were a bit more tricky due to libraries and dependencies. The docs were unclear in a few places during the installation, particularly with OS' that were not fully compatible with the required libraries. I expect those issues have been resolved in the newest version (8 at this time).

View full review »
it_user539496 - PeerSpot reviewer
Development Operations/SRE at a computer software company with 501-1,000 employees

Straightforward, was able to get the database up fairly quickly with minimal effort.

View full review »
it_user505317 - PeerSpot reviewer
DW Admin at a hospitality company with 1,001-5,000 employees

It was straightforward.

View full review »
it_user433491 - PeerSpot reviewer
Cloud Architect, Oracle ACE, Oracle DBA at Pythian

The setup was pretty straightforward as it doesn't take much; if you plan your infrastructure right, then it is a breeze.

View full review »
it_user533094 - PeerSpot reviewer
Lead Data Scientist Machine Learning at a financial services firm with 51-200 employees

Initial setup is a bit clunky, like most complex, tunable products can be.

View full review »
it_user848262 - PeerSpot reviewer
Hewlett Packard Enterprise Solution Architect at a tech services company with 11-50 employees

It is easy to integrate with EC2 instances.

View full review »
it_user464844 - PeerSpot reviewer
Big Data DBA & DevOps at a tech vendor with 51-200 employees

The earlier version wasn't that good to deploy, but now it's pretty easy to install. If you follow the documentation, you will be OK.

View full review »
it_user703536 - PeerSpot reviewer
Technical Leader / Business Intelligence Consultant with 11-50 employees

There are some considerations to be evaluated before you start the installation, but the installer does the respective checks so things will function properly. And there are a lot of options.

View full review »
it_user663669 - PeerSpot reviewer
Infrastructre Manager - Senior Maintenance Manager with 10,001+ employees

Easy setup. Much easier than setting up Oracle RAC.

View full review »
it_user505386 - PeerSpot reviewer
Senior Database Administrator; HP Vertica, MySQL, MSSQL, Cloud Ops at a tech vendor with 501-1,000 employees
it_user411165 - PeerSpot reviewer
Big Data, Analytics and Hadoop Expert, Vertica DBA (Technical Leader), Architecture Group at a tech vendor with 5,001-10,000 employees

The initial Vertica setup was really simple.

View full review »
it_user540294 - PeerSpot reviewer
Member of Technical Staff at a tech company with 1,001-5,000 employees

Well-organized, online documentation made the initial setup fairly straightforward.

View full review »
Buyer's Guide
Vertica
March 2024
Learn what your peers think about Vertica. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,578 professionals have used our research since 2012.