Building Workflows for No-Code Solutions Using External Data with the BCS in SharePoint 2013

In the eleventh and twelfth units of a set of fifteen units of video training content on building workflows for external data, in either SharePoint 2013, on premises, or SharePoint Online, Office 365, Fabian Williams, a SharePoint Server MVP, presents a set of procedures, and their underlying components, most likely to be useful for an audience of SharePoint, or Office 365 application developers. These video tutorials will not likely be useful to SharePoint power users. An experience set which includes extensive work with JavaScript, modern Open Protocols (including OAuth and OData), and Visual Studio is required to digest the information…
Read more →

Working with the OData Protocol, Web Parameters and URIs to Expose External Data in SharePoint

Expressions of the OData protocol are usually incorporated within Uniform Resource Identifiers (URIs). These expressions add parameters to Internet locations, at the application layer (hypertext). Once the syntax of a URI has been successfully completed, a web browser can be used as a “universal client” to parse data repositories for targeted segments of data, which users can consume as web pages. In two video tutorials included in a new set of video training content led by Fabian Williams, SharePoint Server MVP, we demonstrate not only the importance of a thorough grounding in web application development to a successful effort to…
Read more →

Using the BCS to Pull External Data into SharePoint 2013 with Visual Studio

Microsoft is attempting to rebrand its code editor, Visual Studio, as a preferred method for developers to product Apps conforming to the Office 2013 App model. In a set of three video tutorials, Fabian Williams, a SharePoint MVP and widely acknowledged subject matter expert, demonstrates how the BCS can be used, via Visual Studio, to pull external data into SharePoint 2013. All three of these video tutorials are included in a new set of training content titled SharePoint 2013: Working with external data in SharePoint 2013 using BCS and Workflows. This set is available, exclusively, on SharePoint-Videos.com. In the first…
Read more →

A Hands On Example Using SharePoint Designer, SQL Server and the Secure Store for SharePoint 2013 to Work with External Data

In a video tutorial titled Using SQL Server to interact with BCS External Data, Fabian Williams, a SharePoint Server MVP demonstrates each of the steps required to create an external content type in SharePoint 2013. The steps are taken with SharePoint Designer 2013, SQL Server, and the Secure Store. This video tutorial is included in a set of video training content titled Working with External Data in SharePoint 2013 using BCS and Workflows. The set is available for purchase for local, on premises unlimited viewing by organizations of any size. The set is also included as a course for SharePoint…
Read more →

SharePoint-Videos Publishes a Set of Video Tutorials on External Data, BCS and Workflows for SharePoint 2013

Organizations in need of proven methods to surface external data in SharePoint 2013, and to work with it via no-code process development approaches, should consider a new set of video tutorials on BCS, External Data, and Workflows, led by Fabian Williams, SharePoint Server MVP. The set has just been published by SharePoint-Videos. A review of the syllabus for this training set demonstrates the importance of Business Connectivity Services, BCS, to the successful application of the methods included in the set. BCS is not a new feature to SharePoint 2013. In fact, BCS has been a component of SharePoint since SharePoint…
Read more →

Microsoft Partners Working On a Collaboration and Content Competency May Want to Study Business Connectivity Services (BCS)

In a post to the U.S. Partner Team Blog on Technet, titled ‘Build your SharePoint business with the Collaboration and Content competency’, Diane Golshan of Microsoft writes: ‘implementing business-critical solutions with line-of-business (LOB) data coming from disparate systems surfaced in SharePoint’ is an example of one of the ‘tremendous opportunities’ in front of U.S. partners who successfully achieve Silver,or Gold certification for this new partner specialty. Of course the technology required to “[surface LOB data] in SharePoint” would not be possible without the Business Connectivity Service (BCS). BCS has been a component of SharePoint server since the 2010 edition, and…
Read more →

OData Support is an Improved Feature for SharePoint 2013 for Business Connectivity Services (BCS)

With the new Business Connectivity Services (BCS) component behind Office, and SharePoint 2013, better support is available for services running the Open Data (OData) web Protocol. This new BCS component complements the Office, and SharePoint 2013 App Model, both of which, in turn, are very deeply based on web development tools — HTML and JavaScript. The impact of better support for OData in SharePoint 2013 as the result of a new, and improved BCS feature is substantial. Organizations with a major commitment to Oracle®, SAP, or IBM® databases have a much better chance of successfully pulling this external data into…
Read more →

Business Connectivity Services for SharePoint 2013

Any organization looking to implement SharePoint 2013 as an enterprise application for document or content management, or for reporting purposes, or even for gathering useful business intelligence, will need to use solutions and features built on the Business Data Collector (BDC) and Business Connectivity Services (BCS). Despite two new SharePoint Server versions, 2010 and, now, 2013, BDC is still running, and provides the foundation for BCS. What’s important for SharePoint administrators, developers, systems designers and architects, is to understand the role BDC/BCS plays in the 2013 Server architecture for any of the “enterprise edition” features, including Excel Services, Reporting Services…
Read more →

Central Administration Settings for Creating and Configuring Reporting Services as a SharePoint Server 2013 Service

The task of adding the SQL Server 2012 SP1 Reporting Services for SharePoint service is best performed by SharePoint administrators. Jason Himmelstein’s presentation in the first part of his series on Reporting Services, REPORTING SERVICES IN SHAREPOINT 2013 PART 1 is tailored for an audience of administrators. As we noted in the previous post to this blog, in this video he demonstrates how to use Power Shell to add this service. In the final few moments of the video he demonstrates how to use Central Administration to configure this service, though he still recommends Power Shell as the best method…
Read more →

1 2 3