Automate DB Source Field Sets
We're using Coveo to index an Oracle DB and Sitecore. When a new field is added to Oracle table/query then we need to manually update the FieldSets in the admin tool. Is there anyway we could automate this i.e. add new fields to the fieldSet as Coveo begins to index the db? Something like the way it behaves with Sitecore i.e. when a field is added to a template, the fieldset is updated as well.
I don't think this is possible with Coveo Enterprise Search.
It is possible with Coveo for Sitecore because Coveo for Sitecore is installed directly in Sitecore and is using the Sitecore APIs to read the fields and synchronize them with CES through the Coveo Admin Service.
I don't think you can integrate a module in an Oracle database to do a similar thing. If you can, you would need to do it by yourself using the Coveo Admin Service to manage your CES field set.