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
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
Comments
Post a Comment