Newbie: Connecting Teradata, Access Sample Databe, Creating Users.

Connectivity

Newbie: Connecting Teradata, Access Sample Databe, Creating Users.

Hi,

Iam newbie to Teradata. I downloaded and installed Teradata Express database 13.0 (default setup) on my windows xp pro sp3 successfully.

Here I am little bit confusing what are the username/password to connect in SQL Assistant. How to connect samples in SQL Assistant.?

Do I need configure any thing like system variables.. and modify host files? some where I saw. (hopefully it doesnot require.).

1). What is database name of teradata? (In oracle "orcl" if we do not change the database name).

2). How to connect to admin and create users.

3). How to connect to sample schema (like scott/tiger in oracle. what are the credentials?) ?.

is there any document to go through.. I mean not a 1000 pages book... just to overview of that....

Help would be appreciable.

Thanks.

SRI.

2 REPLIES

Re: Newbie: Connecting Teradata, Access Sample Databe, Creating Users.

No one knows about it?

Senior Apprentice

Re: Newbie: Connecting Teradata, Access Sample Databe, Creating Users.

IIRC there was some accompanying stuff with info about the the existing users and databases, if this is the 32-bit windows version (not the VMWare) there's a HELP file, too. And there were some predefined ODBC entries for connection.

Nevertheless, to connect to a single node TD you can simply it's ip-address, in this case localhost 127.0.0.1.

Username/password: dbc/dbc

Dieter