Configure the transform settings for your Integration Hub - Import integration. Specify batch size and empty-field handling, enable verbose mode, or run a script before or after the integration.

Configure transform settings

You can configure the transform settings for your integration by selecting the Transform Settings button at the top of the Map to target page in Integration Hub - Import.
Note: The Transform Settings button doesn't appear until you've added at least one target table to the Map to target page. For more information, see Map source data to a target table.
Field Description
General
Batch Size

Number of items to transform in each batch.

Default value: 10
Verbose

Option to enable transform logs with details on transform operations, transformer rules, and transforms with multiple target tables.

Default value: false
Copy Empty Fields

Option to copy any empty values in the source fields to the target fields.

When this field is selected, empty source values are copied. When it's not selected, empty source values are not copied to the target fields.

Default value: true
Scripts
Execute OnBefore Script

Option to run a script before inserting or updating data. Send notifications, modify data, or perform other actions before the integration begins.

The onBefore script has three parameters.
  • source: The source data from the import record.
  • target: The transformed data from the import record. In the onBefore script, this parameter accesses transformed data before it's inserted into the target table.
  • importLog: The log that records information about data import activity.
The onBefore script has two variables.
  • ignore. Type: Boolean. When true, the specified import set row is ignored.
  • ignore_reason. Type: String. Message describing why the import set row was ignored.
Execute OnAfter Script

Option to run a script after inserting or updating data. Send notifications, calculate summaries, or perform other actions after the integration completes.

The onAfter script has three parameters.
  • source: The source data from the import record.
  • target: The transformed data from the import record. In the onAfter script, this parameter accesses transformed data after it's inserted into the target table. Once a record is inserted or updated, it has a sys_id.
  • importLog: The log that records information about data import activity.