|
  |
 Talend ETL for Eclipse / PALO 1.5 ? |
|
|
| Talend ETL for Eclipse / PALO 1.5 ? |
     |
Hi,
Any experience with www.talend.com ETL tool for Eclipse ?
Maybe a nice tool to have any data transfered to PALO 1.5 format ?
Regards, Marco
www.gmsbv.nl
|
|
11-08-2006 04:25 |
|
|
bmm
Member
Registration Date: 02-16-2006
Posts: 43
Location: Denmark
 |
|
|
|
11-08-2006 11:17 |
|
|
Marco Groeneveld
Double Ace
Registration Date: 10-27-2005
Posts: 137
Thread Starter 
|
|
Is there already any news regarding the plugin ?
Marco
|
|
|
11-09-2006 10:02 |
|
|
bmm
Member
Registration Date: 02-16-2006
Posts: 43
Location: Denmark
|
|
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.
|
|
|
11-09-2006 14:25 |
|
|
Hugo
Full Member
Registration Date: 10-26-2005
Posts: 60
|
|
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.
|
|
|
11-09-2006 17:58 |
|
|
Marco Groeneveld
Double Ace
Registration Date: 10-27-2005
Posts: 137
Thread Starter
|
|
Great to hear the news.
I asked the Talend people for support of PALO but it was not so easy to find on the palo website. I asked the JPALO people while they are experienced with Eclipse and maybe Talend + JPALO people can cooperate and make an extesion for Talend to load data from SQL databases direct in the PALO 1.5 XML or is it now CSV fileformat.
Any input is welcome.
By the way let me know when you have an OpenOffice Addin for PALO available.
Regards, Marco
|
|
|
11-09-2006 21:34 |
|
|
MattCasters 
Newbie
Registration Date: 11-27-2006
Posts: 5
Location: Brussels
|
|
| quote: |
| 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 Casters, Chief Data Integration
Pentaho, Open Source Business Intelligence
http://www.pentaho.org -- mcasters at pentaho dot org
|
|
|
11-27-2006 11:26 |
|
|
Hugo
Full Member
Registration Date: 10-26-2005
Posts: 60
|
|
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
|
|
|
11-27-2006 23:11 |
|
|
MattCasters
Newbie
Registration Date: 11-27-2006
Posts: 5
Location: Brussels
|
|
| quote: |
| 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 Casters, Chief Data Integration
Pentaho, Open Source Business Intelligence
http://www.pentaho.org -- mcasters at pentaho dot org
|
|
|
11-27-2006 23:26 |
|
|
bart
Newbie
Registration Date: 01-15-2007
Posts: 3
|
|
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.
|
|
|
01-15-2007 20:12 |
|
|
MattCasters
Newbie
Registration Date: 11-27-2006
Posts: 5
Location: Brussels
|
|
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
__________________
Matt Casters, Chief Data Integration
Pentaho, Open Source Business Intelligence
http://www.pentaho.org -- mcasters at pentaho dot org
|
|
|
02-25-2007 19:57 |
|
|
Marco Groeneveld
Double Ace
Registration Date: 10-27-2005
Posts: 137
Thread Starter
|
|
|
|
02-25-2007 20:26 |
|
|
Irbis
Double Ace
Registration Date: 07-12-2006
Posts: 109
Location: Magdeburg
|
|
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
|
|
|
02-26-2007 09:21 |
|
|
Stephanie
Viking
Registration Date: 10-23-2006
Posts: 540
Location: Freiburg
|
|
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
|
|
|
02-27-2007 09:12 |
|
|
|
|
| Interaction b/w Talend and Palo |
|
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)
|
|
|
05-11-2009 14:16 |
|
|
Tgroul
Junior Member
Registration Date: 06-18-2009
Posts: 10
|
|
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/
|
|
|
06-18-2009 12:00 |
|
|
|
|
|
|
|
Kettle/PALO