1. Understanding Import and Export Management for Sales and Fusion Service
  2. How do I download and install the external data loader client?

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:

  1. Download and Install the Client

  2. 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.

Note: When executing the client from the command line the application uses the name oscdataloader.jar. For example,

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

Note: You can save your password by setting the parameter wallet=true in the oscdataloader.config file.