Teradata Exadata

Teradata vs Exadata comparison:

Exadata is still Oracle:
http://www.teradata.com/t/white-papers/Exadata-the-Sequel-Exadata-V2-is-Still-Oracle/?type=WP

Exadata is still more Oracle:
http://www.youtube.com/watch?v=25gV37PfYuY

Oracle Teradata

Oracle Teradata comparison:

Exadata is still Oracle:
http://www.teradata.com/t/white-papers/Exadata-the-Sequel-Exadata-V2-is-Still-Oracle/?type=WP

Exadata is still more Oracle:
http://www.youtube.com/watch?v=25gV37PfYuY

Teradata to Oracle migration:
http://www.oracle.com/technetwork/database/migration/teradata-089107.html

Oracle to Teradata migration:
http://www.teradata.com/data-warehouse-migration/oracle-migration-services/

Migration from Oracle to Teradata:
http://www.teradata.com/podcasts/Migration-from-Oracle-to-Teradata/

Teradata BTEQ

BTEQ is an abbreviation of Basic Teradata Query, which is a general-purpose, command based program that allows users on a workstation to communicate with one or more Teradata Database systems, and to format reports for both print and screen output. Using BTEQ you can submit SQL queries to Teradata Database. BTEQ formats the results and returns them to the screen, a file, or to a designated printer.

Teradata BTEQ documentation:
http://developer.teradata.com/sites/all/files/documentation/linked_docs/2414020A_BTEQ-Reference-13.10.pdf

Teradata PDF

Teradata Studio Express

Teradata Studio Express is a toolkit for Teradata Database systems and allows the data to be manipulated and stored on the desktop. It is built on the Eclipse Rich Client Platform (RCP).

Teradata Studio Express download:
http://downloads.teradata.com/download/tools/teradata-studio-express

Teradata Studio Express help:
http://developer.teradata.com/tools/articles/teradata-studio-express

Teradata SQL Assistant

Teradata SQL Assistant download

Teradata SQL Assistant for Windows (Teradata Tools and Utilities - Windows Installation Package):
http://downloads.teradata.com/download/tools/teradata-tools-and-utilities-windows-installation-package

Teradata SQL Assistant Java Edition:
http://developer.teradata.com/tools/articles/sql-assistant-java-edition

Teradata download

Download Teradata 13.10

Teradata Express for VMware is a free, fully-functional Teradata database.

Teradata Express for VMware Player:
http://downloads.teradata.com/download/database/teradata-express/vmware

VMware Player:
http://www.vmware.com/products/player/

Teradata SQL

Teradata SQL reference documentation (Teradata 13.10):

SQL Data Manipulation Language:
http://www.info.teradata.com/edownload.cfm?itemid=102320040

SQL Functions, Operators, Expressions, and Predicates:
http://www.info.teradata.com/edownload.cfm?itemid=102320046

SQL Data Definition Language - Detailed Topics:
http://www.info.teradata.com/edownload.cfm?itemid=102320036

SQL Data Definition Language - Syntax and Examples:
http://www.info.teradata.com/edownload.cfm?itemid=102320038

SQL External Routine Programming:
http://www.info.teradata.com/edownload.cfm?itemid=102320044

Connecting to a Teradata database using Teradata JDBC driver

Teradata JDBC driver enables all Java applications to connect a Teradata database using a well-established industry standard Java Database Connectivity (JDBC) API interface. The latest version of the JDBC driver is release 13.00 and it is available for download on Teradata Download Center together with sample Java code.

The driver is backward compatible and release 13.00 supports Teradata Database V2R6.0, V2R6.1, V2R6.2, 12.00 and 13.00. The full list of new and noteworthy features accompanied with detailed release notes is available in the README file.

A new database connection can be obtained in a standard JDBC way by using java.sql.DriverManager.getConnection method with a proper connection string to get a new instance of java.sql.Connection.

