Maven dependency for Teradata JDBC driver

As with Oracle drivers, closed source dependencies aren't usually hosted on open source repositories. You can install it in your local repository or use something like Nexus to do the job for your team/company.


I was also looking the same as you, and wasn't found in http://mvnrepository.com/tags/jdbc

Please Take a look at this URL : http://downloads.teradata.com/download/connectivity/jdbc-driver

Sample code :

Class.forName("com.teradata.jdbc.TeraDriver");
String connectionString = "jdbc:teradata://MyDatabaseServer/database=MyDatabaseName,tmode=ANSI,charset=UTF8";
String user = "username";
String passwd = "password";
Connection conn = DriverManager.getConnection(connectionString, user, password);

You should have both of the following jars in your classpath

terajdbc4.jar

tdgssconfig.jar


Do below step

  1. Download Teradata Jar from link
    • terajdbc4.jar
    • tdgssconfig.jar
  2. Move downloaded jars to a directory. For example : D://lib
  3. open Command Prompt(CMD) and go to directory (D://lib)
  4. execute below command
    • mvn install:install-file -DgroupId=com.teradata.jdbc -DartifactId=tdgssconfig -Dversion=14.00.00.21 -Dpackaging=jar -Dfile=tdgssconfig.jar
    • mvn install:install-file -DgroupId=com.teradata.jdbc -DartifactId=terajdbc4 -Dversion=14.00.00.21 -Dpackaging=jar -Dfile=terajdbc4.jar
  5. Update POM.xml with below dependencies

    com.teradata.jdbc terajdbc4 14.00.00.21 com.teradata.jdbc tdgssconfig 14.00.00.21