17.00 - Validating AccessModuleOLEDB - Teradata Tools and Utilities

Teradata® Tools and Utilities for Microsoft Windows Installation Guide

Product
Teradata Tools and Utilities
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-11-20
dita:mapPath
ofn1544831946734.ditamap
dita:ditavalPath
dpj1465132351025.ditaval
Prerequisite
  • Verify ODBC driver has been installed.
  • In this procedure, either the source or target must be Vantage.
For more information about Teradata Access Module for OLE DB, see Teradata® Tools and Utilities Access Module Reference, B035-2425.
  1. Open a command prompt.
  2. Change directory to INSTALL_DIR/AXSMOD/validate.
  3. Run the command oleload.exe.
    The OLELOAD GUI appears.
  4. From Select a source, select a source; then, depending on the source selected, make the appropriate selections as described below.
    Source Selections
    Vantage

    Teradata host: Machine name or IP address of the Teradata host

    User id: Username for Vantage

    Password: Password for Vantage

    Oracle Database

    Microsoft OLEDB Provider for Oracle (MSDAORA)

    Enter a server name: System name or IP address

    User name: Username for the Oracle Database

    Password:Password for the Oracle Database

    SQL Server

    Microsoft OLEDB Provider for SQL Server (SQLOLEDB)

    Select or enter a server name: System name or IP address

    Enter information to log on to the server:
    • Use Windows NT Integrated Security: If SQL has been installed on the local host, or
    • Use a specific user name and password: If SQL has been installed on a different machine

    Select the database on the server: Any particular user from SQL server

  5. Follow the steps below, depending on source type:
    Source Selections
    Vantage Click OK.
    Oracle Database or SQL Server
    1. Click Test Connection.
    2. Click OK.
  6. From Select a destination, select a target; then, depending on the target selected, make the selections below:
    Source Selections
    Teradata host Teradata host: Machine name or IP address of the Teradata host

    User name: Username for Vantage

    Password: Password for Vantage

    Oracle Database Microsoft OLEDB Provider for Oracle (MSDAORA)

    Enter a server name: System name or IP address

    User name: Username for the Oracle Database

    Password:Password for the Oracle Database

    SQL Server Microsoft OLEDB Provider for SQL Server (SQLOLEDB)
    Enter information to log on to the server:
    • Use Windows NT Integrated Security: If SQL has been installed on the local host, or
    • Use a specific user name and password: If SQL has been installed on a different machine

    Select the database on the server: Any particular user from SQL server

  7. Do the following, depending on target type:
    Source Selections
    Vantage Click OK.
    Oracle Database or SQL Server
    1. Click Test Connection.
    2. Click OK.
  8. Load the tables:
    1. In the navigator pane of the OLELOAD GUI, select the database associated with the credentials used to log in.
      Under the database selected, the list of tables appears.
    2. Select the desired table, and then in the table pane on the right, select the desired columns.
    3. In the bottom-right corner of the window, click Settings.
    4. Make the desired changes, then click OK.
    5. Click Launch.
      The loaded records are visible in the destination database.