Search code examples
jdbcjmetervertica

How to connect Jmeter to Vertica DB

I have a question about checking vertica DB with Jmeter. I would like to create assertions on vertica DB with Jmeter. I added JDBC connection Configuration.

Can someone please advise about what to enter in Database URL beside the host IP and the port? what is the correct syntax? and what is the jar that I need to add?

regards

P.S after your help still I can not connect get the following error Cannot load JDBC driver class 'com.vertica.jdbc.Driver'

enter image description here

enter image description here

enter image description here

Solution

  • Database URL:

    jdbc:vertica://VerticaHost:portNumber/databaseName?user=username&password=password

    You need to know your VerticaHost and portNumber your Vertica DB installed and user and password that are available

    Driver Class:

    com.vertica.jdbc.Driver

    For Vertica 8.1 JDBC Jar you can download here, full list here.

    Put vertica-jdbc-8.1.1-0.jar in lib folder of JMeter:

    To use this driver, its containing .jar file (ex. mysql-connector-java-X.X.X-bin.jar) must be copied to the JMeter ./lib directory (see JMeter's Classpath for more details).

    See more in vertica docs.