Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here you'll find the recordings of our Qlik Fix video series.
This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.
This video demonstrates how to install Qlik Replicate.
Video Transcript:
Hi and Welcome to Qlik Fix
This video will demonstrate how to install Qlik Replicate.
First, you can download the installer file by logging into the Qlik Product download site of Qlik Community.
Expand the compressed file, right-click the installer and Run as Administrator.
The installer requires Microsoft .NET 4.8, so the wizard will install that first.
Click Next on the Qlik Replicate Install wizard
Read and agree to the customer agreement.
Set the location for program files. This location must be a local drive.
Now the location for the data files. This will be the location for all of the task information and log files It’s recommended that this be a large location and CAN be a network drive.
Here you have the option to install a local Replicate Server or if you had already installed Replicate on a Linux box, you could set this up to connect to that Linux based Replicate server.
We’re doing a fresh installation on this Windows machine.
Review the current settings and start to install.
Now, once it’s finished, I’ll check those newly installed Windows services:
The Qlik Replicate Server and Qlik Replicate UI server services. Both are running.
These services are by default set to run as Local System, but if you require that the services be run by a user account, that account must be a local administrator on this machine.
One tip, the data folder locations that we set during the installation for both the program files and the data files can be reviewed here.
To access the Qlik Replicate console, it can be found from the start menu.
This server has a self signed certificate, that why we’re seeing this warning.
Login using the service account that we used during the installation.
The first thing to do is to click on Register to enter the license for activation.
This should be a text file that was sent from Qlik. You can Open that text file and copy the contents and paste it in here OR
You can click on Load and navigate to that same file, and click on Register License.
That creates a communication with the Qlik licensing server, and now the Replicate server is registered.
To review the registered license from the Replicate console,
Click on the drop down menu, select Server
Click on License on the left, that here you can see the details of the registered license, like the expiration date. If you have an update to the license, you can always click on the Register License button from here and register a new or updated license.
Now Qlik Replicate is ready and you can begin to setup the specific end points you want to use.
I hope this helps.
This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.
This video demonstrates how to safely add a table to an existing Log stream task in Qlik Replicate without affecting the parent tasks.
Here is a link to more information in the Support Knowledge Base
Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.
Transcript
Hi and Welcome to Qlik Fix
This video will demonstrate how to safely add a table to an existing Log stream task in Qlik Replicate.
Here is an example Log Stream Staging or Parent task
With a PostgreSQL Source and a Log Stream target already configured.
There are three tables: Branch, Branch Supplier and Csub Test that have been fully loaded.
The task is running and Change Data Capture or CDC is in progress.
Here is the child task that also points to PostgreSQL for the full load and then the log stream for CDC changes.
It’s using a File target for this demo.
In order to add a new table without impacting other tables,
First, stop the parent task.
Notice back on the child task, there is a warning log message stating that changes are not being captured.
Once the parent task is restarted the child task will pick up and continue where it left off.
Now stop the child task.
Back to the parent task, click on Table Selection to choose the table to add
Search, the trailspace table is the one that will be added. Add it with the arrows, OK.
Save that with the new table added.
Now from the Child task, Table Selection, Search
Notice that this new table isn’t available on the child task yet, as the parent task hasn’t been restarted yet.
Now from the Parent task, select Run > Resume Processing.
This will pick up where it left off with the original tables, and it will initiate a Full Load on the newly added table.
You can see this demonstrated with the different load time stamps of 1:08 for the original three tables and 1:17 for the fourth table.
Now that the parent task has completed a full load on the new table,
Go to the child task, table selection, search, and now the new table is available.
Bring that over, click ok.
Save.
And Run > Resume Processing on the child task.
Again, it initiated a Full Load only on the trailspace table, and not impacting the original tables.
Now Change Data Capture is running.
I’ll just add some inserts into that new trailspace table from PGAdmin to demonstrate this.
Qlik Replicate picks up those changes on the parent and child tasks and applies those changes to target.
I hope that helped.
If you'd like more information
Take advantage of the expertise of peers, product experts, Community MVPs and technical support engineers
by asking a question in a Qlik Product Forum.
Hiding in plain sight is the Search tool.
This engine allows you to search Qlik Knowledge Base Articles,
Qlik Community forums,
Help dot Qlik dot com, Qlik Gallery,
multiple Qlik YouTube channels and more, all from one place.
There’s also the Support space.
We recommend you subscribe to the Support Updates Blog,
And learn from Qlik experts via a webinar, like Techspert Talks or Q&A with Qlik.
Thanks for watching.
(music)
Nailed it!