Teradata Integration with SAP Webdynpro Java Applications

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.