Incremental Load

[#1]

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.

[chematos]

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.

[#3]

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.

[chematos]

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

[#5]

Hi Jose,

Ill try this and get back to you .

Thanks alot for your input though

Rochelle

[#6]

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.

[#7]

PS: Forgot to attach.