How do I download and install the external data loader client?
This topic shows how to download and install the External Data Loader Client.
Here are the steps involved in this process:
-
Download and Install the Client
-
Set up Credentials
Before You Start
Ensure that your computer has Java version 1.8 installed.
Ensure that your Operating System is one of these:
-
Microsoft Windows 7
-
Microsoft Windows 8
-
Microsoft Windows 10
- Microsoft Windows 11
Ensure that your Operating System is one of these.
Required Privileges
To download the client, you must have access to My Oracle Support (support.oracle.com). To use the tool to import data into Sales and Fusion Service you must be able to access REST services and import data for the objects.
Prerequisite Steps
The Data Loader client doesn't require any specific configuration within Sales and Fusion Service. However, you must create an import map before using it. The client passes a mapping number value when submitting an import request. You can't create a new import mapping from the Data Loader Client application.
Download and Install the Client
You can download the client from My Oracle Support (Doc ID 2325249.1).
The download contains a ZIP file, with sub-folders. Save the ZIP file to a directory in which the full file path contains no white spaces. You must extract all of the files to a folder on your computer.
Set up Credentials
You can install and use the client for automated
imports while hiding the credentials that are used with the help of
the Credential Store. The Credential Wallet holds one set of user
credentials (user name and password pair). To save your credentials
use the savepassword
command,
> java -jar oscdataloader.jar savepassword -username John.Doe
Enter your password:
>
You are prompted to enter the password for the specified user name value. This password is masked so that it can't be viewed in the command window. You can then use the tool to submit or retrieve the status or log files for an import by only providing the user name value. This protects the password of the integration user by preventing other users from viewing the password either on the command line (by scrolling back through recently executed commands, viewing the password in the scheduling utility, or opening a configuration file containing the password value.
You can get the options for each command, by using the option -h for that command. For example, the following command lists the options available for the submit command.
> java -jar oscdataloader.jar submit -h
Use the Configuration File
The default configuration file is oscdataloader.config located in the config folder. This is used for all imports, unless otherwise mentioned. You can use another configuration file using the -config parameter.
> java -jar oscdataloader.jar listimports -config c:\test\configfile.txt
The configuration file should have all parameters, with each line of the file containing a key-value pair. For example:
import-name=Testing
input-file=c:\\testing\\testing.csv
mapping-number=888100111272708
target-url=https://mypod.oracle.com
object=Account
username=john.doe
wallet=true
in
the oscdataloader.config file.