Operating System Requirements: Windows 7 (32-bit), Windows 7 (64-bit) Windows 7 Driver for Sonnet USB 3.0 cards and Echo 15+ Dock's USB 3.0 ports that use the Fresco Logic FL1100.
Yes, the DVD must be connected to the connector that is the USB 3-to-SATA bridge for full compatibility with macOS. It's the SATA connector closest to the front, which is the connector closest to the 4-pin molex power connector.