VBA Query Vertica database and populate to excel

Question

I run a Vertica database query (using squirrel-sql tool). Is it feasible to complete this task with Excel and populate a worksheet? Does anyone have a suggestion about how to resolve this?

Nothing regarding this can be found online. I know the hostname, port name, user name, and location of the driver.

Answer 1

You can query Vertica directly from excel. I did it and it works, just download the ODBC driver, install the driver, setup DNS and follow to instructions.

For version 7. x, read here

Full documentation: Installing the Client Drivers and Tools on Windows

1. Download Windows Client Drivers from here. Excel requires ODBC drivers.
2. Install drivers(double click on exe file -> next -> next -> profit!!).
3. Set up ODBC DNS, instructions are here
4. Follow to instructions here
5. profit!