Install the Oracle Loader

  1. Create a connection to the Oracle database in Management Console.
    For more information, see Defining Connections.
  2. Install the Oracle client on the same machine as the Spectrum Technology Platform server.
    When installing the client, select the Administrator option for the install type.
  3. Create a variable name in the Oracle client tnsnames file that contains the network configuration parameters to the Oracle database.
    For example, set the variable name in the tnsnames file to "DB1".
    DB1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracleDatabaseHostName)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = DB1)
    )
  )
  4. Make sure you test the connection from the Oracle client to your Oracle database.
  5. Set the options in the DB Loader stage.
    For more information, see Oracle Loader settings.
Linux note: Before you start the Spectrum Technology Platform server on Linux, set ORACLE_HOME to the location of your Oracle client install. Add ORACLE_HOME/bin to the PATH variable. These variables must be set in the shell profile for the user that will be running the Spectrum server. After setting the variables, run the command sqlldr to see that the command returns the command usage information. Refer to the Oracle documentation for more information. These variables must be set before you start the server.