Oracle Data Loader On Demand Guide > Overview of Oracle Data Loader On Demand >
Which Method Should You Use to Import Records?
You can import records using the Import operation, Oracle Data Loader On Demand, or Web services. The following information can help you choose the method that best suits your needs:
- Import Assistant. Use the Import Assistant if the following conditions apply:
- Oracle Data Loader On Demand. Use Oracle Data Loader On Demand if the following conditions apply:
- You want to automate your data loads.
- You can allow your data to be processed in any order.
- You have files that are larger than the allowable limits in Oracle CRM On Demand Import. The limits for each record type can be found in Oracle CRM On Demand Online Help.
- You want to schedule an Insert, Update, or Upsert operation.
- Your data has no errors and does not require much validation.
- Web services. Use Web services if the following conditions apply:
Downloading Oracle Web Services On Demand Guide
To download Oracle Web Services On Demand Guide from Oracle CRM On Demand
- Navigate to Admin and then to Web Services Administration.
- Click Download Documentation, and choose Oracle Web Services On Demand Guide.
Differences Between Using the Import Operation of Oracle CRM On Demand and Oracle Data Loader On Demand
Table 2 compares and contrasts the differences between using the Import operation of Oracle CRM On Demand and Oracle Data Loader On Demand.
Table 2. Differences Between the Import Operation of Oracle CRM On Demand and Oracle Data Loader On Demand
Import Operation of Oracle CRM On Demand |
Oracle Data Loader On Demand |
Data can be processed sequentially or in any order (optional). |
Data is processed in any order. |
CSV data file submission cannot be interrupted. |
CSV data file submission can be halted and resumed. |
|