[libreoffice-users] Data Pilot - external Data

Hello,
I've been searching the documentation and the forums for a hint on the
following questions:

I am using the Pivot Table functionality of calc to analyse data in a MySQL
Server.
I've succeded in doing this on my own computer, by creating a base
document, linked to the source server.

My first question is as follows: I find this a little bit confusing: is
there a way to directly link Calc to the SQL server via a DSN, like Excel
does ?

Secondly, i'd like to distribute the spreadsheet prepared on my computer to
an range of users, so that they can just "refresh" the data in those
spreadsheet from the source server.

Therefore my second question is as follows: how can i minimize the
installation work on the other users computers, for them to do this ? In
Excel, that is very easy as you can just mail the spreadsheet that contains
the source server's "address".
Is there a way just to distribute the base document containing the link to
the server and the calcs ?

Thanks a lot,

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted