Application Ingestion and Replication > Application Ingestion and Replication > Handling source schema changes
  

Handling source schema changes

You can configure Application Ingestion and Replication to automatically detect source schema changes, also called schema drift, and handle these changes on the target. This feature is available only for the incremental load and combined initial and incremental load tasks.
When you configure an application ingestion and replication task, on the Schedule and Runtime Options page of the application ingestion and replication task wizard, you can specify the types of source schema changes that Application Ingestion and Replication must propagate for the job associated with the task. You can also specify how the job must handle each type of source schema change. For example, you can configure the task to ignore the changes, replicate them, or stop the job when a particular type of schema change occurs on the source. For more information, see Configuring schedule and runtime options.
Note: In combined initial and incremental load jobs, Application Ingestion and Replication starts detecting and replicating source schema changes only after the source object reaches the Normal state.
The following table describes the types of schema changes that Application Ingestion and Replication can detect for each source type:
Source type
Supported schema changes
Adobe Analytics
  • - Add field
  • - Modify field
  • - Drop field
  • - Rename field
Google Analytics
  • - Add column
  • - Modify column
  • - Drop column
  • - Rename column
Marketo
Not supported
Microsoft Dynamics 365
  • - Add column
  • - Modify column
  • - Drop column
NetSuite
  • - Add column
  • - Modify column
Oracle Fusion Cloud
  • - REST - Not supported
  • - BICC - Not supported
Salesforce
  • - Add field
  • - Modify field
  • - Drop field
  • - Rename field
SAP
  • - Using SAP ODP Extractor connector - Not supported
  • - Using SAP Mass Ingestion connector - Not supported
ServiceNow
  • - Add column
  • - Modify column
  • - Drop column
Workday
  • - SOAP - Not supported
  • - RaaS - Not supported
Zendesk
Not supported
Application Ingestion and Replication detects a schema change in a source object only after Data Manipulation Language (DML) operations occur on the altered source object. If multiple schema changes occur without intervening DML operations, Application Ingestion and Replication detects all the schema changes together when a DML operation occurs.