Is there any plans to integrate with OO's Datapilot in similar fashion to how Palo can integrate with Excel Pivot-Tables?
Or is that a completely separate beast?
Unfortunately I didn't look at this closer. It's currently not planned (from my side) and I don't know, how far Palo integrates into Excel's Pivot Tables. But I guess it should at least be possible, sometime in the future.
There is support for ODBO connection in PALO Client install, so it is possible to use it with Excel Pivots and PALO DB. It is described in Palo 3.0 Manual.