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)?
Another option would be to use a 3rd party product like BCS Meta Man. This will help generate a model you can import in to SharePoint.