The June '19 update for the SDL Integration for Drupal is now available from your given download location.
This version 3.0 contains a number of stability and fixes to the overall solution.
The SDL Connector Team
Where can I find some general information on how we (as an LSP using SDL Trados) could make use of this connector to serve our clients?
The Drupal Integration currently works with SDL Managed Translation / SDL TMS, and by the end of Q3, 2019 will also support SDL WorldServer. So either your customers, or you as an LSP, would require one of these TMS's to be able to connect to Drupal. SDL Trados woudl then retrieve the packages directly from the TMS.
Ok, thanks for clarifying.