Palo Forum
Register Calendar Members List Team Members Search Frequently Asked Questions Go to the Main Page

Palo Forum » Palo for Excel » Data Import » Import data with Kettle » Hello Guest [Login|Register]
Last Post | First Unread Post Print Page | Recommend to a Friend | Add Thread to Favorites
Pages (2): « previous 1 [2] Post New Thread Post Reply
Go to the bottom of this page Import data with Kettle 2 Votes - Average Rating: 5.50
Author
Post « Previous Thread | Next Thread »
Axel
Member


Registration Date: 10-03-2006
Posts: 29
Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page
Good day!

>>Is this plug-in compatible with Kettle version 2.4? Or it is just for 2.3.1 version.

That's not a plugin actually... Our _version_ was created on 3.2.1 codebase. Probably we'll make migration to 2.4 codebase, but not in the nearest future

Thanks,
Axel
02-08-2007 08:24 Axel is offline Send an Email to Axel Search for Posts by Axel Add Axel to your Buddy List
Hassan
Junior Member


Registration Date: 11-01-2006
Posts: 10

Thread Starter Thread Started by Hassan
Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page
And where do we report bugs/suggestions ???

Samatar
02-08-2007 09:35 Hassan is offline Send an Email to Hassan Search for Posts by Hassan Add Hassan to your Buddy List
h_decker h_decker is a male
Viking


images/avatars/avatar-34.jpg

Registration Date: 10-26-2005
Posts: 714
Location: Cologne, Germany
Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page
Hi Axel,
I got a question concerning setting up a new PALO connection. I use PALO 1.5 RC2, Port 7777. I chose 1.5 Release in PALO Register and HTTP Interface. When trying to test the connection (Database: Demo), spoon closes. Trying the legacy interface, it seems to hang. Any hint how to establish a connection to a PALO1.5 server.

-----
Update:
Just defined legacy connection in palo.ini. Connection is possible now.
HTTP access via Port 7777 still crashes.

Thanx in advance
Holger

This post has been edited 2 time(s), it was last edited by h_decker: 02-08-2007 11:18.
02-08-2007 10:39 h_decker is offline Send an Email to h_decker Search for Posts by h_decker Add h_decker to your Buddy List
Axel
Member


Registration Date: 10-03-2006
Posts: 29
Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page
>>And where do we report bugs/suggestions ???

Write that to me - we do not have established bugtracking system yet.

>>HTTP access via Port 7777 still crashes.

Really strange - i'm using same version (both kettle and Palo). Could you send me description of OS/SP level? Please mail it to me...

Thanks,
Axel
02-08-2007 11:57 Axel is offline Send an Email to Axel Search for Posts by Axel Add Axel to your Buddy List
Hassan
Junior Member


Registration Date: 11-01-2006
Posts: 10

Thread Starter Thread Started by Hassan
Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page
I got the same pb.
When trying to explore the database, SPOON closed.
02-08-2007 11:57 Hassan is offline Send an Email to Hassan Search for Posts by Hassan Add Hassan to your Buddy List
Axel
Member


Registration Date: 10-03-2006
Posts: 29
Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page
Have you downloaded update only or full package from page provided?

Thanks,
Axel
02-08-2007 12:15 Axel is offline Send an Email to Axel Search for Posts by Axel Add Axel to your Buddy List
h_decker h_decker is a male
Viking


images/avatars/avatar-34.jpg

Registration Date: 10-26-2005
Posts: 714
Location: Cologne, Germany
Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page
full package
02-08-2007 13:58 h_decker is offline Send an Email to h_decker Search for Posts by h_decker Add h_decker to your Buddy List
jholbrecht jholbrecht is a male
Newbie


Registration Date: 02-09-2007
Posts: 1
Thumb Up! Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page
The palo input and output is cool... good job.

I do have 1 reservation for using it... it's only kettle 2.3.1 (not 3.2.1 as the website states btw), and it's not a plugin. So I still have bugs that are already fixed in Kettle and if I want to use other components that also use your way of extending Kettle I would be pretty much stuck.

Will the palo Kettle version also be open source or not, or is that not yet decided. And how will you handle upgrades to newer versions of Kettle?

What is your time line for upgrading Kettle. Always one version behind?

Regards,
Jan
02-09-2007 13:15 jholbrecht is offline Send an Email to jholbrecht Search for Posts by jholbrecht Add jholbrecht to your Buddy List
bmm
Member


Registration Date: 02-16-2006
Posts: 43
Location: Denmark
Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page
Nice work on the Palo addition (since plug-in now won't be the correct concept) to Kettle.

Besides the current Palo (Cube) Input and Output Steps I would like to see Palo Dimension Input and Output Steps.

The Palo Dimension Output Step should basically mimic the Excel PALO.EADD function having options to select Connection, Cube and Dimension, be able to receive Type, Element, Parent Element and Weight from source steps and also have an option to clear the dimension in advance.

The Palo Dimension Input Step should retrieve the same types of data: Type, Element, Parent Element, Weight and as a useful addition also the level in the dimension hierarchy for each element. The last field would make it easy to do a number of stream lookups in Kettle to convert the Palo parent-child hierarchy to a level-based hierarchy (putting data for each level in different columns/fields).

From the documentation I guess that I should be able to use the Palo Rule step (that seems very powerful) to do the above actions, but that will require work to create the correct rules and then it almost seems easier to load dimensions through the ordinary Excel add-in.

Regards,
Bent
02-10-2007 06:19 bmm is offline Send an Email to bmm Homepage of bmm Search for Posts by bmm Add bmm to your Buddy List
paolo paolo is a male
Member


Registration Date: 02-10-2006
Posts: 39
Location: Italy, Milano
Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page
Great job !

Axel, since connection interface seems the same in Kettle and in Jreport I would like to use the connection interface you made.

Ca va sans dire that I will share the solution if I have success!

Can you give me some hins?

Thanks,

Paolo
03-29-2007 15:03 paolo is offline Send an Email to paolo Homepage of paolo Search for Posts by paolo Add paolo to your Buddy List
Pages (2): « previous 1 [2] Tree Structure | Board Structure
Jump to:
Post New Thread Post Reply
Palo Forum » Palo for Excel » Data Import » Import data with Kettle

Forum Software: Burning Board 2.3.6, Developed by WoltLab GmbH