17 Sep
2007
17 Sep
'07
10:53 a.m.
Hi,
You can do this in two ways: one is to make the wiki regularly check
on the warehouse, and create documents when it detects the watched
events, the other one is to put a notifier between the warehouse and
the wiki, either directly in the database system, if it supports such
things, or as another application that watches the warehouse and
communicates back to the wiki.
The first variant has the advantage that you don't need another tool,
or to change the database settings, you will have the watch mechanism
included in XWiki. It has the disadvantage that you will have to write
it. You could use the new scheduler plugin we have, combined with some
Groovy scripting, which will make things a bit easier.
The second variant has the advantage that you will use something
existing, you won't have to write it from scratch. If you use a
database functionality for this, another advantage is that you won't
poll for changes, you will get notified exactly when something happens
in the database.
On 9/2/07, Ricardo Pinto <xwicaforrica(a)gmail.com> wrote:
Hello!
I'm planning the development of the following functionality:
Running xwiki instance on MySQL;
There will be an external database (a Datawarehouse to be more precise),
with business indicators
If any of the indicators reached a predefined limit value, I' d like to have
my xwiki generate a document with information about this event and send an
e-mail alert to the administrator (or other users) My strategy may be to
create a IndicatorClass with some properties like name, description,
businessarea, currentvalue, limitvalue, externalTable, externalColumn etc.
Then I'll have to update these indicators on a regular basiis, which I could
do with a procedure that will check the external database and get the latest
values. For those which reached the limit values, I'd like to generate
automaticaly a document (of the class Risk for instance) and send an e-mail
to warn of these risks.
What do you think? Maybe a plugin could be a more structured way of doing
this...
Thanks in advance for your tips :)
Bye,
Ricardo.
Sergiu
--
http://purl.org/net/sergiu