Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: pass (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.co.uk;
  h=Received:X-YMail-OSG:From:To:References:In-Reply-To:Subject:Date:Message-ID:MIME-Version:Content-Type:Content-Transfer-Encoding:X-Mailer:Content-language:Thread-Index;
  b=R8GnSK8B5aAfUZUqcSP3kd27SKBEDGzlx6Bk8IstgNFW8vJk+iUjtN/VoKoQ9vFNgtskEhr4TN0CfdPnWcTGhY//Objitt6HJlMhfxKaKruKcpF8uzVmXFUtf+/XnJoJIy/KgOi2NSI+CEMD4pIpwLJm0SB5D5S/xeRL+AFYj2E=
  ;
From: "sbarriba" <sbarriba@yahoo.co.uk>
To: <users@jackrabbit.apache.org>
References: <76a6ebd00709021835mf1cf8e2r39ef484f7d4431ad@mail.gmail.com>
In-Reply-To: <76a6ebd00709021835mf1cf8e2r39ef484f7d4431ad@mail.gmail.com>
Subject: RE: reporting
Date: Mon, 3 Sep 2007 09:31:13 +0100
Message-ID: <008501c7ee04$c9e2eac0$5da8c040$@co.uk>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit
Content-language: en-gb
Thread-Index: Acftys6tzGjVOg56QSOTglj4ayfAPwAOSVgg

Hi Mark,
We are using a mixed setup of a) JackRabbit for all content management and
b) relational database for all non-content related data e.g. transactions.
The transaction data includes content IDs.
To allow us to cross-reference the IDs to properties (title, price etc) in
the content model we're 'warehousing' some parts of our content model into a
relational database using the JCR observation model. We're then using one of
the many relational reporting tools to do rich reporting.
You could do the same in batch by traversing the repository and synch'ing
some parts into a relational database. The warehousing strategy is not ideal
as you end of duplicating content properties but it works well once your
synch code is reliable.

Regards,
Shaun.

-----Original Message-----
From: Mark Waschkowski [mailto:mwaschkowski@gmail.com] 
Sent: 03 September 2007 02:36
To: users@jackrabbit.apache.org
Subject: reporting

Hi,

Just about to embark on some reporting screens and wanted to see if there
were any suggestions from the board - are there any reporting tools that can
easily hook into jackrabbit, or do I need to export everything into xml and
then find reporting tools that work on the xml? If its export into xml
(which is my guess), any favorites that you can recommend?

Thanks!

Mark