Have you ever integrated pentaho with ofbiz

[Vu Hong Thuan]

Hi all,
I see that the reports in ofbiz is very simple.
I want to integrate third-party report into ofbiz. I prefer pentaho.
Could you give me some suggestion about the integration.
Thanks.

[BJ Freeman]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Jasper reports are also coded, but commented out since they do not have
a apache license.
you can look at that for a model.

Vu Hong Thuan sent the following on 4/7/2009 8:45 AM:
> Hi all,
> I see that the reports in ofbiz is very simple.
> I want to integrate third-party report into ofbiz. I prefer pentaho.
> Could you give me some suggestion about the integration.
> Thanks.
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJ24ASrP3NbaWWqE4RAoybAJ427w89abMgpS53DLYd7KWC81tFkgCgitSA
yGV6DZzWG45zP8wXDczNKrc=
=eyTn
-----END PGP SIGNATURE-----

[Vu Hong Thuan]

Thanks BJ
Which software you want to use to generate report in ofbiz?
Do developers of ofbiz want to use pentaho for ofbiz report?
If no, which software they want to use?

2009/4/7 BJ Freeman <[hidden email]>

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Jasper reports are also coded, but commented out since they do not have
> a apache license.
> you can look at that for a model.
>
> Vu Hong Thuan sent the following on 4/7/2009 8:45 AM:
> > Hi all,
> > I see that the reports in ofbiz is very simple.
> > I want to integrate third-party report into ofbiz. I prefer pentaho.
> > Could you give me some suggestion about the integration.
> > Thanks.
> >
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFJ24ASrP3NbaWWqE4RAoybAJ427w89abMgpS53DLYd7KWC81tFkgCgitSA
> yGV6DZzWG45zP8wXDczNKrc=
> =eyTn
> -----END PGP SIGNATURE-----
>

[BJ Freeman]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

My clients want something they understand and can create reports on the fly.
Most of my clients have come from a windows environment and are familiar
with Crystal reports, as far as familiarity.
I enhances the Ireports.
I have been playing with a report page the used FTL for selecting Data,
then using an ftl to format and output to excel directly.

 any thing you wish to contribute, would be appreciated.


Vu Hong Thuan sent the following on 4/7/2009 10:06 AM:

> Thanks BJ
> Which software you want to use to generate report in ofbiz?
> Do developers of ofbiz want to use pentaho for ofbiz report?
> If no, which software they want to use?
>
> 2009/4/7 BJ Freeman <[hidden email]>
>
> Jasper reports are also coded, but commented out since they do not have
> a apache license.
> you can look at that for a model.
>
> Vu Hong Thuan sent the following on 4/7/2009 8:45 AM:
>>>> Hi all,
>>>> I see that the reports in ofbiz is very simple.
>>>> I want to integrate third-party report into ofbiz. I prefer pentaho.
>>>> Could you give me some suggestion about the integration.
>>>> Thanks.
>>>>
>>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJ25DxrP3NbaWWqE4RAsA2AKCiWSKhdaopdyTcvNOM7bUVqQQPhACgvJMA
+vCCRCtKzsa8y+dLLAXJXys=
=qNdV
-----END PGP SIGNATURE-----

[Michael Xu (xudong)]

hi Thuan,

You can take a look at opentaps, which is on top of ofbiz. And opentaps
supports pentaho.

--
Regards,
Michael Xu (xudong)
www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: [phone]
9807 | Fax: [phone]


On Tue, Apr 7, 2009 at 11:45 PM, Vu Hong Thuan <[hidden email]> wrote:

> Hi all,
> I see that the reports in ofbiz is very simple.
> I want to integrate third-party report into ofbiz. I prefer pentaho.
> Could you give me some suggestion about the integration.
> Thanks.
>

[Tim Ruppert]

If I were you, I'd probably talk with others in the community rather than moving to opentaps.  There are people who have integrated pentaho into Apache OFBiz successfully too.  I think that Marco Risaliti - one of the committers here did - but I can't remember if it was him for sure.

