Find downloads for extending the Teradata Database. Probably the most popular way of doing so is through the use of User Defined Functions, or UDFs, which are routines that operate on data stored in relational tables. We've provided a bunch of these that provide functionality such as emulating common functions available in lesser databases such as DB2 or Oracle, message digest functions for SHA-1 and MD5, and date/time calculations. Remember, you can easily develop your own UDFs, and if you have a UDF that you'd like to share with the world, please contact us, and you might find your name up in lights. Also, if you're working with XML, check out Teradata XML Services, which provides an efficient gateway between the relational and XML document worlds.
Note that this site does not include all historical versions of downloads, so if you're can't find an older version here, please visit the legacy Teradata Download Center.
|
06 Nov 2009
Teradata Geospatial Import/Export Utilities 1.2 for Teradata 13.0 (Windows / Linux). For background information on Geospatial, see What can I do with Teradata’s Geospatial Support? And for community support, visit the Connectivity & Extensibility forum. |
|
|
02 Sep 2009
Teradata Geospatial Import/Export utilities for Windows and Linux. |
|
|
02 Sep 2009
The Teradata Geospatial Extension includes types, methods, functions, and utilities for loading, modeling, and analyzing spatial objects. |
|
|
20 May 2009
The Teradata Geospatial Extension includes types, methods, functions, and utilities for loading, modeling, and analyzing spatial objects. |
|
|
27 Feb 2009
Teradata XML Services provide assistance in database transformation of XML structures to and from relational structures. This is primarily an enterprise fit feature. XML in this context is regarded as a data format that is used to describe incoming or outgoing warehouse data. A key concept for this feature is that we are not transforming to store XML but rather to maintain a relational data model or to integrate relational data into an enterprise XML message structure! The relational data model is bested suited for enterprise analytics. XML structures are best suited for enterprise integration. |
|
|
23 Jun 2008
A Collection of UDFs that emulate the most-commonly used Oracle built-in SQL functions. |
|
|
16 Jun 2008
These UDFs implement difference determination in months/years using smaller units of granularity, days/months, to accurately calculate the difference. According to the ANSI SQL standard, units smaller than the unit of the result are to be ignored in an SQL calculation, but this can lead to results not consistent with business practices (Refer to NTA 1553). This distribution contains full source code, REPLACE FUNCTION SQL, a test suite and documentation. |
|
|
13 Jun 2008
This UDF implements the Secure Hash Algorithm, SHA-1, for computing a condensed representation of a message. When a message of any length < 264 bits is input, the SHA-1 produces a 160-bit output called a message digest (FIPS 180-1 / RFC 3174). This distribution contains full source code, a test suite, scripts, and documentation. |
|
|
13 Jun 2008
This UDF implements the MD5 message-digest algorithm. The algorithm takes as input a message of arbitrary length and produces as output a 128-bit "fingerprint" or "message digest" of the input (RFC1321). This distribution contains full source code, a test suite, scripts, and documentation. |
|
|
13 Jun 2008
This UDF implements the great circle distance algorithm to determine the distance in miles between two points expressed in longitude and latitude. This distribution contains full source code, REPLACE FUNCTION SQL, a test suite and documentation. |