Use the FFXIV.config to setup your controller. It is in your Program Files\FFXIV folder. May want to shortcut it to desktop until you have it how you want. Your generic PC controller should work fine after this.
360 Wired Controller works
360 Wireless Controller - you need a wireless receiver for PC, it also turns itself off when you are AFK (You need the Plug'n'Charge kit to work around this)
PS3 Controller works
Logitech Rumble Pack 2 is a very nice controller with precise joysticks - I bought one of these and love it
Here is some more info: http://ffxiv.zam.com/forum.html?forum=152&mid=1291928176161651112