Cheers,
Tim
--
Tim Ruppert
HotWax Media
http://www.hotwaxmedia.com

o:801.649.6594
f:801.649.6595

----- "Michael Xu (xudong)" <[hidden email]> wrote:

> hi Thuan,
>
> You can take a look at opentaps, which is on top of ofbiz. And
> opentaps
> supports pentaho.
>
> --
> Regards,
> Michael Xu (xudong)
> www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86)
> 135 0135
> 9807 | Fax: [phone]
>
>
> On Tue, Apr 7, 2009 at 11:45 PM, Vu Hong Thuan <[hidden email]>
> wrote:
>
> > Hi all,
> > I see that the reports in ofbiz is very simple.
> > I want to integrate third-party report into ofbiz. I prefer
> pentaho.
> > Could you give me some suggestion about the integration.
> > Thanks.
> >

[Michael Xu (xudong)]

hi Tim,

Actually, pentaho technically can integrate with all database applications.
But point here is pentaho is ready in opentaps but not in ofbiz. When I
consider which one to go with if BI is a must, I still prefer opentaps.

No offense. Just list my simple reason here :-)

--
Regards,
Michael Xu (xudong)
www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: [phone]
9807 | Fax: [phone]


On Wed, Apr 8, 2009 at 1:12 PM, Tim Ruppert <[hidden email]>wrote:

> If I were you, I'd probably talk with others in the community rather than
> moving to opentaps.  There are people who have integrated pentaho into
> Apache OFBiz successfully too.  I think that Marco Risaliti - one of the
> committers here did - but I can't remember if it was him for sure.
>
> Cheers,
> Tim
> --
> Tim Ruppert
> HotWax Media
> http://www.hotwaxmedia.com
>
> o:801.649.6594
> f:801.649.6595
>
> ----- "Michael Xu (xudong)" <[hidden email]> wrote:
>
> > hi Thuan,
> >
> > You can take a look at opentaps, which is on top of ofbiz. And
> > opentaps
> > supports pentaho.
> >
> > --
> > Regards,
> > Michael Xu (xudong)
> > www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86)
> > 135 0135
> > 9807 | Fax: [phone]
> >
> >
> > On Tue, Apr 7, 2009 at 11:45 PM, Vu Hong Thuan <[hidden email]>
> > wrote:
> >
> > > Hi all,
> > > I see that the reports in ofbiz is very simple.
> > > I want to integrate third-party report into ofbiz. I prefer
> > pentaho.
> > > Could you give me some suggestion about the integration.
> > > Thanks.
> > >
>

[Tim Ruppert]

No worries - I totally understand pentaho and it's abilities and that it is available OOTB in Opentaps.  My simple request, is to look at Apache OFBiz - which is a far superior product IMHO - and build on top of that instead of messing around with something else.  There are people that have done it in OFBiz, so let's look to them instead of sending our community elsewhere.

I hope you understand where I am coming from as well.

Cheers,
Tim
--
Tim Ruppert
HotWax Media
http://www.hotwaxmedia.com

o:801.649.6594
f:801.649.6595

----- "Michael Xu (xudong)" <[hidden email]> wrote:

