In this article, I am going to introduce how to install Teradata Express in virtual machines in Windows.
1) Download VMware Player for Windows 32-bit and 64-bit from the following link (version 6.0):
https://my.vmware.com/web/vmware/free#desktop_end_user_computing/vmware_player/6_0
This is a free software for personal use.
2) Download TDE 15.00.00.08 SLES 10 for VMware (40GB) viewpoint: http://downloads.teradata.com/download/database/teradata-express/vmware.
This is the latest version of Teradata Express edition.
1) Install VM Player 6.0. Please turn off Windows feature Hyper-V off in your PC (restart required); otherwise you cannot open VM in the VM Player.
2) Extract the file TDExpress15.0.0.8_Sles10_40GB_vp.7z to a folder.
3) Open VMware Player
4) Choose ‘Open a Virtual Machine’ and select the file ‘TDExpress15.0.0.8_Sles10.vmx’
And now the setup work is done. As you can see, the OS is SUSE Linux Enterprise 10 64-bit and version is Workstation 6.5-7.x virtual machine.
Just click ‘Play virtual machine’ and you are entering the world of Teradata.
You can also download and update VMware Tools for Linux for latest version (version 9.6.2) as recommended.
After some setups, you will be able to see the login window:
Login: root, Password: root.
After login, you can see the desktop:
Teradata Studio Express is also included in this virtual machine.
Run ‘Viewpoint Start’ / 'Viewpoint Stop’ to start/stop all the Teradata services.
In the studio, connect to the local Teradata database:
Driver: Teradata embedded JDBC
Database Server Name: localhost
User Name/Domain: dbc
Password: dbc
Authentication Mechanism: PASSWORD_PROTECTED
After connection is established, run the query below:
select * from DBC.Accounts;
The result will be similar to the following screenshot:
For more details, visit the following site about how to use this tool:
http://developer.teradata.com/tools/articles/teradata-studio-express
This page summarize some of the commonly used views in Teradata. Conventions In all the views in the following sections, X views are also available though they only return rows that contain information on objects that the requesting database user owns, created, granted privilige on,...
View detailTeradata published an official Python module which can be used in DevOps projects. More details can be found at the following GitHub site: https://github.com/Teradata/PyTd Install Teradata module ...
View detailThis post summarizes the tutorials I created in the past about Teradata. It is trying to help you gain the basic SQL skills with Teradata especially if you are a new beginner or you just move from SQL Server or Oracle. It also includes some guides about setting up your own Teradata server (latest Teradata Express version TDExpress16.10.00.03_Sles11_40GB.7z).
View detailThis page provides the steps to create a Teradata database in Microsoft cloud computing platform Azure.
View detailFor many SQL Server or Oracle developers, you may encounter some inconveniences when writing SQL queries. For example, how to select from dummy table or local defined variables. This page summarize the equivalents in Teradata SQL.
View detailThis post summarize the common functions that are used when dealing with DateTime datatypes in Teradata.
View detailRaym*** about 11 months ago
@Raju
In which step you could not type password? In this tutorial, there are two places:
Ra*** about 11 months ago
i installed teradata in vmware player.but i am unable to type password. it is not taking input to password.please anyone help me.where am going wrong.
Ra*** about 2 years ago
@Matt
If you followed all the steps, in the UNIX virtual machine, Teradata Studio Express is already included. You can use that tool to connect to the Teradata server using dbc account and then create any database you like.
Alternatively, please follow the link below to setup client tools in your Windows (host machine for the Teradata VM), which will enable you to connect directly:
You can use Teradata Administrator client tool if you are not familiar with SQL.
Ma*** about 2 years ago
@Matt I simply don't have the Create Data base in the Tools. I am very new to Teradata.
Ra*** about 2 years ago
@Matt what is the error message you got when creating database?
Did you follow all the steps including logging with dbc user?
Ma*** about 2 years ago
Did all that. But still can't create a database. I need to create a database and them tables to load some data. So I can play with that? Could you please show us?
Ra*** about 2 years ago
srini*** about 2 years ago
Ra*** about 3 years ago
Ni*** about 3 years ago
Ni*** about 3 years ago
Ra*** about 5 years ago
Ra*** about 3 years ago
saj*** about 3 years ago
Ra*** about 3 years ago
vi*** about 3 years ago
vi*** about 3 years ago
Ra*** about 5 years ago
sasa*** about 5 years ago
Ra*** about 5 years ago
ma*** about 5 years ago
ma*** about 5 years ago
Ra*** about 5 years ago
ma*** about 5 years ago
ma*** about 5 years ago