Is a connection to the Sage database required?

Yes, as not all required data is currently available via the API and access is always read-only.
All write actions are performed exclusively via the API.