Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Professional Vs Open source

  1. #1

    Default Professional Vs Open source

    Hi Frends,
    I have a very basic question.
    I am using Tomact5.5,Mysql 5.0,All the product listed here in
    pentaho latest download.

    Now I want to know if I want to run my report using MYSQl as database over Tomcat.

    Do I need the professional version On BI as Its mentioned that
    Data Integration feature is not there in open source BI demo.

    Actually I manged to create a report through open source report
    desgner with mysql jdbc connector (using mysql as database).

    Then I was able to run the samples on tomcat using that Advanced
    Installation Guide.

    When I was creating the report I found one link in Report designer
    itself named Publish.

    So i just created a .Xaction file and a .xml file with that option.

    Then I place these to files in pentaho-solution->sample->reporting
    folder and restarted tomcat .

    report icons are there showing up .But when I am clicking those
    ones ,some errors not the report.

    So should I need somw more chnges to do to work with mysql.

    I did mysql database connectivity only at the time of creating
    reports (report designer) .

    So I want to clear my idea of doing web based reporting (excel
    format)using my own database(tables).

    What I need for doing this and how much it cost.

    own database ,set of tables.

  2. #2
    Join Date
    Nov 1999

    Default Re:Professional Vs Open source

    I think all you need is the documentation actually.

    I'm going to bet that you didn't get the mysql JDBC driver put in the right place in the platform. In our Getting Started guide available on sourceforge, there should be a nice chapter in there about integrating reports with your own data.

    It covers the need to get the JDBC driver placed in the platform. To get you there quickly, you'll need to copy the mysql-connector JAR file into the jboss/server/default/lib directory. If it's not there, then it's not possible to talk to your database.

    Oh yeah - we'd consider this to be the absolute most basic functionality.

    I seriously recommend that you review all our documentation which is available online from Sourceforge. It covers material from getting started with the platform (for everybody) to the advanced developer that wants to extend the platform (component writers guide).

    Take care, and I hope this helps,


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.