When I was using SCSI on my A1000 To get the CD-ROM working I needed ASIM CD-FS, which at the time was the Commodore Recommended Software. Unfortunately the product is no longer available.
I think Allegro CDFS was another product but needed the Fast IDE Interface to function.
I'll do a little more research and try to clarify a configuration.