Before using the ODBC operator, you must configure the ODBC initialization file on your platform to designate the DSN (data source name) in 'ODBC Data Sources' to point to the proper data source.
Following is a sample of information from an odbc.ini file for a Linux system. It shows data source information for Oracle and SQLServer data sources. A sample odbc.ini file is provided where the bundled DataDirect ODBC drivers are located.
ODBC Data Sources] DB2 Wire Protocol=Teradata 8.0 DB2 Wire Protocol MySQL Wire Protocol=Teradata 8.0 MySQL Wire Protocol Oracle Wire Protocol=Teradata 8.0 Oracle Wire Protocol PostgreSQL Wire Protocol=Teradata 8.0 PostgreSQL Wire Protocol SQL Server Wire Protocol=Teradata 8.0 SQL Server Wire Protocol [ODBC] IANAAppCodePage=4 InstallDir=/opt/teradata/client/20.00/tbuild/odbc Trace=0 TraceFile=odbctrace.out TraceDll=/opt/teradata/client/20.00/tbuild/odbc/lib64/_Ttrc28.so [Oracle Wire Protocol] Description=Teradata 8.0 Oracle Wire Protocol Driver=/opt/teradata/client/20.00/tbuild/odbc/lib64/_Tora28.so AccountingInfo= LogonID= ServerName= CatalogOptions=0 ProcedureRetResults=0 EnableDescribeParam=0 EnableScrollableCursors=1 ApplicationUsingThreads=1 [SQL Server Wire Protocol] Driver=/root/Progress/DataDirect/ODBC_64bit/LINUX/lib/_Tsqls28.so Description=Teradata 8.0 SQL Server Wire Protocol ApplicationUsingThreads=1 AuthenticationMethod=1 Database= Domain= LogonID= MaxPoolSize=100 MinPoolSize=0 PortNumber= ProxyHost= ProxyMode=0 ProxyPassword= ProxyPort= ProxyUser=