You'll need to pair the controller to a compatible phone using USB, but it'll be wireless from there on out. No extra software will be needed.
There's a video of the new functionality using the upcoming Xperia SP below – you'll notice footage Cordy 2, The Conduit HD and Sonic the Hedgehog Episode 2.