You are not logged in.

using access-database with etlserver

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.

Berlin2009

Trainee

  • "Berlin2009" is male
  • "Berlin2009" started this thread

Posts: 3

Date of registration: Feb 4th 2009

  • Send private message

1

Wednesday, February 4th 2009, 11:17am

using access-database with etlserver

Hello,

I have to work with the etl server and the palo-server excel-addin.
It is my first projekt with this software and I have to do it for the university ;-)

I have already read the etl-manual and googled a lot but I can not solve my problem.

I have to load an access-database up onto the etlserver but I can't get though.
I have already built up an ODBC-connection and the server is running.


Is it possible to load a whole database with its tables onto the etl server?
How could I do that?

dibe0014

Sage

Posts: 85

Date of registration: Sep 25th 2008

Location: Oakville, ON

  • Send private message

2

Wednesday, February 4th 2009, 12:20pm

Hi,

you don't load anything on the ETL-Server, you can only use it together with the Palo OLAP Server. The ETL-Server is just for the ETL (Extract - Transform - Load) not to store data.
I think there are some examples when you install ETL Server and Palo OLAP Server, maybe even with an Access file. You could also try to use the import assistant that comes with the Excel add-in.

Benjamin
My blog on Open Source BI and living in Canada

Berlin2009

Trainee

  • "Berlin2009" is male
  • "Berlin2009" started this thread

Posts: 3

Date of registration: Feb 4th 2009

  • Send private message

3

Wednesday, February 4th 2009, 8:31pm

Hi,

thanks for your answer :)

I will try to solve that problem.

Berlin2009

Trainee

  • "Berlin2009" is male
  • "Berlin2009" started this thread

Posts: 3

Date of registration: Feb 4th 2009

  • Send private message

4

Friday, February 6th 2009, 12:54pm

...

Hi again,

i can't solve the problem:-(

info:
Win Xp
Palo Server...running
ETL Server...running
ETL Client
Palo Excel-Addin

i want to create a datacube from a access-database.
The Palo samples are xml's.
what can i do?! did i have to create a xml-file to reach the access-datatbase?!
sorry, but i'm a really newbee!

Thanks

dibe0014

Sage

Posts: 85

Date of registration: Sep 25th 2008

Location: Oakville, ON

  • Send private message

5

Friday, February 6th 2009, 1:17pm

Hi,

did you read the manual already? Some parts of it are free.

English Version: http://worksheetserver.com/download/pdf/…ual_Excerpt.pdf

German Version: http://worksheetserver.com/download/pdf/…buch_Auszug.pdf

The free chapters explain the main structure of Palo and how it works. Using the import assistant (in the Excel Addin) you can import files from csv and txt files and also from odbc connection.

There is also a manual available for the ETL-Server if you want to use it for importing: http://www.jedox.de/en/products/palo_etl…r/download.html

Ben
My blog on Open Source BI and living in Canada
Rate this thread