Transcript OSP320 Leave now and you don’t have to distract others later!

OSP320
Leave now and you don’t have to distract others later!
The paradox of agility vs. manageability
AGILITY
Access
Adaptability
Self-service
Innovation
How do we
break this
paradox?
MANAGEABILITY
Governance
Control
Centralization
Consolidation
Cost controls
Organizations have limited resources
The IT organization
typically runs at
full capacity
IT cannot do
every possible
project being requested
(Announcement of
the projects IT
can do)
Sorry, but I can
only help the Top
Ten projects!
What happens to Project Eleven and the rest?
I wonder what they are
going to do now
Ten business
sponsors are happy
It still gets done, but …
So the sponsors of
Project Eleven (and
Twelve and Thirteen)
get to work
and create a
solution themselves
… and start using it
But after a while,
the application
becomes important
and IT must
support it
The IT people are
really going to love my
app!
Corp IT resources are limited
Business Unit, Departmental and Team development
efforts are necessary
What is needed are mechanisms to control them
However, because the
application was not
supervised by IT,
it lacks in
security, usability,
data integration, compliance,
reporting,
scalability,
management, …
Could I have avoided
this
problem?
Director of
App Mgmt
Impacting innovation and satisfaction on the business side
The value traditionally
seen from infrastructure
Standardized activities
Utility
Non differentiating
What is required by the
business need
Innovation
Business value
Differentiation
The value gap
Balancing innovation and mission criticality
Types of business applications
Mission
Critical
Core
Context
Solution drives
differentiation
Solution implements
non differentiating activities
Custom Solution
is Deployed
at Scale
“Packaged” or
Out of the Box
standard solution
II
III
Innovation
Non
Mission
Critical
I
Solution is
Outsourced
IV
Access apps tend to start in quadrant [I] and move to quadrant [II]
Source: “Dealing with Darwin: how great companies innovate at every phase of their evolutions,” by Geoffrey Moore
“Give a man a fish; you have fed him for today. Teach a
man to fish; and you will not have to listen to his incessant
whining about how hungry he is.”
— Author unknown
Find
Prioritize
Evaluate
Control
SharePoint
Data in SharePoint lists
Centrally-deployed interface


Data in SharePoint lists
Centrally-deployed interface
Collaborative design
Web Forms in the browser
Web Reports in the browser
Server-side Macros
Option 1:
SharePoint
Option 2:
SharePoint +
Access Services








Access Services App
Client Objects
Web Objects
Client Objects
Web Objects
You can keep your organization agile and your data secure
AGILITY
MANAGEABILITY
Access
Adaptability
Self-service
Innovation
Governance
Control
Centralization
Consolidation
Cost controls
What questions do you need to ask yourself?
Q2: What Access applications
have “grown up” and require a
new strategy for data and
manageability?
Q1: What departments,
groups, and applications
require a solution such as
Access for rapid development
of departmental data apps?
http://tinyurl.com/ManageAccess
http://technet.microsoft.com/en-us/library/ff453909.aspx
http://blogs.technet.com/b/office_resource_kit/archive/2010/08/17/getting-started-with-ompm-2010.aspx
http://technet.microsoft.com/en-us/library/cc179179.aspx
http://www.microsoft.com/downloads/info.aspx?na=41&SrcFamilyId=51D4A154-8E23-47D2-A033764259CFB53B&SrcDisplayLang=en&u=http%3a%2f%2fdownload.microsoft.com%2fdownload%2f3%2fd%2f6%2f3d6d82ac-960b-4470bb08-343add7dd4eb%2fsqlxml.msi
http://social.msdn.microsoft.com/Forums/en-US/sqlsmoanddmo/thread/dc22ab47-182b-40e3-97c0-7b5a24db8589/
http://blogs.msdn.com/b/karthick/archive/2006/12/01/mcms-2002-how-to-install-sql-dmo-and-smo-without-installing-sql-server-2005.aspx
http://www.microsoft.com/downloads/en/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en#Top
http://blogs.technet.com/b/office_resource_kit/archive/2010/11/12/using-ompm-to-assess-macros-check-out-this-fix-to-repairlinks-in-the-macro-summary-tab.aspx
http://office.microsoft.com/en-us/access-help/web-compatibility-check-relationship-and-lookup-errorsHA010379061.aspx
http://office.microsoft.com/en-us/access-help/redir/HA010379057.aspx?CTT=5&origin=HA010379061
http://northamerica.msteched.com
www.microsoft.com/teched
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn