topic Re: Connecting to Teradata in ODS and Base Reporting

Connecting to Teradata

dbread007 — Mon, 20 Aug 2007 07:10:12 GMT

I am new to SAS but have completed PI & PII.

I am heavy Teradata user and want to know how to connect my SAS software to my TD server. Can someone provide details or point me in the right direction?

I am running SAS 9.1 Windows Version

Thanks

dbread007

Re: Connecting to Teradata

deleted_user — Mon, 20 Aug 2007 12:46:02 GMT

have you a licence for SAS/Access to Teradata, or SAS/Access to ODBC ?

Re: Connecting to Teradata

dbread007 — Mon, 20 Aug 2007 23:01:20 GMT

I have a license for SAS access to Teradata, thanks

Re: Connecting to Teradata

deleted_user — Tue, 21 Aug 2007 07:35:57 GMT

Find some examples in the various pieces of Teradata-specific SAS documentation:

SAS/ACCESS 9.1.3 Supplement for Teradata (SAS/ACCESS for Relational Databases), Second Edition**
This supplement explains how SAS/ACCESS software has been customized to accommodate the particular requirements and capabilities of your DBMS.

if you don't already have the book, I would recommend buying it : e.g.from
http://www.sas.com/apps/pubscat/bookdetails.jsp?pc=60844

(as I like both paper and searchable-electronic versions : ) It is available for download at http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_913/access_teradata_9298.pdf

SAS online doc for the web, points to Teradata at http://support.sas.com/onlinedoc/913/getDoc/en/acreldb.hlp/a002299548.htm

Good Luck
PeterC