MS SQL Server Table

Parameter
Value
connectionString
the encrypted connection string. See ".NET Framework Data Provider for SQL Server" section on https://www.connectionstrings.com/sql-server/ for a sample. 
table
the name of the domain and table e.g. dbo.employees_new 
idColumn
the name of the identity column that exists in the target (or a single column that is guaranteed to be unique and automatically populated for every new record) 
idColumnDataType
the data type of the id column 
Before 4.0 
connectionString: the encrypted connection string. See ".NET Framework Data Provider for SQL Server" section on https://www.connectionstrings.com/sql-server/ for a sample. 
schema: the schema of the table, e.g. dbo  
table: the name of the domain and table e.g. dbo.employees_new 
idColumn: the name of the identity column that exists in the target (or a single column that is guaranteed to be unique and automatically populated for every new record) 
idDataType: the data type of the id column 
<SqlServerTableTarget 
	connectionString="DDE1MhWuA0xYbwFvSnu1fEZ2uD2GpsMRdw9DMV/kmMAfLUdkhkdzrD0Ikk/9dd114wRu9VKrVPSztrcIcSyz2UEFRRANfocc8KJEQXfKDuU="
	schema="dbo"
	table="employees_new"
	idColumn="id_col" 
	idDataType="Number">
	<ColumnMappings>
	    <ColumnMapping sourceColumn="employee_id" targetColumn="employee_id_new" />
        <ColumnMapping sourceColumn="name" targetColumn="name_new" />
    </ColumnMappings>
	<SyncKey>
	    <SyncKeyColumnReference name="employee_id_new" />
    </SyncKey>
		<NewRecordBehaviour type="INSERT" />
		<DroppedRecordBehaviour type="EXPIRE" expirationTimestampField="expiry_date_new" />
</SqlServerTableTarget>
CLI 4.0+
connectionString: the encrypted connection string. See ".NET Framework Data Provider for SQL Server" section on https://www.connectionstrings.com/sql-server/ for a sample. 
table: the name of the table including the schema, e.g. dbo.employees 
idColumn: the name of the identity column that exists in the target (or a single column that is guaranteed to be unique and automatically populated for every new record) 
idDataType: the data type of the id column 
<SqlServerTableTarget 
	connectionString="DDE1MhWuA0xYbwFvSnu1fEZ2uD2GpsMRdw9DMV/kmMAfLUdkhkdzrD0Ikk/9dd114wRu9VKrVPSztrcIcSyz2UEFRRANfocc8KJEQXfKDuU="
	table="dbo.employees_new"
	idColumn="id_col" 
	idDataType="Number">
	<ColumnMappings>
	    <ColumnMapping sourceColumn="employee_id" targetColumn="employee_id_new" />
        <ColumnMapping sourceColumn="name" targetColumn="name_new" />
    </ColumnMappings>
	<SyncKey>
	    <SyncKeyColumnReference name="employee_id_new" />
    </SyncKey>
		<NewRecordBehaviour type="INSERT" />
		<DroppedRecordBehaviour type="EXPIRE" expirationTimestampField="expiry_date_new" />
</SqlServerTableTarget>

Kafka Topic

Oracle Table

Last modified 1yr ago

Parameter	Value
connectionString	the encrypted connection string. See ".NET Framework Data Provider for SQL Server" section on https://www.connectionstrings.com/sql-server/ for a sample.
table	the name of the domain and table e.g. dbo.employees_new
idColumn	the name of the identity column that exists in the target (or a single column that is guaranteed to be unique and automatically populated for every new record)
idColumnDataType	the data type of the id column