How do I connect to a Teradata database from Windows?
Altair EmployeeIn order to connect to a Teradata server from a Windows operating system you will need to:
1. Install a 64bit Windows Teradata client 14.10 or later via the Teradata client installation kit "TeradataToolsAndUtilitiesBase" (TTU). At the minimum you need:
[ ] ODBC Driver for Teradata
[ ] Teradata Parallel Transporter Base.
This should produce a single entry in your Control Panel->Programs and Features such as 'Teradata Tools and Utilities - Base 16.20'
2. Your Windows 'path' environmental variable should have been automatically updated to add a Teradata path of the form C:\Program Files\Teradata\Client\16.20\bin. SLC depends on the two shared libraries called wincli32.dlll and telapi.dll. Please ensure they are present in the "bin" folder.
3. Restart the Workbench to pickup the new 'path' variable you are ready to access Teradata from your sas language program using steps such as:
libname tlib teradata user=<YOUR_USERNAME> password=<YOUR_PASSWORD> server=<YOUR_SERVER> database=<YOUR_DATABASE>;
Or for explicit passthrough:
proc sql;
connect to teradata (user=<YOUR_USERNAME> password=<YOUR_PASSWORD> server=<YOUR_SERVER>database=<YOUR_DATABASE>);
create table newtable as
select * from connection to teradata ( select * from oldtable where prod_nm='SOME_VALUE');
disconnect from teradata;
quit;
4. If you are unsure whether your 'path' environmental variable is correct you can always set it within the SAS code for test purposes by adding a line at the top of your code of the form:
options set=path "C:\Program Files\Teradata\Client\16.20\bin";