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

Updatepanel or Enable Ajax in SharePoint webpart

Dear All It is really giving me a hard to get this techniques if you want to run the update panel in sharepoint 2013 webpart then you need to initialize the script manage by code   protected override void OnInit(EventArgs e)         {             base.OnInit(e);             InitializeControl();             // Register the ScriptManager             ScriptManager scriptManager = ScriptManager.GetCurrent(this.Page);             if (scriptManager == null)             {                 scriptManager = new ScriptManager();                 scriptManager.ID = "ScriptManager1";                 scriptManager.EnablePartialRendering = true;       ...
23 comments
Read more

[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

Wss_logging size is to big or sharepoint disk out of memory

Dear All if you are facing and issue for out of memory in sharepoint because of wss_logging database here is a script Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue Set-SPUsageDefinition -Identity "Sandboxed Requests" -DaysRetained 3 Set-SPUsageDefinition -Identity "Content Import Usage" -DaysRetained 3 Set-SPUsageDefinition -Identity "Workflow" -DaysRetained 3 Set-SPUsageDefinition -Identity "Clickthrough Usage" -DaysRetained 3 Set-SPUsageDefinition -Identity "Content Export Usage" -DaysRetained 3 Set-SPUsageDefinition -Identity "Page Requests" -DaysRetained 3 Set-SPUsageDefinition -Identity "Feature Use" -DaysRetained 3 Set-SPUsageDefinition -Identity "Search Query Usage" -DaysRetained 3 Set-SPUsageDefinition -Identity "Site Inventory Usage" -DaysRetained 3 Set-SPUsageDefinition -Identity "Sandboxed Requests Monitored Data" -DaysRetained 3 Set-SPUsageDefinit...
Post a Comment
Read more