First off, what SCSI card do you have? Is it an A2091 from Commodore, or a GVP or another brand? Each card came with its own specific software, which handled CDs with varying levels of efficiency.
The best solution, IMHO, is Asimware's AsimCDFS. It works with any Workbench of 2.x or greater, is easy to install and painless to use. Once it's installed, discs just show up as icons on your Workbench as they should. I might still have a copy around, I could look. Meanwhile, you could scrounge eBay for one. Also, there are several CD filesystems on Aminet which could be made to work, your mileage may vary here. How can this machine get online? Does it have an ethernet board? Online makes it easier nowadays. As opposed to back then, when I had buddies with whatever I needed, just had to sneakernet it over on floppy :-)