Does the API for Odoo work only for the online database or also for on-premise?
The Odoo connector works for all environments that provide access to the Odoo APIs. This can also be with an on-premises version with, for example, Invantive UniversalSQL Server on-site or Invantive Query Tool.
The previous response seems to pertain to something different than the original subject.
The advice is to start a separate topic for this and at least add the details from the Monitoring of the respective request here.