Issue
I am new to Appsmith and wondering if it's possible to connect it with Intersystems Cache database since I currently use JDBC with other tools. Although there is no native integration, it might be possible to connect to it through Appsmith's REST API datasource since Intersystems Cache provides API endpoints.
Resolution
Use HTTP, not JDBC. Publish the data you need from InterSystems Caché as REST endpoints, then consume them from Appsmith with either the REST API datasource (for one-off calls) or an Authenticated API datasource (to reuse base URL and auth across multiple queries). If your endpoints return paged results, wire them to a Table using Appsmith’s server-side pagination guide.
On the Caché side, create your REST service with %CSP.REST and register it under a CSP Web Application as documented here: Creating REST Services in Caché. If your architecture requires browser calls, review Supporting CORS in REST Services; Appsmith’s server-side requests typically don’t need CORS, but it’s useful when exposing endpoints more broadly. (InterSystems Documentation)