Oracle Loader

The Oracle Loader allows you to load data to any Oracle database configured in the Spectrum Data Integration platform. Configure the stage as described in the table below:
Note: Oracle client must be installed with an administrator setup before using the Oracle Loader.
Option Name Description
Connection Select Oracle as the connection.
The dropdown displays all the connections you have configured. To configure a new connection or edit any existing connections, click the Manage Connections link. It takes you to the Connections page in the Spectrum Management Console. For details on configuring new connections, see Connections.
Note: Click the Refresh icon to update any modification, deletion or addition to your list of connections.
Table Specify the table to which you want to write the data.
  1. Click the Browse button ([...]). The Select Table pop-up window is displayed, which shows a list of the tables and views.
  2. Choose the required table.
    Note: You can also use the search text box on the top of the pop-up window to narrow down your search.
  3. Click Select.
The fields of the selected table are displayed in the Fields section on the right side of the page. These are the details displayed:
  • Database Fields: This column lists the field names in the database. You cannot modify these field names.
  • Stage Fields: This column lists the field names used in the data flow. You cannot modify these field names
  • Types: This column lists the data type of each field.
Listener Specify a variable name that contains the address and connection details required to establish a connection to the Oracle database. For example, "XE". This variable is present in tnsnames.ora, a file that contains client side network configuration parameters.
Load method Specify how you want to write data into the Oracle database.
  • Insert: Loads the data into the database. The table must be empty before it is loaded. It doesn't work on multiple runtime instances.
  • Append: Adds the data into the target table without erasing the table's existing data.
  • Truncate and Insert: Deletes existing rows if any, then loads the input data into the table. This does not work on multiple runtime instances.
Use direct path loader Specify Yes to load data directly into the Oracle database bypassing much of the data processing that normally takes place.
Unrecoverable This toggle is enabled when you select Use direct path loader. Select Yes if you do not want to write Redo logs in the database. For more information about Redo logs, see http://docs.oracle.com/cd/B28359_01/server.111/b28310/onlineredo001.htm#ADMIN11302.
Log file folder Specifies the path to the folder. Click to go to the folder you want. The log file contains a record of this stage's activities during a load session.
Bad file folder Specifies the path to the folder. Click to go to the folder you want. The bad file contains a list of records that the stage fails to load into the database.
Maximum errors allowed Specify the maximum number of errors to allow before halting the load operation. To halt the load operation on the first error, set value to 0. A maximum of 32767 errors are allowed.