> hi Tim,
>
> Actually, pentaho technically can integrate with all database
> applications.
> But point here is pentaho is ready in opentaps but not in ofbiz. When
> I
> consider which one to go with if BI is a must, I still prefer
> opentaps.
>
> No offense. Just list my simple reason here :-)
>
> --
> Regards,
> Michael Xu (xudong)
> www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86)
> 135 0135
> 9807 | Fax: [phone]
>
>
> On Wed, Apr 8, 2009 at 1:12 PM, Tim Ruppert
> <[hidden email]>wrote:
>
> > If I were you, I'd probably talk with others in the community rather
> than
> > moving to opentaps.  There are people who have integrated pentaho
> into
> > Apache OFBiz successfully too.  I think that Marco Risaliti - one of
> the
> > committers here did - but I can't remember if it was him for sure.
> >
> > Cheers,
> > Tim
> > --
> > Tim Ruppert
> > HotWax Media
> > http://www.hotwaxmedia.com
> >
> > o:801.649.6594
> > f:801.649.6595
> >
> > ----- "Michael Xu (xudong)" <[hidden email]> wrote:
> >
> > > hi Thuan,
> > >
> > > You can take a look at opentaps, which is on top of ofbiz. And
> > > opentaps
> > > supports pentaho.
> > >
> > > --
> > > Regards,
> > > Michael Xu (xudong)
> > > www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile:
> (86)
> > > 135 0135
> > > 9807 | Fax: [phone]
> > >
> > >
> > > On Tue, Apr 7, 2009 at 11:45 PM, Vu Hong Thuan
> <[hidden email]>
> > > wrote:
> > >
> > > > Hi all,
> > > > I see that the reports in ofbiz is very simple.
> > > > I want to integrate third-party report into ofbiz. I prefer
> > > pentaho.
> > > > Could you give me some suggestion about the integration.
> > > > Thanks.
> > > >
> >

[David E Jones-3]

Have you looked into what it actually means for Opentaps to include  
Pentaho?

You might be surprised...

-David


On Apr 7, 2009, at 11:41 PM, Michael Xu (xudong) wrote:

> hi Tim,
>
> Actually, pentaho technically can integrate with all database  
> applications.
> But point here is pentaho is ready in opentaps but not in ofbiz.  
> When I
> consider which one to go with if BI is a must, I still prefer  
> opentaps.
>
> No offense. Just list my simple reason here :-)
>
> --
> Regards,
> Michael Xu (xudong)
> www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86)  
> 135 0135
> 9807 | Fax: [phone]
>
>
> On Wed, Apr 8, 2009 at 1:12 PM, Tim Ruppert <[hidden email]
> >wrote:
>
>> If I were you, I'd probably talk with others in the community  
>> rather than
>> moving to opentaps.  There are people who have integrated pentaho  
>> into
>> Apache OFBiz successfully too.  I think that Marco Risaliti - one  
>> of the
>> committers here did - but I can't remember if it was him for sure.
>>
>> Cheers,
>> Tim
>> --
>> Tim Ruppert
>> HotWax Media
>> http://www.hotwaxmedia.com
>>
>> o:801.649.6594
>> f:801.649.6595
>>
>> ----- "Michael Xu (xudong)" <[hidden email]> wrote:
>>
>>> hi Thuan,
>>>
>>> You can take a look at opentaps, which is on top of ofbiz. And
>>> opentaps
>>> supports pentaho.
>>>
>>> --
>>> Regards,
>>> Michael Xu (xudong)
>>> www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86)
>>> 135 0135
>>> 9807 | Fax: [phone]
>>>
>>>
>>> On Tue, Apr 7, 2009 at 11:45 PM, Vu Hong Thuan <[hidden email]>
>>> wrote:
>>>
>>>> Hi all,
>>>> I see that the reports in ofbiz is very simple.
>>>> I want to integrate third-party report into ofbiz. I prefer
>>> pentaho.
>>>> Could you give me some suggestion about the integration.
>>>> Thanks.
>>>>
>>

[BJ Freeman]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

from the opentaps forum

By: Si Chen (sichenProject Admin) - 2009-01-09 13:13
me too: please post here once in awhile and let me know how your group
is going.

Now word about ofbiz and opentaps: we will be deprecating more of the
ofbiz things in favor of open source projects like Spring and hibernate,
and a few others that are less well known, but also very high quality.
So, while understanding the ofbiz framework will certainly continue to
be important, there are also a lot of other technologies here now in
opentaps.


Michael Xu (xudong) sent the following on 4/7/2009 10:41 PM:

