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: 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.
Following these steps would help in the integration of Teradata database with webdynpro Java applications.
***Please feel free to comment and make suggestions.