Integrating Oracle into SharePoint 2010 Using Business Data Connectivity Model

Nice one sir

very nice job, i followed the tuto step by step, and it is simple and clean, but when i tried, i get the same error mentioned in "Zsombor Varsanyi" 's comment, plz i'll be thankful if you tell me how to resolve this error

Thanks, very helpful. However, after doing all parts of this guide, i'm getting the following error: MethodInstance with Name 'ReadList' on Entity (External Content Type) with Name 'Employee' in Namespace 'BdcModelUsingOracle.BdcModel1' failed unexpectedly. The failure occurred in method 'ReadList' defined in class 'BdcModelUsingOracle.BdcModel1.EmployeeService' with the message 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.'. Can cause this error the fact that the oracle server is on a remote server? Thanks in advance,

Great article. I am following the exact steps. I solution deploys succesfully but when i add external list there is no data comming form oracle. I displays as empty list. There is no error message anywhere. PS: i am using BDC Model from Visual Studio(no Meta man) Any idea what could be the issue. Thanks, Veena

do u have sample code for delete and update functions.

Hi, I followed your instructions and when the call to the GetContact method is made, I get the following message: Microsoft.BusinessData.Infrastructure.BdcException: The shim execution failed unexpectedly - Assembly was requested for LobSystem with Name 'OracleBDCModel', but this assembly was not returned I can see my OracleBDCModel in Central Admin's BDC Models. Any idea? Thanks! Lyne

Brilliant article, thanks, but I am having difficulty in getting it to work properly. I get a warning on compilation: Assembly generation -- Referenced assembly 'System.Data.OracleClient.dll' targets a different processor Assembly generation -- Referenced assembly 'System.Data.dll' targets a different processor This produces the following exception message when trying to look at my External list: 'Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed' I've tried targeting x64 specifically, this doesn't work. Any help would be great!! Thanks, Andy

Thanks that article's great though I had problems deploying it but managed to resolve that with help from the following article http://weblogs.asp.net/jan/archive/2010/05/07/sharepoint-2010-bdc-model-deployment-issue-the-default-web-application-could-not-be-determined.aspx The only issue I have now is that the credentials are hard coded, is it possible to retrieve credentials from the Secure Store Service, I'm going to be setting up a lot of these lists and if the password needs changing it will be a real mission to go through all the solutions that I've built canging the code and redeploying. Thanks, Rob

Other SharePoint-Oracle BCS integration solutions have required Metaman and the Oracle 10g client/drivers on the SharePoint server. They weren't mentioned in your article, so is it true that, esp. for the 10g client, that they are not needed? Regards, Phil