Palo Community Forum

I have tried Talend Open Studio but prefer Kettle and there is already someone working on a Palo plugin for Kettle.

I haven't asked since the initial thread and I figured that the release of Palo 1.5 might have some influence on the plugin.

Talend is a very nice ETL tool... It generates perl code, which is:
1) Easy to Use
2) Fast - It runs very quickly sometime quicker than C
3) Has great builtin functions including hashes (associative arrays) and regular expressions.

One of the great advantages of Talend over Kettle is it's so easy to extend and create a script task IIRC you can use javascript in Kettle, but this doesn't give you any where near the amount of power you get with Perl.
Perl has so many libraries in CPAN, for example it's very easy to connect to MQ get messages of updates from a database and push those through to your application etc...

I think over all Talend offers greater flexibility, I imagine it would quite difficult to get information using web services and SOAP using KETTLE but this would be just a few lines of code in Talend.

I tried creating a perl extension for Palo using XS at the weekend but had a few problems due to the multiple include header files. I think a talend component would be great but must focus my attentions on OpenOffice first.

Quoted

One of the great advantages of Talend over Kettle is it's so easy to extend and create a script task IIRC you can use javascript in Kettle, but this doesn't give you any where near the amount of power you get with Perl.

Hugo, if anyone would have cared, I'm sure someone would have posted a feature request for Perl scripting support on the Kettle website.

Talend and Kettle are fundamentally different in design. For example, Talend is using code generation while Kettle is not. As such I suspect that it caters to a different target audience. I suspect that that audience is a bit more developer/perl Oriented.

It's also interesting to note that in the latest development version of Kettle we allow the output of a Kettle transformation to be sent to any 3rd party program, including Perl. Perhaps this offers a bridge between Kettle & Talend.

You see, open source software is about cooparation, not about spreading FUD.

Matt

Matt

I certainly didn't intend to spread FUD, I like Kettle and think you have done a great job. At the time I wrote this I wasn't thinking fully since I fogot that it was possible to use any of the java libraries from the java script task.
I guess my post seemed a little negative toward kettle, which I didn't intend indeed I have been a fan of kettle since November 2005 when I first came accross it.
I appreciate the difference between Talend and Kettle, and can see the usefulness for both... Actually I use metadata driven ETL tools regularly at work (Informatica) but I also find it useful to hand craft code. I guess after dealing with the constraints impossed by informatica I sometimes welcome something different, and having the ability to script offers a lot of possibilities / flexibility.

Hugo

Quoted

Actually I use metadata driven ETL tools regularly at work (Informatica) but I also find it useful to hand craft code. I guess after dealing with the constraints impossed by informatica I sometimes welcome something different, and having the ability to script offers a lot of possibilities / flexibility.

Thanks for the reply Hugo. I think that if we keep our eye on the ball and focus on the strengths of the various tools, rather than the weaknesses, we can make a difference in open source software.

I hope with your experience with Informatica that you appreciate the fact that we went with a standards based language such as JavaScript. Creating your own language might solve a few problems but it will also create a few new ;-)

Please feel free to post bug reports and/or feature request if you think certain features are lacking in Kettle. We have already implemented many great new ideas from experienced BI folks such as yourself.

All the best,

Matt

Matt the driving force behind Kettle has just informed me that SQLite is now supported by the next release of Kettle, add support for Palo as a plugin and I'd be a happy man.

Tom

Quoted

Originally posted by gleesoto
Matt the driving force behind Kettle has just informed me that SQLite is now supported by the next release of Kettle, add support for Palo as a plugin and I'd be a happy man.

Tom

Hi, could you, please update us on the availability status of this Kettle plugin? Is it available for download/testing? Any dates to look forward to?

R.

Bart,

The folks from Tripple-A-Strategies have created a modified version of the Kettle codebase with the PALO functionality in it, rather than a plugin, but we are working with them to resolve this issue and help them achieve compliance with the LGPL license...

So there is something you can use to access PALO, but I would recommend against using it. They are a major version and hundreds of bug fixes behind on the latest development in Pentaho Data Integration a.k.a. Kettle.

All the best,

Matt

Then why not advertising when the product is ready?

Marketing always is very close to making people angry and an announcement could also have been done like "if you are struggling with the basic mechanisms offered by the palo plugin I'd like to inform you that we are developing a solution which ...
This new tool is scheduled to be released on DDMMYY. Anybody who wants to know if this new option suites his/her special needs in advance is free to regularily check on the website dedicated to this tool: www.imppalo.com"

Am I asking too much? And I'm not even in marketing at all!

Cheers,
Mario

Hello Irbis,

The IMP : Palo is not available yet for downloading, that's probably why it
has not been advertised? There's no date available yet, but an option to
receive an email.

Everybody has talents ;-)

Regards,
Stephanie

Hi,

If you are interested in this topic and want to learn more on the interactions between talend and Palo solutions, attend one of the following webinars!

Open Source Data Analysis with Talend and Palo

This one-hour FREE Webinar run by Jedox and Talend will present:
- How to extract your heterogeneous data with Talend and prepare it for reporting and multidimensional analysis
- How to centralize and manage high-performance Excel-based reporting and analysis with Palo
- How to get quick results and optimize your return on investment
- Why open source is the right solution for data analysis

in English : https://www2.gotomeeting.com/register/374537444 (19th of May 2009)
in French : https://www2.gotomeeting.com/register/624420639 (19th of May 2009)
in German : https://www2.gotomeeting.com/register/666108473 (13th of May 2009)

Hello to all,

Just to make it clear, there are components available between Talend and Palo. You can find available components on the Talend website: http://www.talendforge.org/components/index.php.

---
About Talend Open Studio, it is an open source ETL tool for data integration experts with a user-friendly GUI, easy to learn for a non-technical user. What distinguishes Talend, when it comes to business users, is the tMap component which allows the user to get a graphical and functional view of integration processes. For more information: http://www.talend.com/

A comparison talend vs kettle:
http://www.robertomarchetto.com/www/tale…_pdi_comparison

Talend provides some usefull components specific to Palo management:
http://www.robertomarchetto.com/www/tale…lti_tPaloOutput