> hi Tim,
>
> Actually, pentaho technically can integrate with all database applications.
> But point here is pentaho is ready in opentaps but not in ofbiz. When I
> consider which one to go with if BI is a must, I still prefer opentaps.
>
> No offense. Just list my simple reason here :-)
>
> --
> Regards,
> Michael Xu (xudong)
> www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: [phone]
> 9807 | Fax: [phone]
>
>
> On Wed, Apr 8, 2009 at 1:12 PM, Tim Ruppert <[hidden email]>wrote:
>
>> If I were you, I'd probably talk with others in the community rather than
>> moving to opentaps.  There are people who have integrated pentaho into
>> Apache OFBiz successfully too.  I think that Marco Risaliti - one of the
>> committers here did - but I can't remember if it was him for sure.
>>
>> Cheers,
>> Tim
>> --
>> Tim Ruppert
>> HotWax Media
>> http://www.hotwaxmedia.com
>>
>> o:801.649.6594
>> f:801.649.6595
>>
>> ----- "Michael Xu (xudong)" <[hidden email]> wrote:
>>
>>> hi Thuan,
>>>
>>> You can take a look at opentaps, which is on top of ofbiz. And
>>> opentaps
>>> supports pentaho.
>>>
>>> --
>>> Regards,
>>> Michael Xu (xudong)
>>> www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86)
>>> 135 0135
>>> 9807 | Fax: [phone]
>>>
>>>
>>> On Tue, Apr 7, 2009 at 11:45 PM, Vu Hong Thuan <[hidden email]>
>>> wrote:
>>>
>>>> Hi all,
>>>> I see that the reports in ofbiz is very simple.
>>>> I want to integrate third-party report into ofbiz. I prefer
>>> pentaho.
>>>> Could you give me some suggestion about the integration.
>>>> Thanks.
>>>>
>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJ3GpErP3NbaWWqE4RAvCOAJ0eSmnvH+O84lWbZvXhn9j/Ue9u0ACgrLdr
HNdi7AcdEIMDwslhmD1txqo=
=6LcL
-----END PGP SIGNATURE-----

[BJ Freeman]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I shudder every time some one calls ofbiz a database application.
it takes a lot of work to integrate something that only deals with a
database to work with the entity engine.
So if you have a patch that converts pentaho to the entity engine then
Please share, I would be interested.

Michael Xu (xudong) sent the following on 4/7/2009 10:41 PM:

> hi Tim,
>
> Actually, pentaho technically can integrate with all database applications.
> But point here is pentaho is ready in opentaps but not in ofbiz. When I
> consider which one to go with if BI is a must, I still prefer opentaps.
>
> No offense. Just list my simple reason here :-)
>
> --
> Regards,
> Michael Xu (xudong)
> www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: [phone]
> 9807 | Fax: [phone]
>
>
> On Wed, Apr 8, 2009 at 1:12 PM, Tim Ruppert <[hidden email]>wrote:
>
>> If I were you, I'd probably talk with others in the community rather than
>> moving to opentaps.  There are people who have integrated pentaho into
>> Apache OFBiz successfully too.  I think that Marco Risaliti - one of the
>> committers here did - but I can't remember if it was him for sure.
>>
>> Cheers,
>> Tim
>> --
>> Tim Ruppert
>> HotWax Media
>> http://www.hotwaxmedia.com
>>
>> o:801.649.6594
>> f:801.649.6595
>>
>> ----- "Michael Xu (xudong)" <[hidden email]> wrote:
>>
>>> hi Thuan,
>>>
>>> You can take a look at opentaps, which is on top of ofbiz. And
>>> opentaps
>>> supports pentaho.
>>>
>>> --
>>> Regards,
>>> Michael Xu (xudong)
>>> www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86)
>>> 135 0135
>>> 9807 | Fax: [phone]
>>>
>>>
>>> On Tue, Apr 7, 2009 at 11:45 PM, Vu Hong Thuan <[hidden email]>
>>> wrote:
>>>
>>>> Hi all,
>>>> I see that the reports in ofbiz is very simple.
>>>> I want to integrate third-party report into ofbiz. I prefer
>>> pentaho.
>>>> Could you give me some suggestion about the integration.
>>>> Thanks.
>>>>
>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJ3G2UrP3NbaWWqE4RAoNlAJ9VqbH/LGpGHIm/yOiqWRwICAovaQCfRuHS
iyCgy1xQ4yI3JvHGkgsb3lk=
=vYHb
-----END PGP SIGNATURE-----

