Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: COMPLETE newbie to the tool

  1. #1
    Join Date
    Nov 2008
    Posts
    3

    Default COMPLETE newbie to the tool

    Hello.

    This may seem as a naive question (and probably is), but where exactly do I start after downloading and installing the Pentaho BI Server System? (I installed the complete, downloadable - pentaho-1.7GA-windows-opensource-installer.exe) file. It seems that there is no "Beginners / Just Starting / etc." documentation out there.

    Being somewhat technically inclined, having a basic understanding of BI/DW/ETL, etc concepts and knowing Java, I was able to install, start up MySQL and JBoss, figure out the basic higherarchy / tree of the file system, log-in as every one of the default users. (Joe Admin, Sue, Tiffany, etc.) by running the Pentaho BI Platform index file in the jboss directory, etc. I get the whole Dashboards, Analytics, Reports, etc. concept (having used these before as the end user.) I know what ETL is and the concept behind it.

    But where do I start with platform? I guess my main questions are:

    - where would I "start" with learning the actual system
    - is there relevant "complete beginner" documentation
    - data sources and how they work (I know that the underlying DB is MySQL......oh, and Hyperion......how are they used differently?)
    - is Mondrain OLAP server a separate server or is it a part of what I have installed
    - has nyone seen my keys? I seem to have mis-placed them :-)

    Many, many thanks in advance for your help!

  2. #2

    Default

    good to hear you're up and running, on the downside 2.0 should be released in the next few days and it has a lovely new UI Anyway back to the question in hand...

    My advice is to start slowly and concentrate on one tool at a time, I guess you want to generate reports with your own data so you have to learn how to add jndi datasources to jboss/tomcat, you may want to do some ETL stuff in which case download Kettle. Once you have your data in place then you need to learn reporting, so grab a copy of report designer and play around with it. Once you have learnt how to create reports, you may want to add prompts and things to them so learning Pentaho Data Integration would be the next step, then there's metadata, and on it goes.

    So there really is no starting point and there is no beginners documentation as such, but there is plenty of help on the wiki and with the help of the samples included with Kettle and Report designer there should be enough there to get you going and keep you occupied

    Hope thats a start

    Tom
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  3. #3
    Join Date
    Nov 2008
    Posts
    3

    Default

    Many thanks Tom.

    OK, I will begin with:

    >>>>generate reports with your own data so you have to >>>>learn how to add jndi datasources to jboss/tomcat,

    Could you (ahem) will point me to how to just begin do that? (Believe it or not, I know what JNDI is... :-)) How do I actually access MySQL to create a sample DB so that I cab access it from the BI Platform (via JNDI)

    Thanks again!

    Quote Originally Posted by bugg_tb View Post
    good to hear you're up and running, on the downside 2.0 should be released in the next few days and it has a lovely new UI Anyway back to the question in hand...

    My advice is to start slowly and concentrate on one tool at a time, I guess you want to generate reports with your own data so you have to learn how to add jndi datasources to jboss/tomcat, you may want to do some ETL stuff in which case download Kettle. Once you have your data in place then you need to learn reporting, so grab a copy of report designer and play around with it. Once you have learnt how to create reports, you may want to add prompts and things to them so learning Pentaho Data Integration would be the next step, then there's metadata, and on it goes.

    So there really is no starting point and there is no beginners documentation as such, but there is plenty of help on the wiki and with the help of the samples included with Kettle and Report designer there should be enough there to get you going and keep you occupied

    Hope thats a start

    Tom

  4. #4

    Default

    This guide takes you through talking to a db:
    http://wiki.pentaho.com/display/Pent...ho+BI+Platform

    Once thats up and running you will be able to use it with the pentaho server, obviously you will need some data in the database before hand.
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  5. #5
    Join Date
    Nov 2008
    Posts
    3

    Default

    I thank you from the bottom of my black, nicotine filled lungs. :-)

    Quote Originally Posted by bugg_tb View Post
    This guide takes you through talking to a db:
    http://wiki.pentaho.com/display/Pent...ho+BI+Platform

    Once thats up and running you will be able to use it with the pentaho server, obviously you will need some data in the database before hand.

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.