Ability to connect directly to the underlying Microsoft SQL Server
(for business intelligence tools for example)
I absolutely recommend this. If enabled to clients, then robust writing applications become available. Caspio's report writing lags its overall middleware offering. The lack of report features, and the challenge with integrating existing third party report software, is making a subscription to Caspio more problematic.