Hi All,
I need a poc for the below requirements can you help me out a basic structure for this requirement
- User might select report name, start date & end date in Qliksense
- These user inputs need to be collected & pass to Informatica through webservice (might need to use ODAG.. you need to check further)
- Informatica to consume this webservice request & trigger the appropriate ETL
- Informatica to load the ETL result set in SQLDW results table & update the control table
- Qliksense & NPrinting to run the report generation job based “control table status”
- End user to receive the adhoc report by email & results to be displayed on the session where user selected report name & date range.
