dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

Note that the danger of using sql directly is not so much securing a cron
executed script (that can be done reasonably well), but more that it is
quite easy to mess up the metadata integrity.


On 1 October 2013 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
>>>
>>>
>>
>