You are not logged in.

Talend Palo Experience

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

holger_b

Sage

  • "holger_b" is male
  • "holger_b" started this thread

Posts: 271

Date of registration: Jun 1st 2010

Location: Freiburg, Germany

Occupation: BI Consultant

  • Send private message

1

Tuesday, July 6th 2010, 11:46am

Talend Palo Experience

Hi all,

who has some experience using Talend togehter with Palo? How smoothly (or not) do they work together?

Regards
Holger

holger_b

Sage

  • "holger_b" is male
  • "holger_b" started this thread

Posts: 271

Date of registration: Jun 1st 2010

Location: Freiburg, Germany

Occupation: BI Consultant

  • Send private message

2

Tuesday, July 6th 2010, 6:00pm

RE: Talend Palo Experience

I saw by now there are loads of posts to answer my question, only they were not in the place I expected. Just search for "Talend".

My first impression by the way is that Talend is perfect for techies (which I am not), if you are not much more than a copy and paste programmer you will probably prefer other tools. Like Palo ETL Server :-).

tish1

Sage

Posts: 761

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

3

Wednesday, October 27th 2010, 3:18pm

Hi Holger,

I'm currently testing Talend's new Palo Components for a solving a task probably not possible in ETL Server very easily.
The functional range looks quite impressive - especially when compared to Kettle but now I got a little stuck over the usage of tPaloMultiInput.
One thing that comes in to my mind when I see the tPaloMultiInput component; where are the flags to omit rule calculated, string or consolidated values?

Regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH

This post has been edited 1 times, last edit by "tish1" (Oct 27th 2010, 3:32pm)

holger_b

Sage

  • "holger_b" is male
  • "holger_b" started this thread

Posts: 271

Date of registration: Jun 1st 2010

Location: Freiburg, Germany

Occupation: BI Consultant

  • Send private message

4

Wednesday, October 27th 2010, 4:01pm

Hi Robert,

sorry I gave up after I saw how technical it was. It sure helps if you are a Java and/or a Perl programmer (which I am not), and even the Talend people said at the Palo Open that one needs quite some training to get it up and running.

Many words to say sorry I cannot help :-)

Cheers
Holger

tish1

Sage

Posts: 761

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

5

Wednesday, October 27th 2010, 4:08pm

Hi Holger,

how will I ever get this done without your help?
In many aspects Talend looks a lot easier to use than ETL Server
  • nice graphical design interface
  • simple setup (no web or application servers needed)


Regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH

Withnail

Professional

Posts: 34

Date of registration: Mar 30th 2009

Location: Australia

Occupation: BI Consultant

  • Send private message

6

Friday, October 29th 2010, 6:30am

Hi Guys,

We are road testing the Talend Components over here in Australia. I am very impressed with the range of functionality now built in to Talend and its connectivity to other BI tools/ databases.

Do you know if there is any help available for the new Palo functions in Talend? I have got a number of them working but have had an issue trying to read / write Palo using the tPaloMulitInput.

Does anyone have any examples /screenshots to share of a tPaloMulitInput against the demo Sales cube?

cheers,

Withnail
Naked Data
Business Intelligence & Performance Management
Level 23 40 City Road Southbank 3006 VIC Australia
national: +61 1300 406 334
www.nakeddata.com

tish1

Sage

Posts: 761

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

7

Friday, October 29th 2010, 12:22pm

Hi,

I think your questions have already been asked ;-)
http://www.jedox.com/community/palo-foru…p?threadid=2799
You will also find a screenshot there. Does it help?

I can only get data from Palo cubes with this component by manually specifying the relevant elements. But I really miss the features from the Palo export.

Did you test the tPaloMultiOutput yet?

Regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH

=NK=

Beginner

Posts: 1

Date of registration: Nov 4th 2010

  • Send private message

8

Thursday, November 4th 2010, 7:20pm

Some days ago I built a complete database (1 cube, about 10 dimensions) by using the tPaloMultiOutput. One dimension "Organization" had quite flexible, unbalanced hierarchy.

I had quite a success with it, though error debugging was a pain for the measures/facts. The debugging got easier once I set the commit threshold to 0, so I could identify the measures which caused the issue. Normally the issue was a missing element or data quality issue in general.

Also I noticed that the sort order of import does not reflect the sort order in the dimension internally. Though that might be fixed with a commit size = 1 also here.

A good start was the Talend Webinar which showed the Palo Components already some time ago:
"Open Source Daten Analyse mit Talend & Palo" at http://de.talend.com/webinar/archive/index.php

tish1

Sage

Posts: 761

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

9

Thursday, November 4th 2010, 10:02pm

Hi,

nice to know. What about performance compared to Palo ETL Server?
Has anyone tested the Talend Component tPaloInputMulti?

Regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH

nancygale12

Beginner

Posts: 1

Date of registration: Nov 16th 2010

  • Send private message

10

Tuesday, November 16th 2010, 6:50am

Hey......guy.......that's great.........! Nice info u have shared and I really appreciate with that.



Thanks for sharing
performance management training

robertom

Intermediate

Posts: 7

Date of registration: Jun 26th 2011

  • Send private message

11

Sunday, June 26th 2011, 2:18pm

Palo Suite has a simple ETL tool, but Talend is a tool worth to learn for complex and general scenario.

Look at these tutorials:

http://www.robertomarchetto.com/www/tale…lti_tPaloOutput

http://www.robertomarchetto.com/www/usin…ubes-dimensions
Business intelligence consultant
http://www.robertomarchetto.com
Rate this thread