You are not logged in.

Connection to PALO ETL Server

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.

JuergenK

Professional

  • "JuergenK" started this thread

Posts: 24

Date of registration: Jul 10th 2010

  • Send private message

1

Thursday, October 14th 2010, 5:48pm

Connection to PALO ETL Server

Hi,

I have created database and cubes at PALO ETL Server. I start IMP:Palo and find the created database, but not dimensions, cubes, etc.

Has anybody an idea?

Thanks, Juergen

tish1

Sage

Posts: 761

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

2

Thursday, October 14th 2010, 11:28pm

Hi,

do you see all your dimensions and cubes in your Excel Add-In?

Regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH

JuergenK

Professional

  • "JuergenK" started this thread

Posts: 24

Date of registration: Jul 10th 2010

  • Send private message

3

Friday, October 15th 2010, 10:12am

Hello Robert,

yes, I can see all the dimensions at Excel addon but no one at IMP Palo.

Thanks, Juergen

Michel

Sage

  • "Michel" is male

Posts: 154

Date of registration: Jun 1st 2007

Location: Netherlands

  • Send private message

4

Friday, October 15th 2010, 11:12am

Hi,

Did you right-click on the OLAP conection in you Import definition and select 'Read Structure'?
This will read in the current DB structure.

Michel

JuergenK

Professional

  • "JuergenK" started this thread

Posts: 24

Date of registration: Jul 10th 2010

  • Send private message

5

Friday, October 15th 2010, 11:34am

Hello Michel,

thanks a lot! This was the solution...

Regards, Juergen

tish1

Sage

Posts: 761

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

6

Monday, October 18th 2010, 10:55pm

Hi Folks,

how do you like IMP Palo. I used Cubeware's Importer a lot a few years ago, but heard, that IMP Palo has many limitations, actually rendering it useless in most environments. What are your thoughts about this?

Regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH

holger_b

Sage

  • "holger_b" is male

Posts: 271

Date of registration: Jun 1st 2010

Location: Freiburg, Germany

Occupation: BI Consultant

  • Send private message

7

Tuesday, October 19th 2010, 10:03am

Hi Robert,

the biggest problem in my eyes is that you do not know how long IMP:Palo will be there as a freeware product, so you may run into issues when using it in a project (I believe the free license expires end of 2010, so what will you do in case it is not continued?)

Apart from that, it is a stripped-off Cubeware Importer which I learnt to like during the last couple of months. In my eyes, it is nice to handle, especially the fact that you can code more or less anything you can think of, I feel it is more flexible than Palo ETL, which on the other hand runs faster to my experience.

Regards
Holger

JuergenK

Professional

  • "JuergenK" started this thread

Posts: 24

Date of registration: Jul 10th 2010

  • Send private message

8

Tuesday, October 19th 2010, 10:24am

Hello Robert,

Cubeware Importer is the first choice in ETL processes. But for learning basics of ETL, especially cube methodes, the Palo ETL is perfect.

IMP Palo is time limited, therefor I don't want to use it.

Regards, Juergen

tish1

Sage

Posts: 761

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

9

Wednesday, October 20th 2010, 8:59am

Hi Holger / Jürgen,

are there any limitations on the number of lines you can process? Or anything else?

Regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH

Michel

Sage

  • "Michel" is male

Posts: 154

Date of registration: Jun 1st 2007

Location: Netherlands

  • Send private message

10

Wednesday, October 20th 2010, 4:09pm

Hi tish1,

The free version of Importer (IMPPalo) indeed has a limit on the number of lines that can be processed within a job/mapping - this limit is on 50.000 lines. Another limit is that you can't schedule jobs.

If the number of lines you need to process in a single job/mapping is below 50.000 lines and it is not neccessary to schedule the jobs, then IMPPalo is a great, easy to use data-processing/ETL tool. And there always is the option to upgrade to a full Importer, without the limitations...

Michel

tish1

Sage

Posts: 761

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

11

Wednesday, October 20th 2010, 9:13pm

Hi All,

I really start missing the nice Importer TCL/something scripts . . .

Regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH
Rate this thread