How To Integrate Microsoft Dynamics CRM 2015 as an External Content Type in SharePoint 2013.
This article will explains how to integrate Microsoft Dynamics CRM 2015 as an External Content Type in SharePoint 2013. Open your SharePoint site in SharePoint Designer. Click on External Data Type. You will get the following message if the Business Data Connectivity (BDC) Service is not started on the SharePoint Farm.
Create a BDC Service, start it and again open the site in SharePoint designer.
Click on External Content Type (ECT) and choose to create a new ECT.
Provide a Name, Display Name, select the Item Type as Generic List and click on External System.
You need to create a Data Connection. Click on Add Connection and choose SQL Server from the Data Source Type Selection drop down.
You will be asked the SQL Server name and authentication information.
Specify these and click OK. I am choosing Connect with User’s identity, but an ideal way is to create a Secure Store Application ID in SharePoint and use it for this connection. If all goes well, you should be able to connect to CRM Tables, Views and Routines.
The ideal way is to use Views for the read operation since we don’t want to directly use data from the tables. For this demo purpose I am choosing a view related to Contacts. Here is a reason why FilteredViews should be used.
Follow the procedure to create this operation. First provide a name.
Choose the Columns.
You can get an error as in the following if the threshold limit is exceeded.
So select only columns that are really required.
Click on Finish.
Similarly create a Read Item Operation.
Our ECT to CRM data is ready. Now we can test in designer if we can create a External List.
Click on “Create Lists and Forms” and enter the details.
Click OK. If all goes well, you will see the List created under Lists and Libraries.
You will see the same in your SharePoint Site -> Site Contents.
You can now use this CRM Account Data in SharePoint depending on your business needs.
I hope this article helpful for you.
Best Recommended SharePoint 2013 Hosting
ASPHostPortal.com is Perfect, suitable hosting plan for a starter in SharePoint. ASPHostPortal the leading provider of Windows hosting and affordable SharePoint Hosting. ASPHostPortal proudly working to help grow the backbone of the Internet, the millions of individuals, families, micro-businesses, small business, and fledgling online businesses. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability.
HostForLIFE.eu guarantees 99.9% uptime for their professional SharePoint hosting and actually implements the guarantee in practice. HostForLIFE.eu is the service are excellent and the features of the web hosting plan are even greater than many hosting. HostForLIFE.eu offer IT professionals more advanced features and the latest technology. Relibility, Stability and Performance of servers remain and TOP priority. Even basic service plans are equipped with standard service level agreements for 99.99% uptime. Advanced options raise the bar to 99.99%. HostForLIFE.eu revolutionized hosting with Plesk Control Panel, a Web-based interface that provides customers with 24×7 access to their server and site configuration tools.
DiscountService.com.au is The Best and Cheap SharePoint Hosting. DiscountService.com.au was established to cater to an under served market in the hosting industry web hosting for customers who want excellent service. DiscountService.com.au guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability. DiscountService.com.au has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch. DiscountService.com.au is devoted to offering the best Windows hosting solution for you.