Teradata is a popular Relational Database Management System (RDBMS) suitable for large data warehousing applications. It is capable of handling large volumes of data and is highly scalable. This tutorial provides a good understanding of Teradata Architecture, various SQL commands, Indexing concepts and Utilities to import/export data.
Teradata Studio is an administration toolkit that helps users to create and administer database objects. It also provides a SQL Editor and Result Set Viewer for retrieving and displaying data fron your Teradata Database systems (Teradata, Aster, and Hadoop). It is built on the Eclipse Rich Client Platform (RCP). For more information on Teradata Studio, refer to the article Teradata Studio.
Teradata Studio contains several open-source components. A package containing the source code and licenses for these components is also available for download. This package does not contain proprietary Teradata source code.
Teradata Studio is a fully supported product by Teradata.
16.10 - Data Import and Export - Teradata Studio Teradata Studio Express User Guide prodname Teradata Studio vrmrelease 16.10 createddate June 2017. In this pane, you can also select a table or a view from the database. To open the pane: In SQL Server Data Tools, open the SSIS package that contains the Teradata source. On the Data Flow tab, double-click the Teradata source. In Teradata Source Editor, select the Connection Manager tab.
For community support, please visit the Teradata Studio Forum.
Teradata Studio is the client used to perform database administration task on Aster and Teradata databases, as well as moving data from and to Hadoop. Recently I was asked to test a solution to integrate Hadoop with Teradata in order to build a modern Data Warehouse architecture, this was my first step and I want to share it with you. Teradata 4 Teradata provides Teradata express for VMWARE which is a fully operational Teradata virtual machine. It provides up to 1 terabyte of storage.
For release specific information , please go though the Readme documentation.
Teradata Studio 16.20.10(+).XX will support OpenJDK versions 8 and 10 from any distributor. The recommended distributor is Azul.
Depending on Operating System, either JDK or JRE must be installed.
• Mac OS requires JDK
• Linux or Windows requires JDK or JRE
Azul Zulu OpenJDK Installation
1.Download required Java version 8 or 10 or 11 depending on your operating system:
• Azul Open JDK 8 (Choose the platform to download): https://www.azul.com/downloads/zulu/
• Azul Open JDK 10 for Linux: https://www.azul.com/products/zulu-and-zulu-enterprise/download-java-10-for-linux/
• Azul Open JDK 10 for Windows: https://www.azul.com/products/zulu-and-zulu-enterprise/download-java-10-for-windows/
2. Follow steps specified in the Zulu Installation Guide at https://docs.azul.com/zulu/zuludocs/ depending on your operating system
Oracle JDK Installation
1. Download r equired Oracle Java version 8 or 10 or 11 depending on your operating system.
• Java 8: Java SE Downloads
• Java 10: Java SE Downloads
• Java 11: Java SE Downloads
2. Follow steps specified in the Installation Instructions section at the respective JavaSE Downloads website.
- Teradata Tutorial
- Teradata Basics
- Teradata Advanced
- Teradata Useful Resources
- Selected Reading
This chapter discussed the various strategies of user management in Teradata.
Users
A user is created using CREATE USER command. In Teradata, a user is also similar to a database. They both can be assigned space and contain database objects except that the user is assigned a password.
Syntax
Following is the syntax for CREATE USER.
While creating a user, the values for user name, Permanent space and Password is mandatory. Other fields are optional.
Example
Following is an example to create the user TD01.
Accounts
While creating a new user, the user may be assigned to an account. ACCOUNT option in CREATE USER is used to assign the account. A user may be assigned to multiple accounts.
Syntax
Following is the syntax for CREATE USER with account option.
Example
The following example creates the user TD02 and assigns the account as IT and Admin.
The user can specify the account id while logging into Teradata system or after being logged into the system using SET SESSION command.
Grant Privileges
GRANT command is used to assign one or more privileges on the database objects to the user or database.
Syntax
Following is the syntax of the GRANT command.
Privileges can be INSERT, SELECT, UPDATE, REFERENCES.
Example
Following is an example of GRANT statement.
Revoke Privileges
Teradata Studio Odbc Connection
REVOKE command removes the privileges from the users or databases. The REVOKE command can only remove explicit privileges.
Syntax
Following is the basic syntax for REVOKE command.
Teradata Studio
Example
Following is an example of REVOKE command.