Showing posts with label BCS. Show all posts
Showing posts with label BCS. Show all posts

Sunday, September 05, 2010

SharePoint 2010 : First custom connector implementation for BCS

Today, I managed to read on BCS a bit and wanted to try out some custom connector implementation for the external systems.
Found out this code snippet from MSDN for a connector to the file system.
Managed to complete this exercise and created an external list with the External Content Type and I did see the files from the file system in the list.See bellow images.
Folder contents in file system :
source-files
External list in SP context :
list-ect
I am really impressed by this and it has already inspired me to go deep into this and hoping to create some more custom connectors for other external systems as well.
Found out lot of issues/problems while I am doing this and I just list down possible erroneous  scenarios.
  1. Business Data Connectivity Services issues
  2. Assembly deployment to the GAC
  3. Assembly information
  4. Configure Business Data Connectivity access rights
Keep those things in mind if you also get into trouble.  

Error accessing Business Data Connectivity Services in Windows 7

While I was doing some research on BCS , wanted to import a BDC model from Central Administration > Manage service applications > Business Data Connectivity Services.

As I hit the link,  following error message prompted.

 

bdc-service-error

As usual did a search on the Google and found out the following entries.

http://sensoft2000-sharepoint.blogspot.com/2010/08/error-access-services-is-unable-to.html

https://connect.microsoft.com/VisualStudio/Downloads/DownloadDetails.aspx?DownloadID=23806

Downloaded the above fix and installed.

problem solved. :)

bcs-service

More references on the issue :

http://blogs.technet.com/b/dahnesh/archive/2010/06/16/error-while-accessing-business-data-connectivity-services-on-windows-7.aspx

http://support.microsoft.com/kb/976462

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=976462&kbln=en-us