Insert Salesforce Audit Fields with Skyvia

Salesforce Audit Fields: Quick Insertion Guide

Overview

Audit fields in Salesforce (such as CreatedDate, CreatedById, LastModifiedDate, LastModifiedById) are system fields that track when and by whom a record was created or modified. By default, these fields are read-only and cannot be set during data import. Enabling the Create Audit Fields permission allows Skyvia to populate these fields during INSERT operations - useful when migrating historical data from another system.

Prerequisites

Before mapping audit fields in Skyvia, you must enable the Create Audit Fields permission in your Salesforce instance. See the Salesforce documentation on enabling audit fields for background information.

Steps to Enable the Permission

Step 1: Go to Setup → User Interface

Step 2: Enable the permission via Permission Sets

  • Navigate to Administration SetupPermission Sets.
  • Search for Audit Fields.

Step 3: Assign the permission to the user

  • Click Manage AssignmentsAdd Assignments.
  • Add the user who should be granted this permission.

After completing these steps, the audit fields will become available for mapping in Skyvia.

Important Notes

  • This feature is available only for connections created using the login of the user who has been granted this permission.
  • Audit fields can only be mapped when performing an INSERT operation.
  • To ensure the audit fields are available for mapping, clear the metadata cache in your Skyvia connection after enabling the permission.