Skip to end of metadata
Go to start of metadata

This plugin provides the ability for batch insert/update to a database from a file, or to create a Control File to run Oracle SQL Loader.

  • Supports NVARCHAR2
  • Supports CLOB column type when using Oracle

Perform INSERT/UPDATE

  • Set the Data Element jitterbit.plugin.DbUpdate.UseOracleSqlldr to False or null.
  • The plugin reads data from the target file and inserts/updates a database table.
  • The target file is assumed to be in CSV format with UTF8 encoding.
  • The plugin log can be found under the <JITTERBIT_HOME>/log/plugin/
  • Example log file name: DbUpdate_Account_2013_03_11.log

Perform Replicate

  • Set Data Element jitterbit.plugin.DbUpdate.UseOracleSqlldr to True.
  • The control file name is taken from Data Element jitterbit.plugin.DbUpdate.ControlFile + ".ctrl".
  • The data file name is taken from Data Element jitterbit.plugin.DbUpdate.ControlFile + ".data".
  • The SQLLDR log file name is taken from Data Element jitterbit.plugin.DbUpdate.ControlFile + ".log".
  • The process may generate a sequence of responses from query/queryMore.
  • The plugin will run on the target file at the end of the response transformation.
  • The first time the plugin is run, it will copy the header (jitterbit.plugin.DbUpdate.ControlHeader) to the control file, and the target file to the data file.
  • On subsequent runs, the target file will be appended to the data file.
NameTypeRequiredDescription
jitterbit.plugin.DbUpdate.ColumnName_listStringFalseNormally all the fields in the Salesforce object are transferred to the database table, and the primary key of the table is "ID". To skip some fields or use some other primary keys,you can use this optional global variable.In this case, the primary key column in the list must append the label "(PR)", so the list would look like the following:
Id(PR),Name,...
jitterbit.plugin.DbUpdate.ControlHeaderStringFalseThe header to be copied into the control file.
jitterbit.plugin.DbUpdate.ControlFileStringFalse

For Replicate:

  • The control file name is taken from Data Element jitterbit.plugin.DbUpdate.ControlFile + ".ctrl".
  • The data file name is taken from Data Element jitterbit.plugin.DbUpdate.ControlFile + ".data".
  • The SQLLDR log file name is taken from Data Element jitterbit.plugin.DbUpdate.ControlFile + ".log".
jitterbit.plugin.DbUpdate.DbGuidStringFalse
jitterbit.plugin.DbUpdate.DebugModeStringFalseSet to any value to enable debug mode. When debug mode is enabled, logging is added.
jitterbit.plugin.DbUpdate.SqlLdrAuthStringFalse
jitterbit.plugin.DbUpdate.SqlLdrPathStringFalse
jitterbit.plugin.DbUpdate.TableNameStringFalseThis variable may included the schema name, e.g. $jitterbit.plugin.DbUpdate.TableName="OWNER:ACCOUNT"
NOTE: The name of the primary key column of the database table must be "ID".
jitterbit.plugin.DbUpdate.UseOracleSqlldrBoolFalse
  • For Replicate, set the value to True.
  • For Insert/Update, set the value to False or null.
  • The default value is False.