Consoles, huh? I know how to go PC; a little harder to go console. I'll start with what I know, and then touch on the problems with adopting to consoles.
You have a standard arcade TB, with the standard pinout. Red = 5 V+, black = ground, the others are X1 & X2, and Y1 & Y2. (see
ultimarc's optipac page for more info) To hook up to a PC: optipac, optiwiz, minipac, mouse hack, etc.
How to go to console depends on which console (unlike gamepads, mice were not common, so less "standardized" between consoles), if it supported mice or not, if so- how, or if not- what you want the TB to seem to be to the console.
The most simple, modern consoles that can take USB mice inputs. Just use a optipac/optiwiz USB encoder, and plug in. Next simple is console emu on a PC; ditto solution.
It gets more complicated after that. If the console supported mice but in some wierd way, you'll need to hack that some how. If the console didn't support mice, and only digital inputs, well that's an easier hack IMO than if the console supported analog. In general, mice are relative analog, joysticks are absolute analog. IIRC, you
might be able to hack a TB into the
super nintendo analog stick as it used an optical encoder.