We built a clip-zip-ship solution for internal corporate use by SM Energy personnel to provide easy universal self-service access to their extensive yet disparate geodata.  The FME Server back-end processor accepts any combination of state and county parameters and/or an arbitrary geometry from a Geocortex front-end to specify the area of interest.  Results are generated in the background and returned via email.  The source data is stored in a Microsoft SQL Server database with the ESRI ArcSDE spatial extension.