Passing selected report from qliksense to informatica and getting back in same qliksense dashboard

Rocky6 — Sat, 16 Nov 2024 19:55:34 GMT

I have a client requirement which is given below .

Can i have a basic solution for the given requirement as i have give POC for the client on this week.

Approach:

1. User might select report name, start date & end date in Qliksense

2. These user inputs need to be collected & pass to Informatica through webservice (might need to use ODAG.. you need to check further)

3. Informatica to consume this webservice request & trigger the appropriate ETL

4. Informatica to load the ETL result set in SQLDW results table & update the control table

5. Qliksense & NPrinting to run the report generation job based “control table status”

6. End user to receive the adhoc report by email & results to be displayed on the session where user selected report name & date range.

topic Passing selected report from qliksense to informatica and getting back in same qliksense dashboard in App Development