Skip to Content
Author's profile photo Former Member

Teradata Integration with SAP Webdynpro Java Applications


This document includes demonstration of how to integrate and access Teradata database through SAP Webdynpro Java Applications.


Teradata and SAP deliver analytical solutions to industries with high data-volume requirements. Combining the power of Teradata’s flexible and scalable analytics platform and superior database with SAP’s leading enterprise applications, Teradata and SAP can:

Deliver superior business functionality and performance

• Help you efficiently and cost effectively manage ever-increasing data volumes

• Provide a deeper, industry-focused analysis of your enterprise

• Improve decision making, reduce operational costs and deliver a rapid return on investment

• Drill detailed, enterprise-wide data, getting answers to previously impossible business questions

• Eliminate redundant costs associated with departmental analytics — including redundant servers, data management tools and support costs

SAP users need access to small data sets that reside in Teradata. To access this data, a JDBC call to Teradata can be initiated.

The steps are as follows:

1. The Teradata JDBC Driver enables Java applications to connect to the Teradata Database.

Download the jars from the link:


Unzip the downloaded zip file.


2. Go to SAP NetWeaver Administrator using the link: http://<host>:<port>/nwa

Select Configuration Management –> Infrastructure –> Application Resources

Under Application Resources, Select Create New Resource -> Deploy new JDBC driver

Create a new JDBC driver – say, Teradata_tst


Select Add New Driver File – Select and add the jar files – tdgssconfig and terajdbc4. Click on Save


The JDBC Driver for Teradata database is created.


3. Next, Under Application Resources, Select Create new resource -> New JDBC Custom Datasource


Following details are required to create a data source:

  • Driver Class Name: com.teradata.jdbc.TeraDriver
  • Database URL: jdbc:teradata://localhost/database=test   
  • Driver Name: Select the previously created JDBC Driver, here Teradata_tst

4. Go to Dependent DataSource Aliases tab, Select Add New Alias and add a name to it.


Now, we have custom Data source and an alias for it.


The status shows in GREEN – fully available for the created Custom Data source.


Code to test the JDBC Connection:

The JDBC code to connect to Teradatabase can be implemented through Webdynpro Java DC or EJB. 



Following these steps would help in the integration of Teradata database with webdynpro Java applications.

***Please feel free to comment and make suggestions.

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Rakesh Kumar
      Rakesh Kumar

      Hi Arpitha,

      Nice and Helpful document! Thanks! 🙂


      Rakesh Singh