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.
Hi Vinod
I did the following:
I built my custom BDC solution (with all read item/list, create operations) and then added them to the external list.
However, I could not set up my custom workflows on this external list. Is there a way to it?
Thanks Eric. However, I would not be let to use a 3rd party component on my prod. 🙁
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.
Alright… I had walked down the WCF + BCS route before I posted in here.
I shall try the custom Visual studio BCS solution and post the outcome/findings.
