Oracle Data Loader On Demand Guide > Overview of Oracle Data Loader On Demand >

Introduction to Oracle Data Loader On Demand

The Oracle Data Loader On Demand client provides a means of importing data into Oracle CRM On Demand from external data sources. It has the following supported operations:

• Insert operation. This operation takes records from a file and adds them to Oracle CRM On Demand.
• Update operation. This operation modifies existing records in Oracle CRM On Demand, using records from an external data source. The external records must provide a value that uniquely identifies a record in Oracle CRM On Demand, such as External System ID or Row ID. Because External System ID and Row ID are used to identify the target record, those fields cannot be modified using Oracle Data Loader On Demand.
• Upsert operation. This operation is a combination of the Insert operation and the Update operation. Using records from an external data source, the Upsert operation first checks for the existence of the external record in the Oracle CRM On Demand database. The external records must provide a value that uniquely identifies a record in Oracle CRM On Demand, such as External System ID or Row ID. If the external record already exists in the Oracle CRM On Demand database, the Upsert operation then performs an Update operation on the record. If the external does not exist in the Oracle CRM On Demand database, the Upsert operation performs an Insert operation and inserts the external record into the Oracle CRM On Demand database.

  NOTE:  Row ID support is not available for all objects. To determine whether an object supports Row ID, see Determining Row ID Support.

Oracle Data Loader On Demand can be used for both small and large loads. However, larger loads (millions of records) require further sizing considerations. There are many factors to consider when inserting or modifying a large amount of data. Contact Customer Care if you plan to do large data loads or if the characteristics of your company's data load change dramatically. For example, contact Customer Care if you have been inserting one million records weekly and then suddenly need to increase to four million records.

NOTE:  Oracle Data Loader On Demand does not support SSO authentication.