Setup host server for Studio Express

Teradata Studio
Enthusiast

Setup host server for Studio Express

Hi All,

I installed Studio express on my personal machine for practice purpose. When I try to create a new data source, it asks the server host name. I was wondering if I can give my machine's IP address as the server address.

And what I mean to ask is does the teradata database get installed when I install studio express?

Thanks,

Aarsh

22 REPLIES
Teradata Employee

Re: Setup host server for Studio Express

Aarsh, No. but just the opposite. Teradata Express is a VM that contains a Teradata Database. It also contains Teradata Studio Express inside the VM, for accessing the Teradata Database.

Enthusiast

Re: Setup host server for Studio Express

Thank you fgrimmer for your reply.

Can you please also let me know what VMWare should I install on my machine?

Thanks,

Aarsh

Teradata Employee

Re: Setup host server for Studio Express

Aarsh, Here is the download page for Terdata Express for VMWare. It should provide you with the information you need (http://downloads.teradata.com/download/database/teradata-express/vmware)

Enthusiast

Re: Setup host server for Studio Express

hi,

how can we create database through new connection profile in teradata studio express.

Teradata Employee

Re: Setup host server for Studio Express

Jyothsna, You will need to execute the CREATE DATABASE statement in the SQL Editor.

1. Create a new Connection Profile and connect to your Teradata Database.

2. In the Data Source Explorer, select the Teradata Database connection and in the DSE toolbar, choose Open SQL Editor option. This will open a SQL Editor window with your Teradata Database connection.

3. In the SQL Editor, enter your CREATE DATABASE command and right click and Execute All.

Enthusiast

Re: Setup host server for Studio Express

GUys, how to do this:

1. Create a new Connection Profile and connect to your Teradata Database

What is server name on fresh TD install on VM player?

V

Enthusiast

Re: Setup host server for Studio Express

Jyothsna, hold on 

I found a good video http://developer.teradata.com/tools/articles/teradata-studio-usage-videos ...

Alas it still start with <<after you succefully install connection to TD>>

Can anybody help us with very first steps...

Thanks

M

Enthusiast

Re: Setup host server for Studio Express

Jyothsna, evrika !!!! 

check this link:

http://developer.teradata.com/database/articles/teradata-express-14-0-for-vmware-user-guide

Server name : 127.0.0.1

User name:  dbc

Password:  dbc

Enthusiast

Re: Setup host server for Studio Express

What it SQL Scrap book in Studio, is it same  like SQL Editor ?

Also see that tree for Data Source is bit different then in any description/tutorial:

DBC

 ..|_Schema     -- waht s this database or schema ???????

......|_Retail.....