[David E Jones-3]

Why would you ever want to have Pentaho run through the Entity Engine?  
In general stand-alone reporting and BI tools like Crystal Reports,  
Business Objects, etc, etc are much better when they talk directly to  
the database.

It is true that long ago we did some stuff so that JasperReports could  
run through the Entity Engine, but honestly I think it made JR _less_  
useful instead of more...

-David


On Apr 8, 2009, at 3:25 AM, BJ Freeman wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> I shudder every time some one calls ofbiz a database application.
> it takes a lot of work to integrate something that only deals with a
> database to work with the entity engine.
> So if you have a patch that converts pentaho to the entity engine then
> Please share, I would be interested.
>
> Michael Xu (xudong) sent the following on 4/7/2009 10:41 PM:
>> hi Tim,
>>
>> Actually, pentaho technically can integrate with all database  
>> applications.
>> But point here is pentaho is ready in opentaps but not in ofbiz.  
>> When I
>> consider which one to go with if BI is a must, I still prefer  
>> opentaps.
>>
>> No offense. Just list my simple reason here :-)
>>
>> --
>> Regards,
>> Michael Xu (xudong)
>> www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86)  
>> 135 0135
>> 9807 | Fax: [phone]
>>
>>
>> On Wed, Apr 8, 2009 at 1:12 PM, Tim Ruppert <[hidden email]
>> >wrote:
>>
>>> If I were you, I'd probably talk with others in the community  
>>> rather than
>>> moving to opentaps.  There are people who have integrated pentaho  
>>> into
>>> Apache OFBiz successfully too.  I think that Marco Risaliti - one  
>>> of the
>>> committers here did - but I can't remember if it was him for sure.
>>>
>>> Cheers,
>>> Tim
>>> --
>>> Tim Ruppert
>>> HotWax Media
>>> http://www.hotwaxmedia.com
>>>
>>> o:801.649.6594
>>> f:801.649.6595
>>>
>>> ----- "Michael Xu (xudong)" <[hidden email]> wrote:
>>>
>>>> hi Thuan,
>>>>
>>>> You can take a look at opentaps, which is on top of ofbiz. And
>>>> opentaps
>>>> supports pentaho.
>>>>
>>>> --
>>>> Regards,
>>>> Michael Xu (xudong)
>>>> www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86)
>>>> 135 0135
>>>> 9807 | Fax: [phone]
>>>>
>>>>
>>>> On Tue, Apr 7, 2009 at 11:45 PM, Vu Hong Thuan <[hidden email]>
>>>> wrote:
>>>>
>>>>> Hi all,
>>>>> I see that the reports in ofbiz is very simple.
>>>>> I want to integrate third-party report into ofbiz. I prefer
>>>> pentaho.
>>>>> Could you give me some suggestion about the integration.
>>>>> Thanks.
>>>>>
>>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFJ3G2UrP3NbaWWqE4RAoNlAJ9VqbH/LGpGHIm/yOiqWRwICAovaQCfRuHS
> iyCgy1xQ4yI3JvHGkgsb3lk=
> =vYHb
> -----END PGP SIGNATURE-----

I'm sorry but I never work on it but I have seen that there is an issue on JIRA (OFBIZ-641) and probably there is an external project (http://sourceforge.net/projects/datawarehouse/) that could support pentaho.
You could read the notes in this JIRA issue and understand which is the status of this integration.

Thanks
Marco

