Step 1 – Select a Data Source and Target
To specify a data source and target
1 From the Windows desktop, click Start>Programs>Teradata Client>OleLoad to open the Teradata OleLoad main window.
2 [Optional] Click File>Open to populate the window with parameters from a previously saved access module job (.amj) file.
3 Select a data source from the Select a source list.
The list contains all available OLE DB data sources, including Teradata Database.
Note: Duplicate rows (multiset tables) are supported.
If the data source is a text file with multi‑lined strings and carriage returns (features not supported by Teradata utilities) select Microsoft Jet 4.0 OLE DB Provider. For information on setting up the schema.ini file for this type of data transfer, see “Define a Schema File” on page 123.
Specify the options in the Data Link Properties dialog box.
In the Property Value field of the Edit Property Value dialog box that appears, type the word Text, and then click OK. The Data Link Properties dialog box reappears. Click the All tab to verify that the new entry is listed under Extended Properties.
Note: If an error message appears stating “Failed Properties: Persist Security Info (NOT SUPPORTED),” ignore the message and click OK.
After a data source is specified, you can click Connection Info to view its connection data.
Note: It is possible to export data from one Teradata Database to another, however it is not recommended due to performance issues. Consider first exporting the data from Teradata Database, and then using an alternate data source such as Microsoft OLE DB Provider for ODBC Drivers or OLE DB Provider for Teradata to import the data.
When Teradata Database is selected as source, the Teradata Connection Information dialog box appears.
Specify the following connection options:
Notice:
When Allow saving password is selected, the associated .amj file might allow unauthorized access as it will contain password data.
The following additional options appear:
For more information about mechanisms, see the appropriate installation guide.
When finished, click OK. The Teradata OleLoad connects to Teradata Database in UTF‑16 session charset and the Teradata OleLoad main window refreshes. The left pane displays the hierarchy of items from the selected data source, if available.
4 Select one of these radio buttons (below left pane) to specify the data to be loaded:
This button is only available if the data source supports the TABLE schema rowset.
Depending on the source, performance might be improved if the command limits the columns that will be returned. For example, instead of using the following command to select only the columns CustomerID and CompanyName,
SELECT * FROM "NORTHWIND"."DBO".CUSTOMERS"
Instead, use:
SELECT CustomerID, CompanyName FROM "NORTHWIND"."DBO".CUSTOMERS"
The Command button is only available if the data source supports SQL commands. The button is unavailable if Teradata Database is the data source.
5 From the Select a destination list, do one of the following to select a target:
The list contains the names of all of the available OLE DB providers and the Teradata Database. After a destination is selected, you can click Connection Info to view system information about a selected destination.
After a destination is selected, you can click Connection Info to view system information about a selected destination.
Note: An OLE DB data provider must not be specified as both the source and the destination.
6 In the right pane, select the columns that contain the data needed for the operation.
The data in the selected columns will be transferred to the target system that is identified in the Select a destination box when the job is launched.
7 Proceed with Step 2 – Specify Advanced Settings [optional].