topic Re: Incremental Load in QlikView

Incremental Load

Mon, 07 Oct 2013 10:17:43 GMT

Hi Guys,

I have an application in which data needs to be pushed from SAP to Oracle(Some defined tables in Oracle).The main table should be loaded once completely from the live server, and then post that only changed data should be added/modified according to the changes happening in the masterdata.This must happen hourly.I have defined a task for the same,which works.

I have defined a macro (VB scripted) which pushes the data for me into Oracle on a button event.I have defined this external task(Supporting task) in QV Management Console as well.

But Somehow Im not able to get incremental data for this.

Please help me with the same,as this is a critical requirement.

Re: Incremental Load

chematos — Mon, 07 Oct 2013 19:45:25 GMT

If I have understood well, you are running a qlikview app from the server that contains a macro?

That won't work, if you need to executes a macro you need to reload the document from your windows task programmer.

Re: Incremental Load

Tue, 08 Oct 2013 05:12:28 GMT

Hi Jose,

I believe there is an option in Qlikview management Console,Server Tasks->Supporting Tasks tab where you define the event. I ve scheduled it on successful load of my qvds. It supposedly performs the same task.

But its not working somehow.

Could you please elaborate on the Windows Task Programmer procedure,what must I do.

Thanks,

Rochelle.

Re: Incremental Load

chematos — Tue, 08 Oct 2013 17:44:59 GMT

I tried it before but the only way is with the task scheduler:

Control Panel -> All Control Panel Items -> Administrative Tools -> Task Scheduler

There you need to create a new task, you only have to know the path of your .qvw and add it to Actions section with the parameter /r or /l, I don't remember all the steps....

Hope this helps,

Jose

PD: May be you want to see something about executes qvw with a batch file, there are examples in the community also

Re: Incremental Load

Wed, 09 Oct 2013 05:13:23 GMT

Hi Jose,

Ill try this and get back to you .

Thanks alot for your input though

Rochelle

Re: Incremental Load

Wed, 09 Oct 2013 05:33:43 GMT

Hi Jose,

I just figured I have another issue .

My hourly reload that I ve scheduled is happening,but the data isnt inserting. Your suggestion is to use Windows Task Controller which Im Currently doing.But it also occurred to me, that since Im pushing data on an hourly basis,I need to push only changed(modified) records or if the record is a new one.

Im inserting my macro script that Im using,please tell me how to modify this.In this macro Im currently only inserting data,which is not really my requirement.It should insert data incrementally.Please help.

Re: Incremental Load

Wed, 09 Oct 2013 05:36:19 GMT

PS: Forgot to attach.