Examples of ODBC Settings for Teradata

The following example illustrates how you might edit odbc.ini to connect to a Data Source database, tbc, on Teradata (on AIX), using the Teradata ODBC driver. You can make a separate entry to connect to the OLAP Metadata Catalog database. The data source description in [ODBC Data Sources] must be set to tdata.so. 

[ODBC Data Sources]
tbc=tdata.so

...

[tbc]
Driver=/usr/odbc/drivers/tdata.so
Description=NCR 3600 running Teradata V2R5
DBCName=139.64.140.45
DefaultDatabase=tbc
UseXViews=Yes
[ODBC]
IANAAppCodePage=4
InstallDir=products/common/ODBC/Merant/6.0
Trace=0
TraceDll=products/common/ODBC/Merant/6.0/lib/odbctrac.so
TraceFile=odbctrace.out
UseCursorLib=0

HP-UX

The following example illustrates how you might edit odbc.ini to connect to the same Data Source database, tbc, on Teradata (on HP-UX), using the Teradata ODBC driver. You can make a separate entry to connect to the OLAP Metadata Catalog database. The data source description in [ODBC Data Sources] must be set to tdata.sl.

[ODBC Data Sources]
tbc=tdata.sl

...

[tbc]
Driver=/usr/odbc/drivers/tdata.sl
Description=NCR 3600 running Teradata V2R5
DBCName=139.64.140.45
DefaultDatabase=tbc
UseXViews=Yes
[ODBC]
IANAAppCodePage=4
InstallDir=products/common/ODBC/Merant/6.0
Trace=0
TraceDll=products/common/ODBC/Merant/6.0/lib/odbctrac.so
TraceFile=odbctrace.out
UseCursorLib=0

Solaris:

The following example illustrates how you might edit odbc.ini to connect to the same Data Source database, tbc, on Teradata (on Solaris), using the Teradata ODBC driver. You can make a separate entry to connect to the OLAP Metadata Catalog database. The data source description in [ODBC Data Sources] must be set to tdata.so.

[ODBC Data Sources]
tbc=tdata.so

...

[tbc]
Driver=/usr/odbc/drivers/tdata.so
Description=NCR 3600 running Teradata V2R5
DBCName=139.64.140.45
DefaultDatabase=tbc
UseXViews=Yes
[ODBC]
IANAAppCodePage=4
InstallDir=products/common/ODBC/Merant/6.0
Trace=0
TraceDll=products/common/ODBC/Merant/6.0/lib/odbctrac.so
TraceFile=odbctrace.out
UseCursorLib=0

Note:

The UseXViews parameter is optional on all UNIX platforms. The UseXViews parameter limits the number of data sources displayed in the left frame of an OLAP Model main window based on the security of the Teradata user ID that was used to connect.