PDA

View Full Version : I need to understand how to start from scratch creating my own solution.



crafter
07-06-2007, 06:07 AM
Hi All

I need assistance in understanding what the starting point is in creating a custom solution from scratch.

Just to clarify, I have already communicated my intention of signing on as a partner with Pentaho. I also understand that there are training courses that will help me here. But my dilema is that I am halfway across the world from the training venues, and I don't have a customer yet, so these solutions are not feasable at this very moment.

I have downloaded the PCI and awed at its output, but it's not something I can take to a potential customer.

I need to understand how I can delete the PCI data, create a new database, and convert/use data from an existing source, or create a new source for data.

I understand these are big asks, but perhaps if someone could list a high level step-by-step approach to this, perhaps withj pointers to each step, then it would be a perfect start to my journey.

Thank you.

crafter
07-06-2007, 11:56 AM
OK. I've been frantically searching and found pockets of information that I'm going to piece together that will hopefully made it into the WIKI at some stage.

EDIT: I should explain that I have resorted to constantly editing this post to update information as I have been receiving it. So the content of this post may be constantly changing.

Here a (working) list of steps that should be taken to move from the PCI (or a blank installation for that matter) to a simple solution where a portal with reports, dashboards etc can be presented to your manager/client/spouse.

Preperation
-----------------
- Downloaded and installed Java SDK (Note not JRE)
- Downloaded and installed eclipse
- Downloaded and installed Kettle ETL tool (to extrcat, transform and Laod data)
- Downloaded and installed action sequence plugin (to create actions to display data?)
- More : ????
-
Some info about the PCI
http://forums.pentaho.org/showthread.php?t=53548&highlight=download+kettle

Step 1: Install the PCI
I think most people here have done this already.
http://wiki.pentaho.org/display/PentahoDoc

Step 2; Set up your own database
http://www.nicholasgoodman.com/bt/blog/2006/05/04/connect-to-your-own-database/
- To expand here, I need to connect to a mysql database. so the file mysql-connector-javx-xxxx.ja must be place in the jboss\server\default\lib\ directory.

Step 3: Extract, Transform and Load the Data into the BI repository
- We are speaking here about using tools like KETTLE
http://rpbouman.blogspot.com/2006/06/pentaho-data-integration-kettle-turns.html
http://kettle.pentaho.org/process/
http://wiki.pentaho.org/display/COM/How+to+Configure+Kettle%27s+Spoon+for+a+Pentaho+Solution
There seems to be some discussion at this point about whether or not to create a data wharehouse here or not.
Kettle user manual is included with download. Provides instructions on setting up.


Step 4: ????????

I ask that the more experienced amongst us please chip in to add or correct whereever possible;

pmalves
07-06-2007, 01:12 PM
well, I can say to you're not alone on that race. I have exactly the same problems and I want to achieve the same goal. I can't give you direct answers, but you can IM me (details on profile) and we can help each other on this. :cool:

crafter
07-06-2007, 06:00 PM
Just bumping this thread to alert you about the numerous changes I have made to the second post.

Still anxiously awaiting other's inputs.

wgorman
07-08-2007, 07:38 PM
If you are running a file based repository, simply removing the .xaction files, etc from your pentaho-solutions directory will remove the examples. you can then create your own action sequences by using the Pentaho Design Studio and the Pentaho Report Designer.

Hope that helps!

Will

pmalves
07-09-2007, 01:25 PM
I was running the example in the link you gave me from nicholasgoodman, and I found out that the code he gave does not work in the latest pentaho (1.6). In case you want to test, where's the code that works:



<?xml version="1.0" encoding="UTF-8"?>
<action-sequence>
<title>%title</title>
<version>1</version>
<logging-level>DEBUG</logging-level>
<documentation>
<author>Me</author>
<description>%description</description>
<help>%help</help>
<result-type>rule</result-type>
<icon>HelloWorld.png</icon>
</documentation>

<inputs/>

<outputs>
<query-result type="result-set"/>
</outputs>

<resources/>

<actions>
<action-definition>
<component-name>SQLLookupRule</component-name>
<action-type>SQL Query</action-type>
<action-outputs>
<query-result type="result-set" mapping="query-result"/>
</action-outputs>
<component-definition>
<jndi>mydatasourcel</jndi>
<query><![CDATA[select id,name from adm_entity]]></query>
</component-definition>
</action-definition>

</actions>
</action-sequence>

crafter
07-10-2007, 03:50 PM
pmalves has posted this lovely tutorial that I wanted to link to

HOWTO: My (very big) pentaho install and setup tutorial (http://forums.pentaho.org/showthread.php?t=55186)

Thanks again, pmalves

vamseemandava
07-12-2007, 04:53 AM
Hi Everyone,

I gone through the documentation and installed Pentaho Design Studio and Pentaho Demo.The example application are running fine.

Now my problem is that I want to write my custom solution. I am in a dilema that I want to use the Struts framework to develop the my application,how to add Pentaho framework to struts framework (is that possible?) if not how to create a new solution in Pentaho.

I gone through the sample solutions, For example for take get-started solution,EmailComponant example ,
1, who is sending the email ?(some java file will do that using java mail api,how it finds which class it should execute and which method it should call).
2,If I add new functionality i.e new java file which displays the number of days between the two different dates.Can anybody tell me what are the steps involved in doing that.

I feel I am not alone in using this Open Business Intelligence
Thanks for every one who responded

regards

Vamsi krishna