Early Access: The content on this website is provided for informational purposes only in connection with pre-General Availability Qlik Products.
All content is subject to change and is provided without warranty.
Skip to main content Skip to complementary content

Required permissions

The user specified in the connection settings must have the following permissions:

Full Load tasks

The ReplicationAdmin role with the SELECT privilege for the designated source tables.

CDC tasks

The ReplicationAdmin role with the REPLICATION CLIENT and REPLICATION SLAVE privileges.

Information noteWhen capturing changes from Microsoft Azure Database for MySQL 8.0, the user must also have Standard authentication.

Checking for open XA transactions

When the task is initialized, Data Movement gateway checks whether there are any open XA transactions (transactions that use a two phase commit protocol). To allow this query to be performed, the following permission needs to be granted:

grant XA_RECOVER_ADMIN on *.* to 'userName'@'%';

Where userName is the user specified in the connector settings.

If this permission is not granted, the following error will be shown when you run the task:

Failed to check for open XA transactions. Verify that the user specified in the endpoint settings has the XA_RECOVER_ADMIN permission. Capturing changes while there are open XA transactions might lead to loss of data. If there are no XA transactions in this database, add the internal parameter IgnoreOpenXaTransactionsCheck to skip the XA transactions check.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!