Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member


Summary:

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


Introduction:

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: http://downloads.teradata.com/download/connectivity/jdbc-driver

  

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. 


Conclusion:

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


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

1 Comment
Labels in this area