Command-Line Parameters for Oracle Data Loader On Demand

Oracle Data Loader On Demand has a command-line interface. The syntax for running Oracle Data Loader On Demand is:

java -jar Oracle_DataLoader_OnDemand.jar parameters

Option names and values are case sensitive and must be in lower case. Parameters with spaces must be enclosed in double quotes.

The parameters are listed in the following table.

Table Command-Line Parameters for Oracle_DataLoader_OnDemand.jar

Parameters	Required or Optional	Description
-username value	Required	Your User Sign In ID for Oracle CRM On Demand.
-operation value	Required	Operation type. The value must be one of the following: insert. The Insert operation creates new records in the database. If a record already exists, then the import fails. Uniqueness is determined by the values of the database user key. Uniqueness is determined by the values of the required fields. To determine uniqueness for a record and which fields are required, see the table in the topic Use the Required Field Mappings. update. The Update operation updates only records that already exist in the database. The record can be found by matching the External System ID. upsert. The Upsert operation performs either an Insert operation or an Update operation, depending on if the external record can be matched to an existing record in the database. resume. The Resume operation is used only to restart an operation that was previously interrupted by a user.
-propertyfilepath value	Optional	Specifies the path and file name of a properties file. If you do not specify a properties file, then you must specify all the parameters for the Insert, Update, Upsert, or Resume operations.
-clientloglevel value	Optional	Specifies the level of detail for the client log file. It must be one of the following: basic. Provides high-level errors. This is the default value. detailed. Provides more detailed error messages for troubleshooting. all. Provides all error messages, including any third party error messages generated from any libraries used by the client. Use this option only when instructed by Customer Care to troubleshoot an issue. Note: If you set -clientloglevel to all or detailed, then the command-line parameters are copied to the log file.
-clientlogfiledir value	Optional	Specifies the directory in which to save the OracleDataLoaderOnDemand log file. This log file stores errors and warnings related to the submission of an Insert, Update, or Upsert job. Errors in an Insert, Update, or Upsert operation are stored in a server log, which is accessible by Customer Care. If you do not use -clientlogfiledir to specify a directory, then the OracleDataLoaderOnDemand log file is stored in the same directory as the Oracle_DataLoader_OnDemand.jar file.
-disableimportaudit	Optional	Specifies whether the auditing of record creation and update during an import request is disabled. This setting takes effect if you have the Manage Record Auditing for Imports privilege. By default, auditing is turned on for each request. Import performance for some objects improves when auditing is turned off.
-importblankinmsp	Optional	Specifies whether multi-select picklist fields can be updated to null values on importing. By default, null values are not imported.
-help	Optional	Displays a list of available parameters.
-proxyserver value	Optional	Specifies the name of a proxy server.
-proxyserverport value	Optional	Specifies a port on the proxy server.
-proxyauthusername value	Optional	Specifies a proxy server authentication name. If this parameter is specified, Oracle Data Loader On Demand prompts for the proxy server authentication user password.
-hosturl value	Optional	Specifies the Oracle CRM On Demand host URL.
-characterset value	Optional	Specifies the character set encoding of the data file and map file. If this parameter is not specified, a value of UTF-8 is the default. For a list of supported values, see the following: https://docs.oracle.com/javase/6/docs/technotes/guides/intl/encoding.doc.html
-disableemailnotification	Optional	Specifies whether an email notification is sent after a database import. If this parameter is not specified, then the email notification is sent after the database import. If this parameter is specified, then the email notification is not sent.
-senduserlogfile	Optional	Specifies whether Oracle Data Loader On Demand sends the log file after a database import. If disableemailnotification is in the parameter list, then the value of senduserlogfile is ignored. Note: If the user log file size exceeds 20 MB, then Oracle Data Loader On Demand does not email the file, but does note this fact in the user log file. Refer to the userlogfiledir parameter to specify where the user log file is stored.
-userlogfiledir value	Optional	Specifies the directory in which to save the user log file. If you do not use -userlogfiledir to specify a directory and the waitforcompletion parameter is present in the properties file, then the user log file is stored in the same directory as the Oracle_DataLoader_OnDemand.jar file. If neither the -userlogfiledir parameter or the waitforcompletion parameter are specified, then the user log file is not saved.

When you run Oracle Data Loader On Demand from the command-line you are prompted to enter your password. This is a security feature to prevent unauthorized people from gaining access to your password.

Note: Oracle Data Loader On Demand does not support password text files.