Is it even possible to use the Sharepoint user interface (for example, the list editor) to perform basic CRUD operations on an external database (owned and used by a separate backend application)?
How can i do this?
There are quite a few tables in this db, and I just want to minimize the custom code that we need to develop and maintain (since we are not a development store and we have no spare programmers ...).
(Preferably on WSS, not MOSS ... but I want to listen)
I must add that this application is used internally, and these tables can be considered as a complex configuration for backend processes - which must change frequently, and also include data for the "feed" of the processes.
Also, I have no interest in coding custom WebPart for this, I could also make a simple CRUD web application ... I am looking to use the built-in functions and enough with customization.
source
share