> If I were you, I'd probably talk with others in the community rather than moving to opentaps.  There are people who have integrated pentaho into Apache OFBiz successfully too.  I think that Marco Risaliti - one of the committers here did - but I can't remember if it was him for sure.
>
> Cheers,
> Tim
> --
> Tim Ruppert
> HotWax Media
> http://www.hotwaxmedia.com
>
> o:801.649.6594
> f:801.649.6595
>
> ----- "Michael Xu (xudong)" <[hidden email]> wrote:
>
> > hi Thuan,
> >
> > You can take a look at opentaps, which is on top of ofbiz. And
> > opentaps
> > supports pentaho.
> >
> > --
> > Regards,
> > Michael Xu (xudong)
> > www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86)
> > 135 0135
> > 9807 | Fax: [phone]
> >
> >
> > On Tue, Apr 7, 2009 at 11:45 PM, Vu Hong Thuan <[hidden email]>
> > wrote:
> >
> > > Hi all,
> > > I see that the reports in ofbiz is very simple.
> > > I want to integrate third-party report into ofbiz. I prefer
> > pentaho.
> > > Could you give me some suggestion about the integration.
> > > Thanks.
> > >
>

[BJ Freeman]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

when doing BI you want a flat data info, not relationships, I agree.
so in essence the complete layout of ofbiz does not allow for fast
access of meta data.
the was addressed by generating flat structure entities that represent
the warehouse data needed
Like in most systems I have dealt with there is a nightly build of the
data for use for reports the next day. Similar to the table add code in
ofbiz is a entity build for the flat files.

Why, well for the one reason I came on board with ofbiz ease of maintenance.
:D

David E Jones sent the following on 4/8/2009 2:40 AM:

>
> Why would you ever want to have Pentaho run through the Entity Engine?
> In general stand-alone reporting and BI tools like Crystal Reports,
> Business Objects, etc, etc are much better when they talk directly to
> the database.
>
> It is true that long ago we did some stuff so that JasperReports could
> run through the Entity Engine, but honestly I think it made JR _less_
> useful instead of more...
>
> -David
>
>
> On Apr 8, 2009, at 3:25 AM, BJ Freeman wrote:
>
> I shudder every time some one calls ofbiz a database application.
> it takes a lot of work to integrate something that only deals with a
> database to work with the entity engine.
> So if you have a patch that converts pentaho to the entity engine then
> Please share, I would be interested.
>
> Michael Xu (xudong) sent the following on 4/7/2009 10:41 PM:
>>>> hi Tim,
>>>>
>>>> Actually, pentaho technically can integrate with all database
>>>> applications.
>>>> But point here is pentaho is ready in opentaps but not in ofbiz. When I
>>>> consider which one to go with if BI is a must, I still prefer opentaps.
>>>>
>>>> No offense. Just list my simple reason here :-)
>>>>
>>>> --
>>>> Regards,
>>>> Michael Xu (xudong)
>>>> www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86)
>>>> 135 0135
>>>> 9807 | Fax: [phone]
>>>>
>>>>
>>>> On Wed, Apr 8, 2009 at 1:12 PM, Tim Ruppert
>>>> <[hidden email]>wrote:
>>>>
>>>>> If I were you, I'd probably talk with others in the community rather
>>>>> than
>>>>> moving to opentaps.  There are people who have integrated pentaho into
>>>>> Apache OFBiz successfully too.  I think that Marco Risaliti - one of
>>>>> the
>>>>> committers here did - but I can't remember if it was him for sure.
>>>>>
>>>>> Cheers,
>>>>> Tim
>>>>> --
>>>>> Tim Ruppert
>>>>> HotWax Media
>>>>> http://www.hotwaxmedia.com
>>>>>
>>>>> o:801.649.6594
>>>>> f:801.649.6595
>>>>>
>>>>> ----- "Michael Xu (xudong)" <[hidden email]> wrote:
>>>>>
>>>>>> hi Thuan,
>>>>>>
>>>>>> You can take a look at opentaps, which is on top of ofbiz. And
>>>>>> opentaps
>>>>>> supports pentaho.
>>>>>>
>>>>>> --
>>>>>> Regards,
>>>>>> Michael Xu (xudong)
>>>>>> www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86)
>>>>>> 135 0135
>>>>>> 9807 | Fax: [phone]
>>>>>>
>>>>>>
>>>>>> On Tue, Apr 7, 2009 at 11:45 PM, Vu Hong Thuan <[hidden email]>
>>>>>> wrote:
>>>>>>
>>>>>>> Hi all,
>>>>>>> I see that the reports in ofbiz is very simple.
>>>>>>> I want to integrate third-party report into ofbiz. I prefer
>>>>>> pentaho.
>>>>>>> Could you give me some suggestion about the integration.
>>>>>>> Thanks.
>>>>>>>
>>>>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJ3HdjrP3NbaWWqE4RAuboAKCymgkPWJev4GFl2D8gyPZgPOzXogCgqJlY
tpF1l+O4GOriq1VPtEA34ec=
=zgpL
-----END PGP SIGNATURE-----

