Define the DBMS connection user when MS SQL Server is the target - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

The user ID under which Connect CDC logs in and updates the MS SQL Server target table must have (at least) database owner privileges for the target database. This is necessary because a SET IDENTITY_INSERT db.owner.tablename ON statement is sent to the target when an IDENTITY column is distributed.

To assign such privileges under MS SQL Server, which allows multiple database owners, you can edit the properties of the target-updating user to define it as db_owner.