MS-SQL connector as Reader and Writer
Last updated
Last updated
The MSSQL Connector as a Reader reads from the field defined in Reader>Source fields once the Reader stream is selected.
The MSSQL Connector as a Writer performs the writing according to the field mapping and the Writer mode.
The Writer mode allows the user to define the data to be written in one of the following ways:
Append: This setting defines that the data in the source will be added to the destination without affecting the existing data in the destination. This option is selected by default.
Add & Update: This setting defines that if a record is not present according to the match key, the record should be added, and the destination data set is updated accordingly. If the record is found, then the record is updated.
Delete: This setting defines that according to the match key, data is deleted from the destination data source.
Sync (Synchronize): This setting defines that data is synchronized between source and destination according to the match key.
For example, if a record is present in the source file and not in the target destination, the target destination is updated to sync with the source file. Similarly, if a record is not present in the source file and is present in the target destination, the same record in the target destination will be deleted.