The simplest database connection string would be:

jdbc:teradata://ServerHost/database=MyDatabaseName

There is a number of available connection parameters, all are described in detail in the Teradata JDBC Driver User Guide:

ACCOUNT=account_id
CHARSET={ASCII/LATIN1_0A/KANJISJIS_0S/KANJIEUC_0U/LATIN9_0A/LATIN1252_0A/HANGULKSC5601_2R4/SCHGB2312_1T0/TCHBIG5_1R0/UTF8/UTF16}
COMPAT_DBS=true/false
COMPAT_ISAUTOINC=true/false
COMPAT_ISCURRENCY=true/false
COMPAT_ISSIGNED=true/false
COMPAT_ISSEARCH=true/false
COMPAT_ISREADONLY=true/false
COMPAT_ISWRITABLE=true/false
COMPAT_ISDEFWRIT=true/false
COMPAT_GETSCHEMA=ReturnValue
COMPAT_GETTABLE=ReturnValue
DATABASE=default database name
DBS_PORT=number
ENCRYPTDATA={ON/OFF}
GOVERN={ON/OFF}
LOB_SUPPORT={ON/OFF}
LOB_TEMP_TABLE=tableName or databaseName.tableName
LOG={ERROR/INFO/DEBUG}
LOGDATA=varies according to the LOGMECH selection
LOGMECH={TD1/TD2/KRB5/LDAP}
NEW_PASSWORD=new password string
PARTITION= {DBC/SQL,MONITOR}
SESSIONS=n, where 1 <= n <= number of AMPs
SP_SPL={SPL/NOSPL}
TMODE={ANSI/TERA/DEFAULT}
TSNANO={0...6}
TYPE={DEFAULT/FASTLOAD/FASTEXPORT}
USEXVIEWS={ON/OFF}

In example, to connect to a Teradata database using ANSI session mode and UTF-8 charset the connection string should be built as follows:

jdbc:teradata://ServerHost/database=MyDatabaseName,tmode=ANSI,charset=UTF8

A sample Java code snippet for obtaining a database connection would look as follows:

Class.forName("com.teradata.jdbc.TeraDriver");
String connectionString = "jdbc:teradata://MyDatabaseServer/database=MyDatabaseName,tmode=ANSI,charset=UTF8";
String user = "username";
String passwd = "password";
Connection conn = DriverManager.getConnection(connectionString, user, password);

Please note that to allow the JVM to access the com.teradata.jdbc.TeraDriver class, the driver classes located in terajdbc4.jar and tdgssconfig.jar files (yes, you need both) should be available in the classpath.

In case of any issues please refer to Teradata JDBC FAQ, Teradata JDBC Driver User Guide and online code samples.

Additional reference:

JDBC driver FAQ: http://www.teradata.com/DownloadCenter/Topic9403-98-1.aspx
Teradata JDBC Driver User Guide: http://www.info.teradata.com/eDownload.cfm?itemid=082310004&type=TD
JVM support matrix: http://www.teradata.com/DownloadCenter/Topic9391-98-1.aspx

Teradata SQL Assistant Tips and Tricks

Teradata SQL Assistant is one of the most commonly used development tools for Teradata database, so just in case you are not familiar with the options and shortcuts listed below that are really basic and greatly improve your daily productivity, please find them below:

Multiple tabs in Teradata SQL Assistant: just press Ctrl-N to open a new query window in a new tab
Query Builder: F2
Format query: Ctrl-Q
Context menu: Shift-F10
Insert current date: Shift-F10, I (like in Insert)
Search and Replace: Ctrl-H
Move the current line UP or DOWN: Alt-Up or Alt-Down
Display line numbers: menu Tools > Options... > tab: Formatting > Display line numbers

Do you use any other shortcuts or options in SQL Assistant on daily basis? You are more than welcome to share them, just drop a comment.

Teradata Help - Teradata Database Tips and Tricks