Skip to Content


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

Image1.png  

Unzip the downloaded zip file.

/wp-content/uploads/2014/04/image2_432684.png

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

/wp-content/uploads/2014/04/image3_432685.png

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

/wp-content/uploads/2014/04/image4_432686.png

The JDBC Driver for Teradata database is created.

/wp-content/uploads/2014/04/image5_432687.png

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

/wp-content/uploads/2014/04/image6_432688.png

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.

/wp-content/uploads/2014/04/image7_432698.png

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

/wp-content/uploads/2014/04/image8_432699.png

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

/wp-content/uploads/2014/04/image9_432700.png

Code to test the JDBC Connection:

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

/wp-content/uploads/2014/04/image10_432704.png


Conclusion:

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


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

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply