Your system will see it as a factory-installed SuperDrive. You'll need to use the PatchBurn application for your system, since you're still on 10.2.8, but if you upgrade to Panther, then it will be fully supported without the need for a hack.
I have a DVR-108 installed on my G4 Sawtooth. It is not recognized by the Finder quite correctly (i.e. it will not mount on the desktop when new media is installed, but it will if already burned discs are in it) , but is by Toast 6.0.7 and the iApps using PatchBurn 11. The System Profiler does show it as well.
Why it will not show up in Finder is beyond me though, and a little fustrating.
Because the DVR-108 is not natively supported by OS X yet. It's not a drive shipping with any new Macintosh -- the DVR-107 is, though, and that's why it has native support.
When Apple starts shipping machines with the DVR-108, then it will be natively supported.