connection

String

Name of the connection for the source system that the task uses to read data.

selectionRules

List

Optional object or table selection rules to select a subset of the source objects or tables for a task. By default, an Include rule that contains only the asterisk (*) wildcard character selects all objects on the source for an application ingestion and replication task or all tables in the source schema for a database ingestion and replication task. To narrow the source objects or tables that the task processes, you can add additional Include rules, Exclude rules, or a combination of both.

schema

String

The source schema that includes the source tables.

journalName

String

For Db2 for i incremental loads in a

database ingestion and replication

task, the name of the journal that records the changes made to source tables.

replicationSlotName

String

For PostgreSQL sources in a

database ingestion and replication

task, the unique name of a PostgreSQL replication slot.

replicationPlugin

String

For PostgreSQL sources in a

database ingestion and replication

task, the replication plugin. Options are:

pgoutput
wal2json

publication

String

For PostgreSQL sources in a

database ingestion and replication

task, the publication name used by the pgoutput plugin. Use this parameter only if you specified pgoutput as the replicationPlugin value.

restartPointForIncrementalLoad

String

For SAP ECC sources in an

application ingestion and replication

incremental load task and all sources in a

database ingestion and replication

incremental load or combined initial and incremental load task, the position in the source change stream or logs from which to start reading changes the first time the job runs.

restartPointForIncrementalLoadPosition

Integer

For all sources in a

database ingestion and replication

incremental load or combined initial and incremental load task, the RBA position in source change stream or logs from which to start reading change records the first time the job runs.

restartPointForIncrementalLoadTimestamp

Timestamp

For all sources in an

application ingestion and replication

incremental load task or

database ingestion and replication

combined initial and incremental load task, the date and time, including AM or PM, in the source change stream or logs from which to start reading change records the first time the job runs. For example: restartPointForIncrementalLoadTimestamp: 2021-08-18 02:50:00 PM

cdcInterval

String (time interval)

For Salesforce sources in an

application ingestion and replication

incremental load or combined load task, the time interval for which the job runs to retrieve change records for CDC.

fetchSize

Integer

For Salesforce sources in an

application ingestion and replication

initial load or incremental load task, the number of records that the job reads at a time from the source.

fetchSizeForInitialLoad

Integer

For Salesforce sources in an

application ingestion and replication

combined initial and incremental load task, the number of source records that the job reads at a time during the initial unload phase.

fetchSizeForIncrementalLoad

Integer

For Salesforce sources in an

application ingestion and replication

combined initial and incremental load task, the number of change records that the job can fetch at a time from the source during the incremental phase.

includeArchivedAndDeletedRows

Boolean

For Salesforce sources in an

application ingestion and replication

initial load or combined initial and incremental load task, controls whether the job can read archived and soft-deleted rows from the source during the initial load or unload phase of the combined load.

includeBase64Fields

Boolean

For an

application ingestion and replication

task with a Salesforce source, controls whether the job can replicate data from source fields that have the Base64 data type.

maximumBase64BodySize

Integer

For Salesforce sources in an

application ingestion and replication

task, the maximum body size of Base64 encoded data.

includeViews

Boolean

Indicates whether to include views in the table counts and list of table names.

startDate

String

The start date for retrieving source records for the load operation.

endDate

String

The end date for retrieving source records for the load operation.

batchSize

Integer

The batch size used when reading source records.

mid

String

The unique Member Identification code assigned to your Salesforce Marketing Cloud account.

context

String

For SAP sources using the ODP extractor, the context name.

cdcTechnique

String

For incremental load or combined initial and incremental load tasks, specifies the change data capture method.

cdcQueryBasedColumnType

String

For query-based CDC on source types, the column data type of the CDC query column in the source table. The column data type must combine the date and time. For Oracle, use Timestamp.

cdcQueryBasedColumnName

String

For query-based CDC on source types , the case-sensitive name of the CDC query column in the source table. The column must be present in the source table. Maximum length is 70 characters.

cdcQueryBasedDateColumn

String

For query-based CDC on source types that use a separate date column, the date column used to detect changed rows.

cdcQueryBasedTimeColumn

String

For query-based CDC on source types that use a separate time column, the time column used to detect changed rows.

CdcIntervalDays

Integer

The frequency of a query-based change data capture cycle, expressed in days. Sets the days portion of the CDC Interval property.

CdcIntervalHours

Integer

The frequency of a query-based change data capture cycle, expressed in hours. Sets the hours portion of the CDC Interval field.

CdcIntervalMins

Integer

The frequency of a query-based change data capture cycle, expressed in minutes. Sets the minutes portion of the CDC Interval field. Default value is 5 minutes.

lobsEnabled

Boolean

workdayReplicationType

String

The type of web service to use for data retrieval.

workdayReportsNumber

Integer

If you use the RaaS API, specify the number of reports you want to extract from the source.

workdayReportName

String

If you use the RaaS API and you want to extract a single report, specify the name or URL of the custom report you want to read from the source.

workdayReportsConfigFile

String

If you use the RaaS API and you want to extract multiple reports, specify the path to the CSV file that you created for the list of custom reports that you want to read from the source.

outputType

String

The format in which you want the data to be stored on the target.

extractNonDefault

Boolean

Indicates whether extract source fields that do not contain any default value.

oracleFusionInterfaceType

String

The type of interface used to extract data from the source.

oracleFusionModuleName

String

The name of the Oracle Fusion Cloud Applications Suite module to extract data.

oracleFusionEnableChildObjects

Boolean

Indicates whether to include child objects from the Oracle Fusion Cloud source in the extraction.