On Wed, Mar 13, 2013 at 09:48:32PM +0100, Eike Rathke wrote:
I believe the same functionality can be achieve via database
connectivity, by having such external data provider register as a
database, and use it to act as a data provider for pivot tables.
So, I don't see a reason why we need to keep this as a separate data
source category.
IMHO the advantage of the data provider is that the actual data does not
have to reside in the spreadsheet, allowing for massive amounts of data
records but providing only the information necessary for the pivot
table. This maybe could be accomplished as well using a registered data
source, but currently we have no means to pull the data without actually
storing it in the spreadsheet for further processing. Or isn't that the
case?
Naively, I don't immediately see why when using database connectivity,
you'd have to store the data in the spreadsheet?