Applications covers the world of Teradata apps, including apps offered by Teradata (such as TRM or DCM), as well as best practices and methodologies for building your own Teradata-connected apps.

Expand All Subscribe to Teradata Developer Exchange - Applications content The Latest
Integrating Teradata ADS Generator with Fuzzy Logix DB Lytix

Teradata ADS Generator, part of the Teradata Warehouse Miner family of products, was built to support both comprehensive data profiling as well as analytic data generation for Teradata customers.  Neither the data profiling nor the analytic data set generation capabilities of the product require any movement of data outside of the warehouse and utilize as much of the data as the analyst or data scientist requires.  Results and metadata are stored directly in the database while utilizing the parallel, scalable processing power of the Teradata platforms to perform data intensive operations.

Solving Business Problems with SQL

The presentation is to acquaint business users with Structured Query Language (SQL) and some interesting techniques to access their data with examples for using CASE; Subqueries and Correlated Subqueries; Types of SQL joins and how they are implemented on Teradata; facts about NULLs; Derived Table usage and other interesting optimizer information.

Presenter:  Alison Torres - Teradata Corporation

Teradata Warehouse Miner 5.3.5 Express Edition available for download

Teradata Warehouse Miner provides an array of data profiling and mining functions ranging from data exploration and transformation to analytic model development and deployment that are performed directly in the Teradata Database. While many data mining solutions require analysts to extract data samples to build and run analytic models, Teradata Warehouse Miner allows you to analyze detailed data without moving it out of the data warehouse, thus streamlining the data mining process.

Teradata Warehouse Miner, and its derivative products Teradata Analytic Data Set (ADS) Generator, Teradata Data Set Builder for SAS and Teradata Profiler, can provide both a framework for the data mining process and a significant savings of time and resources in implementing the process.

Updated teradataR version 1.0.1 package available for download

An updated version of the teradataR package is now available here.

Enhancements included with this new 1.0.1 release include:

Accessing System Logs for Teradata/Aprimo Relationship Manager 6.3

How do I find the system, error, or PE log files for Aprimo Relationship Manager (formerly Teradata Relationship Manager)?

Teradata MDM: What’s New in Release 3.1

This webcast highlights the new features and benefits of Teradata MDM 3.1.  The runtime-only Lookup Reference Data Management (LRDM) feature introduced in MDM 3.1 is emphasized.

Using Teradata Query Banding to handle Security Views

One of the biggest benefits of Query Banding is the ability to pass parameters into an SQL script.

Establishing an associative security table lookup between a userid and allowable company codes may allow easy access to the base data tables.  

In-database analytics with TeradataR

Please note, we are no longer supporting teradataR since the decision was made for Teradata to focus on our partnership with Revolution for R integration with Teradata.

R  is an open source language for statistical computing and graphics. R provides a wide variety of statistical (linear and nonlinear modeling, classical statistical tests, time-series analysis, classification, clustering) and graphical techniques, and is highly extensible. This free package is designed to allow users of R to interact with a Teradata database.  Users can use many statistical functions directly against the Teradata system without having to extract the data into memory.

TRM Server Logging - Advanced Topics

In this post, we will cover some more advanced logging topics in TRM, including PE logging, SQL output, user clicks, authentication attempts, and startup logging.

TRM Server Logging Basics

This article describes the basics of TRM's V6 logging in the application server. This includes log file configuration, versioning, location and content.

Pages