Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Configuring a MSSQL source connection for Qlik Replicate. The instruction specify,
In the Distributor step, select <Microsoft SQL Server Name> will act as its own distributor; Microsoft SQL Server will create a distribution database and log.
First assumption is that if the databases is already using MSSQL Replication and a distribution DB this can be skipped.
Will Replicate properly if this distribution database is a remote server and NOT local to the datasource?
Yes, a remote distributor will work fine. I recommend a remote distributor especially if you're using Availability Groups.