- From the Source Type list in the Job Source dialog box, click Oracle Table.
At the logon prompt, type the TSN name (a net service name that is defined in a TNSNAMES.ORA file or in the Oracle directory server, depending on how the Oracle net service is configured on the Oracle client and server), user ID, and the password needed to build the Oracle JDBC connection.
The value you enter into the TSN Service Name box at logon is the value that the Wizard uses for the DSNname attribute in all scripts; however, systems are often configured with different values for the TSN Service Name and DSN name. If this is the case, you must manually edit the value of the DSNname attribute in scripts to match the TSN Service Name before submitting a job script that involves an Oracle server.
- (Optional) Select the check boxes to include your user ID and password in the generated scripts. The default is to enter placeholders.
The Job Source dialog box displays the directory structure of the active Oracle server.
From the directory tree in the left pane, select a database and table that are the source of data for the job.
Do not select tables that contain character large object (CLOB) or binary large object (BLOB), JSON or XML data types.
In the right pane, select up to 450 columns to be included in the source schema, or click Select All or Select None.
The values under TPT Type are names of the data types associated with the Teradata PT columns; the values under DBS Type are the data types from the source database. When Teradata PT gets a column name from a source table, it looks at the definition schema of the table to determine an accurate data type. Sometimes these types can be recorded incorrectly or as a “?” when the Wizard cannot properly determine the data type. This often occurs when reading user-defined data types (UDTs).
To change or correct a Teradata PT data type, click Edit Type (or right-click), and select the correct data type from the shortcut menu. You can also enter the length, precision, and scale if it is applicable, but the precision and scale data types only appear when Decimal/Numeric is selected.
Click Next to open the Job Destination dialog box.
- Continue with Step 3 - Select a Destination.