topic Re: Schedule the Task Only After the ETL Process in QlikView

Schedule the Task Only After the ETL Process

Fri, 07 Feb 2014 15:59:39 GMT

I have to schedule the task for my QVW only after ETL Process is completed.

1)How can i know when it is complete ?

It is not a daily file.We will be getting the files for every period.Is there any other way ?

Re: Schedule the Task Only After the ETL Process

fkeuroglian — Fri, 07 Feb 2014 16:06:24 GMT

Hi, there is an option in QMC (managment console) that give the posibility to reload a documen after complete another process

i attached an image to ilustrate you

good luck

Fernando

Re: Schedule the Task Only After the ETL Process

regowins — Fri, 07 Feb 2014 16:18:43 GMT

I think you may want to look at the EDX trigger using QlikView Management Service (QMS) API. They basic idea is after the ETL process completes a file is created in a folder. QV will be looking for that file to appear in that folder and will only run the reload after that. This would apply to any time or day.

Using EDX in QlikView 11

Re: Schedule the Task Only After the ETL Process

swuehl — Fri, 07 Feb 2014 16:48:53 GMT

I would also recommend looking into EDX to achieve what you want.

But I think the basic idea is not having QV to look for a file created, instead call the QMS API from the ETL process e.g. using the command line tool attached to above referenced thread.

Re: Schedule the Task Only After the ETL Process

Anonymous — Fri, 07 Feb 2014 17:12:13 GMT

you did not mention what ETL tool you use but any ETL tool should be able to call command like tool referenced above. it will only work in windows environment though so if your ETL runs in UNIX, you would have to mess with API or a web service calls - check the EDX documentation.

once your ETL tool is done, you can set a flag in your database table and create a supporting task in QV Publisher (if you company uses it). That task can scan that table and trigger a task to reload your QVW. See help file for Qlikview Server and Supporting tasks.