Tags for extensibility
High Performance Multi-System Analytics using Teradata QueryGrid
Today's analytic environments incorporate multiple technologies and systems. Getting value from these systems often requires that they work together to address business needs.
database extensibility connectivity uda QueryGrid
Teradata 15.0 QueryGrid
QueryGrid provides access to multiple data sources within UDA for Tera
database extensibility connectivity uda
Teradata 13.10 SQL Language Functions and User Defined Ordered Analytic Functions
Teradata 13.10 continues the strategy of delivering features that enable extending the Enterprise Data Warehouse functionality. SQL Language User Defined Function (UDFs) allows function to be implemented in SQL which is a natural fit for SQL writers. This session describes the feature and use cases. It also describes other enhancements in Teradata13.10 which includes User Defined Ordered Analytic Functions and new system functions for BIT, string and numeric processing.
udf extensibility functions ordered analytic
Let's talk about Stored Procedures
In my opinion stored procedures can be used to enforce standards for commonly used processes and to avoid the same code to be copied out into multiple scripts/programs creating a maintenance nightmare. But let's list some of the pro's & con's associated with stored procedures.
stored procedure extensibility
A few basic scalar string UDFs...
Following are some basic scalar UDFs we've written to deal with strings of text.
extensibility string parsing decode encode url parsers right function scalar udf example vector list