Teradata Installation

venkatvelpula · Post by **venkatvelpula** » Tue Jul 15, 2008 1:54 pm

Hi,

Anyone, Please let me know the hardware and software components required for using teradata database stage for both server and parallel jobs.

I am trying find out information about installing teradata utilities foundation on all nodes for parallel jobs. If any one has links or docs, let me know.

John Smith · Post by **John Smith** » Wed Jul 16, 2008 9:37 pm

Have you tried the Teradata website?
In terms of h/w and s/w, that depends on what you need it for. Your question is too general.

venkatvelpula · Post by **venkatvelpula** » Mon Jul 21, 2008 2:46 pm

Let me know the check list of components, connecting to teradata db from datastage

John Smith · Post by **John Smith** » Mon Jul 21, 2008 7:22 pm

The Teradata Enterprise stage is installed when you install Datastage, so you don't need any checklist. Just do your typical install.

venkatvelpula · Post by **venkatvelpula** » Wed Jul 23, 2008 3:20 pm

I can see that teradata library's installed on the server. Do I need to install teradata utilities to use both server and parallel teradata db stage?

What needs to be configured initially to connect teradata db using odbc stage?

venkatvelpula · Post by **venkatvelpula** » Wed Jul 23, 2008 3:20 pm

I can see that teradata library's installed on the server. Do I need to install teradata utilities to use both server and parallel teradata db stages?

What needs to be configured initially to connect teradata db using odbc stage?

ray.wurlod · Post by **ray.wurlod** » Wed Jul 23, 2008 5:12 pm

Read about Teradata Utilities Foundation (TUF). That's basically what you need to have installed on your DataStage server machine (and also on any other machine in a cluster/grid from which you intend to access Teradata).

venkatvelpula · Post by **venkatvelpula** » Thu Jul 24, 2008 10:05 am

I know that teradata utilities foundation needs to be installed on datastge servers. Do we need to install odbc drivers for teradata to access using odbc stage?

What needs to be done to access new teradata db using odbc stage?

ray.wurlod · Post by **ray.wurlod** » Thu Jul 24, 2008 3:18 pm

Yes, you will need an ODBC driver to access any database using the ODBC stage. However, an ODBC driver for Teradata ships with DataStage. All you ought to need to do is configure the DSN (by editing the .odbc.ini file) and make it available to a project (by editing uvodbc.config in the project).

John Smith · Post by **John Smith** » Thu Jul 24, 2008 7:20 pm

venkatvelpula wrote:I know that teradata utilities foundation needs to be installed on datastge servers. Do we need to install odbc drivers for teradata to access using odbc stage?

What needs to be done to access new teradata db using odbc stage?

Typically you are better off using the Teradata Enterprise stage rather than ODBC for Teradata. So if you have TD Enterpise stage working you don't need odbc. The performance of TD Enterprise stage is much better as it is based on Teradata Fast load.

venkatvelpula · Post by **venkatvelpula** » Fri Jul 25, 2008 12:53 pm

Thanks for your reply Ray. Please let me know, how to pick and configure the odbc drivers provided by datastage?

ray.wurlod · Post by **ray.wurlod** » Fri Jul 25, 2008 7:25 pm

I did, in my previous post.

venkatvelpula · Post by **venkatvelpula** » Mon Jul 28, 2008 11:58 am

Ray,

Where can I find odbc drivers comes with datastage? Where to configure dsn?

ray.wurlod · Post by **ray.wurlod** » Mon Jul 28, 2008 4:04 pm

Premium membership will, among other things, allow you to read the entire posts of the five premium posters. Premium membership is one of the ways that the hosting and bandwidth costs of DSXchange are funded. It's not expensive (less than 30c, or Rs12) per day.