Lois Wang amp Gary Devendorf Microsoft Access Engineering Team SPC043 What you will learn in this session Access Services what you need to know Office 365 is awesome You can setup Access services for ID: 573160
Download Presentation The PPT/PDF document "Configuring and Managing Access Services..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1Slide2
Configuring and Managing Access Services in SharePoint 2013
Lois Wang & Gary DevendorfMicrosoft Access Engineering Team
SPC043Slide3
What you will learn in this session
Access Services – what you need to know
Office 365 is awesome
You can setup Access services for
SharePoint on-premises
How do you keep everything under controlSlide4
Agenda
What are the problems we are solving
?
Why Access Services?
Architecture Overview
Planning on-premises
deployment
On Premises deployment
Conclusions Slide5
What are the problems we are solving?
Unknown/uncontrolled data applications
Bad/broken end-user applications
Inefficient business processes
Backlog of IT requests
No data access control/backup
Difficult application sharing
Lack of upgrade path Slide6
Where is Your Data?
On paperMS Word documents
MS Excel spreadsheets
RDMS systems
Mainframes
Cloud
All of the above
Laptops
Thumb drives
Servers
WhiteboardsSlide7
Why Access?Slide8
Access: Virtues of Simple + Structured
Structured
Access
Simple
Data Containers
Low up-front investment
Easy to evolve and iterate
Easy adoption
One version of the truth
Easy to collaborate
Powerful analysis
Keeps data clean
Multiple versions of the truth
Hard to collaborate
Difficult to analyze
Keeping data clean is a chore
High up-front investment
Hard to evolve and iterate
Hard to adopt
Virtues
VicesSlide9
Access Desktop vs. Access Services
Classic Access desktop applications
Must be deployed to a client machine
20
years
old / very popular
Access Services
Upgraded for 2013
SharePoint applications
Slide10
Demo
Desktop Database - NorthWindSlide11
New
App Experience Simplified
design experience
Polished, consistent results
2. SharePoint deployment
3.
SQL
back-end
Access 2013
Web AppsSlide12
Polished, Professional User Interface
4. Add and edit items
3. Search and filter
2. Choose view
1. Choose tableSlide13
Demo
Example Access Services appSlide14
Simplified design experience
Pre-defined schema templates (nouns)Automatic generation of navigation, forms and buttons
Simplified, code-free configuration and customization
Polished, professional results
Apps automatically have an attractive, easy-to-use interface
Consistent user experience across all apps
1. New app modelSlide15
Access web Apps
= SharePoint Apps
SharePoint Store and App Catalogue for distribution and discovery
Multi-user accessibility:
m
any people can work on the same site/database at once
Active Directory-based permissions
Simple install/uninstall
On Premises option
2. SharePoint DeploymentSlide16
The gold-standard for relational databases
Transparent to end userUse common tools for advanced reports and custom integrations
Developers can use
e
xisting skills to customize
Future upgrade
path
3. SQL back-end
View and Edit Data
Database Design
Access Services
Advanced Reporting & Integration
Desktop Access Reports
Excel
Power View
Crystal Reports
Custom Websites (.NET, PHP, etc.)
SQL AzureSlide17
Demo
Example building an appSlide18
Advantages of Access Services
Centralize data/administration/security
End-user created
Professional interface
Usage monitoring
App Store
Upgrade
pathSlide19
Architecture Overview Slide20
Access Services on Office 365
Browser
O365
Browser
Browser
SQL Azure
Web app 1
Web app 2
Web app 3
…
Access IDE
runtime
designSlide21
Access Services on-premises?
Browser
SharePoint
on-premises
Browser
Browser
SQL
Server
Web app 1
Web app 2
Web app 3
…
Access IDE
runtime
designSlide22
Office 365 is Awesome
Everything you need for Access Services is in 365!
SQL (Azure)
Security
Identity
Access control Redundancy/Backup
Slide23
Not Everyone Can Use Office 365
Legal reasons
Governance
Customer requirements
Network issues
Cost
Other…?Slide24
Access Services for On-premises Environments
You can set up Access Services for on-premises
Beyond a SharePoint environment you need additional software/hardwareSlide25
Planning on-premises deployment
Manageability
Security
CostSlide26
Software Requirement
SQL Server
2008
R2
SP1
or
2012
SQL Server
2012
SharePoint
2013Slide27
Access Data
Services
SharePoint
Access App 3
Access App 2
Access App
1
SQL server hosting Access
apps
NT
Auth
SQL
Auth
2
Security Model
Access App 4
Access IDE
SQL
Auth
1
SQL
Auth
3
SQL
Auth
4Slide28
Access Data
Services
Access
Client
Web Browser
Role-based
SQL
Auth
Read
Contribute
Full Control
SharePoint SQL
Access App 3
Access App 2
Access App
1
Security ModelSlide29
Access Data Services
Access
Client
Web Browser
SharePoint SQL
Access App 3
Access App 2
Access App
1
Access App 5
Access App 4
Access App
8
Access App
7
Access App
6
Access App
10
Access App
9
ManageabilitySlide30
On Premises:
What Needs to be Done?
Enable Access Services on SharePoint
Install Access pre-
req
MSIs
Install & Configure SQL
Server 2012Slide31
Enable Access Services on SharePoint
Install Access pre-
req
MSIs
Install & Configure SQL
Server 2012Slide32
Security Mode = Mixed Mode (SQL Server authentication and Windows authentication)
Install & Configure SQL Server 2012 (1)Slide33
Configure SQL Server 2012 (
2)
Turn on Full-text searchSlide34
Enable
Contained Databases property
Install
& Configure
SQL Server
2012 (
3)Slide35
Allow
Triggers to Fire Others property
Install
& Configure
SQL Server
2012 (
4)Slide36
Enable Access Services on SharePoint
Install & Configure SQL
Server 2012
Install Access pre-
req
MSIsSlide37
Install Access pre-req
components (cont.)
Microsoft SQL Server 2012 Transact-SQL
ScriptDom
(sqldom.msi)
Microsoft System CLR Types for Microsoft SQL Server 2012 (SQLSysClrTypes.msi)
Microsoft SQL Server 2012 Data-Tier Application Framework (DACFramework.msi)
Microsoft
SQL Server 2012 Local DB (SQLLocalDB.msi)
Microsoft SQL Server 2012 Native Client (sqlncli.msi)Slide38
IIS Application Pool Load User
ProfileSlide39
Install Access pre-
req
MSIs
Install & Configure SQL
Server 2012
Enable Access Services on SharePointSlide40
Enable Access Services on SharePoint Slide41
The whitepaper
http://www.microsoft.com/en-us/download/details.aspx?id=30445
Slide42
What You Get With Access Services
Self-service
for
IWs
Manageability
for youSlide43
Intuitive design experienceSlide44
Easy to Manage
SharePoint app
Inherits Site’s management
SQL data store
Invisible from creators and usersSlide45
Migration
Earlier version of Access
Just the data or the whole applications
Excel spreadsheets
Other sources
Like Lotus NotesSlide46
Access client vs. collaboration via the web
Desktop ClientRich functionality
VBA
Ecosystem
Supported 2013
Web
Easy sharing
No code
Latest technology
New functionalitySlide47
Conclusions
Most environments have some out of control data
Access Services provides a simple robust container
Secure, professional UI, no code, SharePoint apps, managed, end-user empowered, and more
G
et control of data at the edge with Access Services
Office 365 already has Access Services
on-premises environments can setup Access Services
Safely empower end-user to reduce IT workload
…Slide48
Try Out Access 2013 Web Databases
Office.com/Preview
Office 365 Preview
Plan
Access 2013 Client
Access 2013 Database Hosting
Home Premium
Yes
No
ProPlus
Yes
No
Small Business Premium
Yes
Yes
Home Premium
Yes
YesSlide49
Access Engineering Team’s Sessions
SPC026
Apps for SharePoint in 60s with Access 2013
Tuesday 10:30am
South Seas Ballroom E
SPC043
Configuring and Managing Access Services in SharePoint 2013
Wednesday 10:30am
Mandalay Bay Ballroom G
SPC193
Access Databases: Taming the Beast
Wednesday 1:45pm
Lagoon CDIJ
SPC071
Building Apps for SharePoint with Access 2013: A deeper dive
Wednesday 1:45pm
South Seas Ballroom E
SPC099
Moving Legacy Data/Systems to SharePoint/SQL Azure with Access 2013 (Lotus Notes/MDB/Excel etc…)
Thursday 10:30am
Banyan ABCD
HOL045
Creating a SharePoint App with Access Services: Hands on Lab
All times
??Slide50
Related Sessions
SPC010
An overview of developing SharePoint-hosted apps
Tuesday 1:45pm
South Seas CDFJI
SPC133
Introduction to the Cloud App Model for Office and SharePoint – Part 1
Monday 2:00pm
South Seas
SPC 134
Introduction to the Cloud App Model for Office and SharePoint – Part 2
Monday 3:45pm
South Seas
SPC029
Building auto-hosted apps for SharePoint
Tuesday 1:45pm
Banyan ABCD
SPC240
Understanding and Maintaining SharePoint Apps for IT Professionals
Tuesday 5:00pm
Mandalay Bay Ballrom H
SPC260
What's New in Spreadsheet Management for Office and SharePoint
Wednesday 10:30am
Islander IED
SPC106
Getting Your Apps into the Office and SharePoint Store
Thursday 12:00pm
South Seas ESlide51
Resources
http://blogs.office.com
http://blogs.office.com/b/microsoft-access
/
http://
www.microsoft.com/office/preview
http://
msdn.microsoft.com/access
http://
msdn.microsoft.com/SharePointSlide52
Evaluate this session now on
MySPC
using your laptop or mobile device:
http://myspc.sharepointconference.com
MySPCSlide53
QuestionsSlide54
© 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.