Source database permissions
To generate the model by discovering the source database in the Replicate task, you need to define a connection to the source database used in the Replicate task. The user defined in the Source database connection settings must be granted the following permissions:
- Read metadata (Columns, Primary Keys and Foreign Keys)
- Select from tables
For more information, see Source Database Connection.