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.
- Open a command prompt.
- Change directory to INSTALL_DIR/AXSMOD/validate.
- Run the command oleload.exe.The OLELOAD GUI appears.
- From Select a source, select a source; then, depending on the source selected, make the appropriate selections as described here:
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
- Follow the steps shared here, depending on source type:
Source Selections Vantage Click OK. Oracle Database or SQL Server - Click Test Connection.
- Click OK.
- From Select a destination, select a target; then, depending on the target selected, make the selections here:
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
- Do the following, depending on target type:
Source Selections Vantage Click OK. Oracle Database or SQL Server - Click Test Connection.
- Click OK.
- 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.
- Make the desired changes, then click OK.
- Click Launch.The loaded records are visible in the destination database.
- In the navigator pane of the OLELOAD GUI, select the database associated with the credentials used to log in.