Any SCSI CD drive should work with the A2091. As you say yourself, get a ribbon cable, connect it to a 50 pin SCSI drive, plug in power cable and install software.
Most CD drives has a termination jumper, so set this one, and a unit number and you should be fine.