dhis2-devs team mailing list archive

[Rodolfo Melia <rmelia@xxxxxxxxxxxx>]

I actually meant pgAgent. Sorry for the confusion. It looks like we will be looking at cron jobs, while dhis apps gain some sort of scheduling capabilities. 

Rodolfo Meliá
+44 777 576 4090 | +1 708 872-7636

Please ignore any typos on this email sent from my mobile, probably written while I was at the park with the kids, at the airport walking to the gate, or sleepless (although exhausted). Grammatical faults? I'm sorry- I do my best

> On 1 Oct 2013, at 15:19, Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:
> 
> Well by taking it out of the jvm we do remove some functionality .. mostly access to all the dhis2 beans and whatever is not immediately available through the api.
> 
> But it is quite straightforward to run a standalone camel instance which talks to dhis2 via the api.
> 
> Unfortunately there are always some times when you have to resort to the database :-(  If you only want to schedule some sql script to run then I agree with Jason that a cron job which pipes the script to psql (not pgadmin) can often suffice.
> 
> If you find yourself (in addition to just scheduling), also doing more complex data transformations and the like then it can make sense to have an integration engine like camel - which also has a jdbc endpoint.  But again, if the only thing your camel context is doing is running the sql then it really doesn't need to be in the dhis.war.  Thats really why we have removed it.  You can do the same thing with camel (and/or other tools) without having it loaded in the virtual machine.   
> 
> 
>> On 1 October 2013 15:04, Jason Pickering <jason.p.pickering@xxxxxxxxx> wrote:
>> Nothing against Camel, but not sure what the issue with executing a task on the database might be. Just wrap it up as a shell script and schedule it with cron. 
>> 
>> Maybe I am missing some security issue there, but we use this approach extensively for this type of task. 
>> 
>> Regards,
>> jason
>> 
>> 
>> 
>>> On Tue, Oct 1, 2013 at 3:59 PM, Rodolfo Melia <rmelia@xxxxxxxxxxxx> wrote:
>>> Hi - we were thinking about using Camel for automating certain jobs that we want to run every 24 hours (update some Data Elements based on some custom calculations that cannot be run as indicators). We ruled out pgAdmin because we feel is too insecure. Now that camel is out, how can we schedule task to run every day? Do you plan to have a scheduler for an app, so certain routines can run on the basis of a schedule?
>>> 
>>> Rodolfo
>>> 
>>> Rodolfo Meliá
>>> Principal
>>> rmelia@xxxxxxxxxxxx
>>> www.knowming.com
>>> +1 708 872 7636
>>> +44 777 576 4090
>>> Skype: rod.melia
>>> 
>>> 
>>>> On Tue, Oct 1, 2013 at 11:26 AM, Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:
>>>> We have decided to remove the camel integration module from the dhis2 war file in the next release.
>>>> 
>>>> As the web api has matured it is now more feasible to run the likes of apache camel or mule or similar software as external clients of the api. 
>>>> 
>>>> Regards
>>>> Bob
>>>> 
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>> 
>>> 
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>