Create a System Data Source Name (DSN)
Once the Teradata ODBC driver is installed, you need to create a System Data Source Name (DSN). A DSN is a database connection profile that contains all the information SAS needs to connect to a Teradata database. To create a DSN, follow these steps:
- Go to Start > Control Panel > Administrative Tools > Data Sources (ODBC).
- Click the System DSN tab.
- Click the Add button to create a new DSN.
- Select the Teradata ODBC Driver and click Finish.
- In the Teradata ODBC Driver Setup window, enter a name for the DSN in the Data Source Name field.
- Enter the Teradata database server name or IP address in the Host field.
- Enter your Teradata username and password in the User ID and Password fields.
- Click OK to save the DSN.
How to Connect Teradata Using SAS in SQL?
SAS is a popular statistical software that provides a powerful suite of tools for data management, analytics, and reporting. In this blog post, we will show you how to connect to Teradata using SAS in SQL. Teradata is a high-performance, relational database management system that is widely used for data warehousing and business intelligence applications.