Database

The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies. Plus, you'll receive expert data warehouse training and the advice of the industry's most experienced data warehouse consulting professionals. You can submit Teradata Database Enhancement Requests here.

Expand All Subscribe to Teradata Developer Exchange - Database content The Latest
Teradata on VMware Developer Tier and Developer Tier Preconfigured

Developer Tier is a SUSE Linux Enterprise Server (SLES) operating system and Teradata Database packaged into a virtual container that runs in a VMware vSphere ESXI virtualized environment on third-party hardware. There are two variants of the Developer Tier including a Preconfigured version and the regular version.

Teradata Developer Tier (Preconfigured) is a simplified version of Teradata Database Developer Tier that allows you to deploy Teradata Database on VMware quickly and easily using the OVA template. Networking is already configured to use DHCP, and you can add storage to the system. The Preconfigured version enables you to deploy only the Database and the instructions are available in a separate user manual on this download page.

The full Developer Tier consists of an OVA file template and associated property files and scripts for deploying the Teradata Database and the associated Teradata ecosystem products. Once deployed by the VMware administrator, Developer Tier can be used to evaluate Teradata on VMware and the Teradata Database and the associated ecosystem products.

 

Note: You must have administrative privileges on the destination VMware environment to install and configure Developer Tier virtual machines.

 

The Linux OVA contains Teradata Studio, Teradata version of Jupyter Lab, Apache Superset and instructions (with a script) to install Precog on the OVA after it's installed. 

To get the Jupyter access token, login as user "tdc" and run "docker ps" to view the running images. Next run "docker logs <jupyter image id>" to view the Jupyter access token. 

The login and password for the Linux OVA is tdc/teradata2022

For feedback, discussion, and community support, please visit the Cloud Computing forum.

Release 17.10  -  18 Nov 2021
Bring Your Own Model (BYOM)

Bring Your Own Model Overview

The ability to score H2O MOJO OpenSource and Driverless AI (DAI) models has been added to the BYOM product via the H2OPredict function.  While there are no extra steps necessary to use the function to score H2O MOJO OpenSource models, there is a requirement to have a license key from H2O to be able to score the Driverless AI models.  This license key must be inserted into a Teradata table and used within the query to score H2O MOJO DAI models.  

 

Release 02.00.00.00  -  18 Oct 2021
Teradata Vantage Express (VMware, VirtualBox, UTM)

Download Teradata Vantage Express, a free, fully-functional Teradata Vantage database, that can be up and running on your system in minutes. Please download and read the user guide for installation instructions.

Release 16.10.00.03, 16.20, 17.05, 17.10  -  31 Aug 2021
VMware OVA with Teradata Studio, Jupyter Lab, Apache Superset, installer for Precog's Universal Data Connector

This is a VMware OVA that contains Teradata Studio, Teradata version of Jupyter Lab, Apache Superset and instructions (with a script) to install Precog on the OVA after it's installed. 

To get the Jupyter access token, login as user "tdc" and run "docker ps" to view the running images. Next run "docker logs <jupyter image id>" to view the Jupyter access token. 

For feedback, discussion, and community support, please visit the Cloud Computing forum.

Release 17.05  -  12 Aug 2021
Native Object Store Example Dataset Download

ABOUT THIS DOWNLOAD

The download contains the td-usgs dataset. This data is used in examples in the Teradata Vantage™- Native Object Store documentation. USGS Surface-Water Data Sets are provided courtesy of the U.S. Geological Survey.

The data has been converted into CSV, JSON, and Parquet data formats.

Click the attachment link to download the zipped dataset, unzip the file using your preferred method, and upload the folders in the resulting directory into your object store of choice.

Article by cl186084 27 Apr 2020
Planning Extended Teradata System outages with Unity 15.10

Benjamin Franklin once observed "...in this world nothing can be said to be certain, except death and taxes". Planned down time can easily be added to that list. It's a certainty that any given IT system will require some planned down time to address security fixes, make configuration changes, or expand storage and compute capacity. Smart businesses always stay ahead of these demands, and promptly patch or upgrade their systems, but that often comes with a cost in down time.

Article by Paul LaPointe 29 Aug 2016
Why not Columnar with a Primary Index? What's a PA?
Columnar with a primary index (PI) is supported in Teradata Database 15.10. But what are the caveats in using it?
Training by STarnow 23 Aug 2016
The Instant Gratification of Real Time
The latest buzz in analytics is “Real Time”.  And users’ expectations are now set by their phone apps.
Training by STarnow 21 Jun 2016
Six Habitual Architecture Mistakes and How to Avoid Them

Is your architecture characterized by excessive costs, supportability issues and business dissatisfaction?

Training by STarnow 09 Jun 2016
Simplify User Management using Roles and Profiles

This session defines what roles and profiles are, why they are important, how they are implemented, and how to use them.

Training by STarnow 16 May 2016

Pages