Skip to main content

Business Data Connectivity Service In SharePoint , Connect SharePoint with SQL, Excel or any third party system

Dear All,
Today i connect the 3rd Party database through SharePoint via Business Data Connectivity Services.

What are the problem i am facing? 
First i face a problem to get the "Access denied by business data Connectivity" which i mentioned the whole tread and solution here 

http://social.msdn.microsoft.com/Forums/office/en-US/11f090bc-7645-4b76-8464-9addc4386fc6/access-denied-by-business-data-connectivity?forum=sharepointdevelopment

Solution for the this problem is simple
Login with your SharePoint Central Administration > Application Management > Configure alternate access mappings (under Web Applications)

Make sure your alternative path is set for your "Central Administration Site Collection" the problem will be resolve out


Other thing Make sure running:
1) Service under the Start > Services > Claims to Windows Token Service
2) Make sure your SharePoint Web Services Root is enable under IIS>Application Pool

Once every thing is done then  you need to do the following steps:
http://www.c-sharpcorner.com/UploadFile/anavijai/create-external-content-type-using-sharepoint-designer-2013/

Once the above steps will done you can do the following steps to make any of SQL table in to sharepoint
http://www.c-sharpcorner.com/UploadFile/anavijai/create-external-list-in-sharepoint-2013/

It's so easy the first problem eat my 3 days and i hop my post and working save your time

Regards
Rashid Imran Bilgrami
CEO Best visualization
http://www.bestvisualization.com



Labels:

Comments

Post a Comment

Popular posts from this blog

[Solved] SharePoint 2013 And Adobe Reader Problem : The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable

Dear All  When trying to open a PDF file from a mapped drive in SharePoint 2010.  You might see the following error message. The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable. 1. Open the registry. 2. Go to HKLM Local Software\SOFTWARE\Policies\Adobe\\\FeatureLockDown. 3. Create a key called cSharePoint. 4. Create a DWORD value called bDisableSharePointFeatures. 5. Set its value to 1. Regards Rashid Imran Bilgrami CEO Best visualization http://www.bestvisualization.com  
Post a Comment
Read more

Content Query Webpart Template In SharePoint 2013 and add new column in it

Dear All, Here is the easiest way to make add custom column under your content query web part and then you can format it as you want. Step 1:  Open Sharepoint design Step 2:  Open site for sharepoint parent site collection Step 3:  Locate the following folder Style Library > XLS Style Sheets Step 4:  Open "ItemStyle.xsl"  file Add the custom style sheet as you want <xsl:template name="[Your Style Name]" match="Row[@Style='[Your Style Name]']" mode="itemstyle">                                                   <xsl:param name="CurPos" />                          ...
1 comment
Read more

SQL SPLIT FUNCTION or String_split sql function alternative Very Information (Solved)

Dear All,  Today i created a form with the checkbox list and store the value in the sql with comma seprated way. It was strange for me that the split_string function is not supported in sql 2014, so i have created split function that will help to split the comma sepearted values   CREATE FUNCTION dbo.Split(@String varchar(8000), @Delimiter char(1))      returns @temptable TABLE (items varchar(8000))      as      begin      declare @idx int      declare @slice varchar(8000)      select @idx = 1          if len(@String)<1 or @String is null  return      while @idx!= 0      begin          set @idx = charindex(@Delimiter,@String)          if @idx!=0              set @slice = left(@String,@idx - 1)          else  ...
Post a Comment
Read more