Read:

· Enjoyed – SharePoint 2013 Building Business Solutions.

Half way through a small prototype:

Proving out a concept that a declarative solution is possible using Access Services Web App to populate Word Templates that are content types within a SharePoint site collection.

Components:

1. Access Services Web App

2. Business Connectivity Services

3. SharePoint Business Data Web Parts

Access Services Web App on Office 365 (E3 – Subscription) –

Deployed a small Contacts Access Web database to Office 365. Applied the same SharePoint Theme as the SharePoint Site Collection (Orbit with Oslo layout).

clip_image002

Business Connectivity Services –

When you create the Access web app database, OneNote the connection information since you will need it to create the “SQL connection” in SharePoint Designer 2013. Don’t worry about “Name (optional)”, and when you fill out the rest of the screen and select the ok button use the UID and PWD used by Access to connect to SQL Server.

clip_image004

clip_image006

SharePoint Business Data Web Part –

This screen print only is showing a test to confirm that I have BCS and Office 365 Access Services Web app talking to each other. Next part of the plan is to create a Microsoft Word template that will use the BCS data to populate the Invoice fields.

clip_image008

#Sobotown

Advertisements