Skip to main content
Feedback

Oracle SQL*Loader connector

Updated 

The Oracle SQL*Loader connector enables you to perform bulk data uploads to an Oracle database.

This connector performs the bulk uploads faster than the Database connector. The Oracle SQL*Loader uses the Oracle SQL*Loader utility, reduces overhead, and can bypass data integrity checks when loading data. The connector is capable of importing thousands of documents that may contain thousands of records, meaning that it can handle millions of records.

Connector configuration

To configure a connector to communicate with the Oracle SQL*Loader, set up two components:

  • Oracle SQL*Loader connection - The connection represents the connection credentials to the appropriate Oracle instance.
  • Oracle SQL*Loader operation - The operation represents an action against an Oracle database table.

Supported editions

This connector works with SQL*Loader 9.2 and later editions.

Prerequisites

The Oracle SQL*Loader connector requires the following:

  • Install Oracle SQL*Loader 9.2 or later.
  • Install Oracle SQL*Loader on the server that hosts the basic runtime.
  • Install an Oracle database.
  • Obtain a user name and password with sufficient permissions to perform the bulk data upload on the target schema.
  • Create the database, define the table and columns, and define the sequences.

Tracked properties

This connector has no predefined tracked properties. Refer to the topic Adding tracked fields to a connector operation to learn how to add a custom tracked field.

On this Page