Hello,

I have configured a Log Stream task that reads from an Oracle JDE database, followed by a unidirectional task that replicates the data to Snowflake in CDC mode.

Occasionally, auditing is enabled on some source tables. This causes the tables to be renamed with the _ADT suffix, while the base tables (without this suffix) are converted into views of the corresponding audit tables.

In these cases, Qlik Replicate typically suspends the replication of the table with an error message such as: “Object ids of table 'DTA.F0401' are not correct”. I assume this is because the CDC replication task cannot replicate views, which in fact are not even selectable in the Log Stream task. At that point, we manually add the table with the _ADT suffix to the replication tasks.

We would like to manage these changes in a way that minimizes the impact on consumers that need to read these tables in Snowflake.

I was thinking of:

• adding a table selection pattern to the replication tasks that automatically includes all tables with the _ADT suffix (using the %_ADT pattern under the relevant schemas and selecting the “use exact table name” option);
• adding a global rule to the unidirectional task to Snowflake that renames tables with the %_ADT suffix by removing the last four characters.

This way, both the _ADT table and the base table would be replicated to the same target table in Snowflake. Moreover, the conversion of the base table into a view would have no significant impact on the replication, since the corresponding _ADT table would be automatically included in the replication instead. In any case, I assume that the task logs would still indicate that the base table is no longer available as a table.

Could this be a good solution or is there a better best practice for handling this type of situation?

Thank you in advance for your support.

Best regards

Hi everyone,

I've been working on improving the structure and performance of my Qlik load scripts and front-end apps, and I want to make sure I'm following the most current best practices... not just what was recommended 3 or 4 years ago.

I'm looking for resources that cover topics like:

• Load script structure and organization
• Data model optimization (star schema, avoiding synthetic keys, QVD layers)
• Performance tuning (set analysis efficiency, AutoNumber, incremental loads)
• Naming conventions and maintainability

My question to the community: What are the most current and reliable sources you use to guide your development decisions? For example:

• Official Qlik help docs or whitepapers
• Community blogs or specific contributors you follow
• YouTube channels or webinars
• Internal standards your team has developed

Any links, authors, or resources you'd recommend would be greatly appreciated. Thanks in advance!

Hi all, good evening,

I need to compare the cumulative sales between a year and the year before. This for many years stored in my database.

The sales had already been normalized by the month of each year.

This is the expression I created to generate the information for each year:

Aggr(RangeSum(Above(Sum(QTY), 0, RowNo())), [SALES YEAR, [YEAR/MONTH])

And this is the generated graphic:

What I need is to created a new graphic that shows, for each year, the % growth between that year vs its last year, using the same rule (acumulated sales for each month).

I have already tried many solutions here in the topics, but I couldn't get the right result.

For exemple: Aggr(RangeSum(Above(Sum(QTY) / Sum({<[SALES YEAR] = {"$(=Only([SALES YEAR])-1)"}>}QTY), 0, RowNo())), [SALES YEAR, [YEAR/MONTH])

Thanks in advance for any help.

Hello Team,

I am facing an issue with Qlik N-Printing.

Environment:

- N-Printing Version: 19.x

- Engine Server: lvqlikdev03

Issue:
The Engine status is showing Offline in N-Printing Admin Console.
Observed Behavior:
The Engine service starts and immediately stops.
Engine Log:
Starting up Engine service
Certificates exchange HTTP server listening on http://localhost:4997/
Stopping Engine service
Engine service stopped

Could anyone advise how to bring the Engine online.

Thank you.

I would appreciate your advice regarding the scenario below.

As part of our infrastructure refresh, we will be migrating several databases  to a new SQL Server due to the end-of-life status of the current hardware. The migration approach will be based on a full database backup and restore to the new server.

My main concern is ensuring that the existing Qlik Replicate tasks continue operating without data loss or replication issues after the migration.

Can someone please share your recommended approach for handling this type of migration? Specifically, I would like to understand:

• How you would preserve the replication state during the migration.
• Whether stopping the Qlik Replicate tasks before the migration and resuming them afterward would be sufficient.
• Whether it is necessary to use the current LSN position to resume change processing and avoid data loss.
• Any additional precautions or best practices you would recommend based on your experience.

At the moment, my initial thought is to stop the replication tasks before the migration, perform the database backup and restore, update the endpoints if required, and then resume replication from the appropriate LSN. However, I would appreciate your guidance on the best and safest approach.

Qlik Talend Cloud is being updated,

The first region is being deployed, it will take a few days for all regions to be updated.
Please refer to the latest Release notes to see what's new.

https://help.qlik.com/talend/en-US/release-notes/8.0/r2025

Hello,

I want to replace the deprecated tFileFetch component with the recommended replacement component tHTTPClient.

However, I cannot find tHTTPClient in the Palette. I also checked:

Edit Project Properties -> Designer -> Palette Settings

but the component is not listed there either. In the Internet family, I can see components such as FTP, SCP, Samba, etc., but there is no HTTP section and no tHTTPClient.

I am using:

Talend Studio 8
Build ID: 20260102_0846-patch

As far as I understand from the documentation, tHTTPClient should be available in this Studio version. I cannot simply update to version 2026-08, because tFileFetch may no longer be available there, and I need to migrate the existing jobs from tFileFetch to tHTTPClient before updating the Studio.

Could you please advise how I can install or enable the tHTTPClient component in my current Studio version?

Thanks in advance,
Matthias