I have the PC Mac version of Skyrim and tried mapping my Sony PS3 controller to it with no luck. I used joystick binding app to verify connectivity but it will not map in Skyrim game itself. Any ideas?

Are you using Bootcamp? You'll need to install a driver wrapper, I'd recommend SCP