Configuring the Teradata ODBC Driver for Teradata

Use the following procedure to configure a data source name for your Data Source database using the Teradata driver. Then repeat the procedure to configure a data source name for the relational database that you want to use as your OLAP Metadata Catalog database.

Note:

You may repeat the configuration procedure to create any number of data source names to Data Source databases or OLAP Metadata Catalog databases.

  To configure a data source name:

  1. Access the ODBC Data Source Administrator by following the procedure in Accessing ODBC Data Source Administrator in Windows.

  2. Click Add to open the Create New Data Source dialog box.

  3. In the driver list box of the Create New Data Source dialog box, select Teradata, and click Finish.

    The ODBC Driver Setup for Teradata RDBMS dialog box is displayed.

  4. In the Name text box, type the data source name that you want to use for this data source connection.

    In the sample application, TBC is the data source name used to connect to the Data Source database called TBC; TBC_MD is the data source name used to connect to the sample OLAP Metadata Catalog database called TBC_MD.

  5. Optional: In the Description text box, type an description that indicates how you use this data source name.

    For example, you might type the following to describe the My Business database: 

    Customers, products, markets

    You might type the following to describe the sample application database:

    Sample relational data source

    You might type the following to describe the sample OLAP Metadata Catalog database:

    Sample OLAP Metadata Catalog

  6. In the Teradata Server Info text box, type the address (either the computer name or the numeric IP address) of the computer where the database tables are stored.

  7. In the Default Database text box, type the name of the database for which you want to create this data source name.

    For example, in the sample application, TBC is the name of the Data Source database; TBC_MD is the name of the OLAP Metadata Catalog database.

  8. Optional: Enable the X Views option for Teradata.

    You can limit 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. Follow steps a through c to enable the X Views option:

    1. Click the Options button.

    2. Check the Use X Views check box.

    3. Click OK to return to the ODBC Driver Setup for Teradata RDBMS dialog box.

  9. Click OK to return to the System DSN tab of the ODBC Data Source Administrator dialog box.

    The data source name that you entered and the driver that you mapped to it are displayed in the System Data Sources list box.

  10. Repeat Step 2 through Step 9 above to configure a data source name for an OLAP Metadata Catalog.

    Note:

    You may repeat the above procedure to create any number of data source connections to relational data sources or OLAP Metadata Catalogs.

  11. When you have completed configuring all needed data sources, click OK to close the ODBC Data Source Administrator dialog box.