Hi all
I’m trying to perform CRUD operations on the Oracle database ( I’m using a web service) and hence am looking at BDC.
I already have few lists (not external lists!) available on my SharePoint site and workflows are linked to them. As far as I have read, I find BDC links to external lists on which workflows do not work.
All I need to do, is to perform CRUD operations (based on the workflow statuses) on Oracle tables. Will BDC help me? Is there any other way out, other than using a DAL ( I tried the DAL, there is an unacceptable amount of delay in communication between Oracle and SharePoint)?
The nice thing about this product is that it doesn’t require any components to be installed on the server. It integrates with VS and generates an BCS model (xml file) that you import in to CA.