Hi Support,

With regard to the Oracle Fusion connector in Qlik Cloud Data Integration, since the connector uses BICC to connect to the Fusion databases, is there an indication of how frequently extract jobs run in BICC to capture the changes in the Fusion tables? 

Thanks,

Nak

A quick walkthrough of AudioEye, our digital accessibility tool that helps ensure the Qlik Community is usable for everyone!

(Click the YouTube link for a transcript of the video. If you need closed captions, please let us know here!)

Hey everyone! 

We’re hosting Qlik Community Hours, a casual live session where you can bring any and all questions about the Qlik Community platform, no product questions this time, just Community stuff!

Whether you’re wondering how to post, navigate the forums, or earn badges, this is your chance to ask us live!

Bonus: Everyone who attends will be entered into a raffle to win some exclusive Qlik swag!

Register here!

Hi,

I am currently working on Talend cloud data fabric, I saw the Talend R2025-05 release notes that we have the new Qlik Cloud Components such as tQVDOutput and tQlikOutput. I would like to explore this components, but I am unable to find in the palette.

Has anyone worked on it? I am using the R2025-06v3 version, is this version is compactable for those components? should I use the same respective release version to use the Qlik cloud components?

Qlik document: Qlik Cloud components | Talend Components for Jobs Help

Talend Cloud Talend Data Integration 

SAP:

SAP Note 3255746 was updated and now states that “the usage of RFC modules of the Operational Data Provisioning (ODP) Data Replication API by customer, or third-party applications to access SAP ABAP sources (On-Premise or Cloud Private Edition) is NOT permitted by SAP.”

How will that affect the Qlik connector used to obtain data from HANA? Will it stop working once SAP enforces their note?

Hi Team,

I’m working on a use case where I need to implement a full load followed by CDC from DB2 to Redshift, and I want to make sure we handle DB2 purges correctly while retaining historical data in Redshift.

✅ Scenario Summary

• We perform a full load from DB2 table emp to Redshift table emp before the DB2 team purges older records.

• After the purge, we enable CDC (insert, update, delete) to a separate Redshift table: emp_incremental.

• We use a MERGE process to sync CDC changes from emp_incremental into emp, using a last_updated_dt timestamp.

• Natural deletes from CDC should be processed normally (we do not retain those).

• Our goal is to preserve all data that existed before purge, but allow regular CDC to continue afterward.

❓Implementation Questions

1. Can I implement this from a single Qlik Replicate task?
   Can I map the same DB2 table (emp) twice — once for full load only to Redshift table emp, and once for CDC only to Redshift table emp_incremental?
   Or is it recommended to use two separate tasks for this?

2. How do I configure the task(s) to:

   • Perform full load only to emp (once, before purge)

   • Apply only CDC (insert/update/delete) to emp_incremental (after purge)

3. Will Qlik capture deletes that happen during or after the purge (from DB2 logs) and apply them to emp_incremental?

4. How can I define and apply a last_updated_dt = GETDATE() field in both full load and CDC using the Derived Column transformation?

5. What are the best practices for ensuring this approach works reliably — especially for purge scenarios — without introducing soft delete columns?

Thanks in advance for your help!

Best regards,

Bishnu

I have a challenge I can’t figure out. I created a sheet in Qlik with a table that contains a range of information. Two of the fields are called BilagNr and RegistreringsNr. BilagNr is unique to the transaction, and RegistreringsNr is the license‐plate number linked to that transaction.

When I view the table in Qlik, the row with BilagNr 116455 shows RegistreringsNr YF12587, which is correct according to the database. But when I use the Excel Add-in to export a report based on this same table, the same BilagNr 116455 comes out with a completely different RegistreringsNr (AY46466).

Why is the Excel Add-in returning the wrong RegistreringsNr?

Hi, I am new to Talend and I have given a task to connect Talend to an API which require in HTTPS connection.

I have download the certificate on place it in the cert store and I have configure Talend using the following setup:

It works on Windows device but I will need to use it in Linux environment.

What I have done so far is import it to the keystore in Linux server and change the configure above but it wont connect.

Next what I have done is copy the cacert file from windows machine to Linux server and place it in /etc/pki/tls/certs/cacerts and I have update the path and the password but it sill not able to connect.

Can I ask if someone had able to connect using Linux server?

Hi all,

I want to each row to calculate the number of columns, which match the following criteria:

(1) the created date has to be <= the created date of the specific line
(2) the close date has to be <= the created date of the specific line

Example:
For ID = 4, there are 2 rows, which match the criteria (ID 1 + ID 2). ID 3 does NOT match the criteria, since the close date is after the created date of ID 4. Therefore, the counter should not count this lins.

I know that I can word with rangesum(peek(, but I do not get this working, taking into account that I have the filter criteria which I need to get into this formula.

What I started with:

RangeSum(Above(TOTAL Sum(if(CreatedDate<=CreatedDate and CloseDate<=CreatedDate, Counter)), 0, RowNo(TOTAL)))

Can anybody help me?

Thanks
Florian