Skip to main content

Connect to Vantage using JDBC

Overview

This how-to demonstrates how to connect to Teradata Vantage using JDBC using a sample Java application: GitHub JDBC.

Prerequisites

  • Access to a Teradata Vantage instance.
Note

If you need a test instance of Vantage, you can provision one for free at https://clearscape.teradata.com

  • JDK
  • Maven

Add dependency to your maven project

Add the Teradata JDBC driver as a dependency to your Maven POM XML file:

Code to send a query

Note

This step assumes that your Vantage database is available on localhost on port 1025. If you are running Vantage Express on your laptop, you need to expose the port from the VM to the host machine. Refer to your virtualization software documentation how to forward ports.

The project is set up. All that is left, is to load the driver, pass connection and authentication parameters and run a query:

Run the tests

Run the tests:

Summary

This how-to demonstrated how to connect to Teradata Vantage using JDBC. It described a sample Java application with Maven as the build tool that uses the Teradata JDBC driver to send SQL queries to Teradata Vantage.

Further reading

Note

If you have any questions or need further assistance, please visit our community forum where you can get support and interact with other community members.

Also of interest