- Open a command prompt.
- Change directory to INSTALL_DIR/AXSMOD/validate.
- Run the command oleload.exe. The OLELOAD GUI appears.
-
From the Select a source list, select a source; then, depending on the source selected, make the appropriate selections as described below.
Source Selections Teradata Database Teradata host: Machine name or IP address of the Teradata host
User id: Username for the Teradata Database
Password: Password for the Teradata Database
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
-
Follow the steps below, depending on source type:
Source Selections Teradata Database - Click OK.
Oracle Database or SQL Server - Click Test Connection.
- Click OK.
-
From the Select a destination list, 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 the Teradata Database
Password: Password for the Teradata Database
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
-
Do the following, depending on target type:
Source Selections Teradata Database - Click OK.
Oracle Database or SQL Server - Click Test Connection.
- Click OK.
-
Do the following to load the tables:
- 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.
- Select the desired table, and then in the table pane on the right, select the desired columns.
- In the bottom-right corner of the window, click Settings. The Teradata OleLoad - Advanced Settings dialog box appears.
- Make the desired changes, and then click OK.
- In the bottom-right corner of the OLELOAD GUI window, click Launch. The loaded records are visible in the destination database.
For more information about Teradata AccessModuleOLEDB, see Teradata® Tools and Utilities Access Module Reference (B035-2425).
Before proceeding with validation, ensure that the ODBC driver has been installed.
In this procedure, either the source or target must be Teradata Database.