[Jacques Le Roux]

Also why not have a look at Spago BI. From many soucers it seems at least as good as Pentaho, and some think (I'm one of them) that
it's even better...

Jacques

From: <[hidden email]>

> I'm sorry but I never work on it but I have seen that there is an issue on JIRA (OFBIZ-641) and probably there is an external
> project (http://sourceforge.net/projects/datawarehouse/) that could support pentaho.
> You could read the notes in this JIRA issue and understand which is the status of this integration.
>
> Thanks
> Marco
>
>> If I were you, I'd probably talk with others in the community rather than moving to opentaps.  There are people who have
>> integrated pentaho into Apache OFBiz successfully too.  I think that Marco Risaliti - one of the committers here did - but I
>> can't remember if it was him for sure.
>>
>> Cheers,
>> Tim
>> --
>> Tim Ruppert
>> HotWax Media
>> http://www.hotwaxmedia.com
>>
>> o:801.649.6594
>> f:801.649.6595
>>
>> ----- "Michael Xu (xudong)" <[hidden email]> wrote:
>>
>> > hi Thuan,
>> >
>> > You can take a look at opentaps, which is on top of ofbiz. And
>> > opentaps
>> > supports pentaho.
>> >
>> > --
>> > Regards,
>> > Michael Xu (xudong)
>> > www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86)
>> > 135 0135
>> > 9807 | Fax: [phone]
>> >
>> >
>> > On Tue, Apr 7, 2009 at 11:45 PM, Vu Hong Thuan <[hidden email]>
>> > wrote:
>> >
>> > > Hi all,
>> > > I see that the reports in ofbiz is very simple.
>> > > I want to integrate third-party report into ofbiz. I prefer
>> > pentaho.
>> > > Could you give me some suggestion about the integration.
>> > > Thanks.
>> > >
>>
>
>

[kunal aggarwal]

how about BIRT. It is a good reporting tool too.


On Wed, Apr 8, 2009 at 4:00 PM, Jacques Le Roux <
[hidden email]> wrote:

> Also why not have a look at Spago BI. From many soucers it seems at least
> as good as Pentaho, and some think (I'm one of them) that it's even
> better...
>
> Jacques
>
> From: <[hidden email]>
>
>  I'm sorry but I never work on it but I have seen that there is an issue on
>> JIRA (OFBIZ-641) and probably there is an external project (
>> http://sourceforge.net/projects/datawarehouse/) that could support
>> pentaho.
>> You could read the notes in this JIRA issue and understand which is the
>> status of this integration.
>>
>> Thanks
>> Marco
>>
>>  If I were you, I'd probably talk with others in the community rather than
>>> moving to opentaps.  There are people who have integrated pentaho into
>>> Apache OFBiz successfully too.  I think that Marco Risaliti - one of the
>>> committers here did - but I can't remember if it was him for sure.
>>>
>>> Cheers,
>>> Tim
>>> --
>>> Tim Ruppert
>>> HotWax Media
>>> http://www.hotwaxmedia.com
>>>
>>> o:801.649.6594
>>> f:801.649.6595
>>>
>>> ----- "Michael Xu (xudong)" <[hidden email]> wrote:
>>>
>>> > hi Thuan,
>>> >
>>> > You can take a look at opentaps, which is on top of ofbiz. And
>>> > opentaps
>>> > supports pentaho.
>>> >
>>> > --
>>> > Regards,
>>> > Michael Xu (xudong)
>>> > www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86)
>>> > 135 0135
>>> > 9807 | Fax: [phone]
>>> >
>>> >
>>> > On Tue, Apr 7, 2009 at 11:45 PM, Vu Hong Thuan <[hidden email]>
>>> > wrote:
>>> >
>>> > > Hi all,
>>> > > I see that the reports in ofbiz is very simple.
>>> > > I want to integrate third-party report into ofbiz. I prefer
>>> > pentaho.
>>> > > Could you give me some suggestion about the integration.
>>> > > Thanks.
>>> > >
>>>
>>>
>>
>>
>
>

[matarazzo angelo]

Hi all,
I followed previous discussions about reporting in Ofbiz.
There were some stuff so that third-party report could work with ofbiz.
This is a list with links or comments:

JasperReport (usage deprecated)
http://docs.ofbiz.org/display/OFBIZ/Open+Source+Projects+and+Standards

BIRT: (doesn't use entity Engine)
https://issues.apache.org/jira/browse/OFBIZ-1348 

DataVision: (there are imported classes in Ofbiz)
http://docs.ofbiz.org/display/OFBIZ/Open+Source+Projects+and+Standards


Now I'm selecting data through the Entity Engine and by JFreeChart I'm generating graphics using  a ChartViewHandler class.

To export ListForm to pdf I'm using XSLT:FO  (FOP) Look at
http://www.nabble.com/Generating-Reports-in-Ofbiz-td8706717.html#a8711198 or
http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-XSLFO

To export to excel or xml I'm following this advice:
http://docs.ofbiz.org/display/OFBIZ/Export+to+Excel

I want to make it clear first that I  would  always like to use entity engine.

My two questions are:
Why DataVision? Is it useful? Who can provide me an example?

I have problems with excel format, is there a way that allows me to create an real excel file and not a xml file?  

Hoping it might be helpful,
thank you for future explanations.

Vu Hong Thuan wrote

Hi all,
I see that the reports in ofbiz is very simple.
I want to integrate third-party report into ofbiz. I prefer pentaho.
Could you give me some suggestion about the integration.
Thanks.

[tanzeem.mb]

I have used POI API inside a java method and   UtilHttp.streamContentToBrowser() to send result to browser. hope this might help you

Angelo Matarazzo wrote

Hi all,
I followed previous discussions about reporting in Ofbiz.
There were some stuff so that third-party report could work with ofbiz.
This is a list with links or comments:

JasperReport (usage deprecated)
http://docs.ofbiz.org/display/OFBIZ/Open+Source+Projects+and+Standards

BIRT: (doesn't use entity Engine)
https://issues.apache.org/jira/browse/OFBIZ-1348 

DataVision: (there are imported classes in Ofbiz)
http://docs.ofbiz.org/display/OFBIZ/Open+Source+Projects+and+Standards


Now I'm selecting data through the Entity Engine and by JFreeChart I'm generating graphics using  a ChartViewHandler class.

To export ListForm to pdf I'm using XSLT:FO  (FOP) Look at
http://www.nabble.com/Generating-Reports-in-Ofbiz-td8706717.html#a8711198 or
http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-XSLFO

To export to excel or xml I'm following this advice:
http://docs.ofbiz.org/display/OFBIZ/Export+to+Excel

I want to make it clear first that I  would  always like to use entity engine.

My two questions are:
Why DataVision? Is it useful? Who can provide me an example?

I have problems with excel format, is there a way that allows me to create an real excel file and not a xml file?  

Hoping it might be helpful,
thank you for future explanations.

Vu Hong Thuan wrote

Hi all,
I see that the reports in ofbiz is very simple.
I want to integrate third-party report into ofbiz. I prefer pentaho.
Could you give me some suggestion about the integration.
Thanks.