HP Vertica
Hi,
We are using HP Vertica big data solution and we want to run queries to monitor the HP Vertica database.
Is there any option to access the HP Vertica from the LogicMonitor ?
https://www.connectionstrings.com/vertica/
Forum Discussion
Mike_RodriguesProduct Manager
@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.
