None of Sonnet's Cards with USB 2.0 or USB 3 (either Type A or Type C) ports support the Apple SuperDrive. You must use a built-in USB 2.0 or 3.0 port on your Mac.
According to http://support.apple.com/kb/HT5630, "The Apple USB SuperDrive is compatible with Mac models from 2008 and later that don't have a built-in optical drive."