HP Vertica

@Idan, you can certainly access HP Vertica from LogicMonitor, but you will need to install the Vertica JDBC driver on your collectors, and configure them to use it. It's a fairly simple process:
https://www.logicmonitor.com/support/terminology-syntax/scripting-support/adding-groovy-libraries-2/

Once you've done that, you can access the Vertica driver from an embedded Groovy script. You can probably get what you need by tweaking our JDBC recipe here: https://github.com/logicmonitor/monitoring-recipes/blob/master/Groovy/JDBC/Groovy_JDBC_MSSQL_Query.groovy

You won't be able to use the built-in JDBC Collection, Active Discovery, or debug methods with a custom driver.