...
Example configuration in a seed:
In all actions the batch size is used as the fetch size.
{
"type": "rdbms-mssql-connector",
"name": "MS SQL Server RDBMS Seed",
"config": {
"seed": {
"pull": {
"objectSQL": "SELECT PersonID, LastName, FirstName, Address, City FROM Persons where PersonID = ?;",
"id": "PersonID"
},
"scan": {
"fields": {
"id": "PersonID",
"hash": [
"PersonID"
]
},
"fullScanSQL": "SELECT PersonID, LastName, FirstName, Address, City FROM Persons;"
},
"url": "jdbc:sqlserver://localhost:1433;databaseName=test;"
}
},
"pipelineId": "af856747-2343-46b1-a1d0-afd4d189d7c4",
"credentialId": "004ec9f2-43f2-48b7-ae6f-8770bf6cc8e9",
"scanAction": "scan",
"processAction": "process",
"batchSize": 100
}
...