dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

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
>>
>>
>