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.
