All Forums Database
bhushan.koli 7 posts Joined 08/16
18 Aug 2016
Use teradata with jmeter

How to use jmeter with teradata to get performance stat?

Fred 1096 posts Joined 08/04
18 Aug 2016

Just as you would for any other database?
You can use the Teradata JDBC driver to submit SQL statements directly, and/or drive some application that uses Teradata on the back end.

tomnolan 594 posts Joined 01/08
18 Aug 2016

Documentation for how to configure a JDBC connection for JMeter is available here:
http://jmeter.apache.org/usermanual/component_reference.html#JDBC_Connection_Configuration
 
For the "JDBC Driver class" field in JMeter, specify com.teradata.jdbc.TeraDriver
 
For the "Database URL" field in JMeter, specify the appropriate Teradata JDBC Driver connection URL. Documentation about how to compose the Teradata JDBC Driver connection URL is available here:
http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#BABJIHBJ
 

tomnolan 594 posts Joined 01/08
18 Aug 2016

The Apache JMeter documentation says that the JDBC Driver's jar files must be present on JMeter's classpath, and also says that it is "easiest to copy .jar file into JMeter's /lib directory".
 
For the Teradata JDBC Driver, you should copy two jar files terajdbc4.jar and tdgssconfig.jar into JMeter's lib directory.

You must sign in to leave a comment.