Cdata Sync SQL Server Permissions for data loads

Data Integration CData Sync
, , ,
1

Hey All,

I am trying to adhere to the principle of least permissions. I created a SQL Server Authenticated Login for cdata to use as a service account to SQL Server. I’m not sure what permissions it needs at the database level though? I wasn’t able to find any documentation on the site about minimum permissions cdata sync service account for SQL Server would need.

I allow the cdata sync service account to drop and create tables. My guess is that I only need to add the cdata sync service account user to the following database level roles in my data lake.

ddl_admin
db_datareader
db_datawriter

What I am not sure about is whether or not Cdata Sync Service Account needs to have permissions to create Schemas.

Thanks

2

​ @Marcus_S

We do not have any specific documentation for minimum permissions required for the SQL Server connection to be used in Sync, unfortunately.

However, to address your query CData Sync is not intended to create schemas which means the Service Account that you will be using  for your SQL Server connection in CData Sync does not need to have CREATE SCHEMA permissions.

If you have any other questions you can reach out to the CData Support team at support@cdata.com and one of our Sync support specialists will further assist you.