Geodatabase Administration: An Introduction
2013 Esri International User Conference July 8–12, 2013 | San Diego, California Technical Workshop
Geodatabase Administration: An Introduction Jonathan Murphy @JonathanMurphy_ Russell Brennan @RussellBrennan
Esri UC2013 . Technical Workshop .
Getting Started •
This is an intro session
•
Assuming some familiarity with Enterprise Geodatabases
•
Focused on new tools at 10.1 - Demo Heavy
•
Please hold questions till the end
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Roadmap
•
Intro to the ArcGIS System
•
Evolution of Geodatabase Administration
•
Administration using the ArcGIS 10.1 System
•
Administration Workflows
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
The ArcGIS System
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Geodatabases •
Enterprise Geodatabases -
•
Support major database platforms DB2, Informix, PostgreSQL, SQL Server, Oracle
File Geodatabases -
File based geodatabase
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Administration done in Desktop and Server •
ArcGIS For Desktop -
•
GUI Tools GP Tools
ArcGIS For Server -
GP Tools / Python
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Evolution of Geodatabase Administration •
1996 ArcSDE – Administration done through the SDE Command Line Tools
•
1999 ArcGIS 8.0 – Enterprise Geodatabase, Versioning
•
2004 Geoprocessing – Python scripting, Model Builder automation of administration
•
2005 Geodatabase Toolset (GDBT)
•
2012 Geodatabase Administration Dialog
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Administration at ArcGIS 10.1
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Administration at ArcGIS 10.1
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
What do administrators need to do? •
Create New Connections
•
Create New Geodatabases
•
Manage Permissions
•
Create Users and Roles
•
Work with Locks
•
Disconnect Users
•
Prevent New Connections
•
Automation
•
Upgrade Geodatabases
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Administration Workflow Demo – Creating New Geodatabases •
New enterprise geodatabase created directly through desktop
•
Script the creation of new geodatabases
•
Automate, execute across platforms
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Admin Workflows – Upgrade Geodatabases •
Upgrade Geodatabase GP tool
•
Two options: -
Upgrade directly through desktop Script upgrade using python - Supported on all platforms supported by ArcGIS for Server
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Admin Workflows – Creating Connections 10.0
10.1
Direct Connect is the default connection type
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Admin Workflow Demo – Managing Privileges •
Create new users and roles
•
All privileges all in one spot
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Admin Workflow Demo – Managing Locks •
All lock info, all in one spot
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Admin Workflows – Managing Connections •
View Connected Users -
•
Connection information such as connected machine name and time connection was established
Disconnect Users
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Administration Workflow Demo – Automating Administration Administrators GP Cheatsheet -
Create role/user
-
Create Enterprise Geodatabase
-
Enable Enterprise Geodatabase
-
Reconcile versions
-
Rebuild indexes
-
Analyze Datasets
-
Upgrade GDB
-
GP functions -
list versions
-
list replicas
-
disconnect user
-
list users
-
accept connections
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Summary Geodatabase Administration
•
Administration is done through Desktop and Server technologies in the ArcGIS system
•
Administration is easy, and scriptable at 10.1
•
Many GUIs are now part of ArcGIS 10.1 to provide a live operational picture of your system
•
Administrators can do their work where they fell most comfortable -
Desktop experience or scripting through python
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Questions Thanks for attending Please fill out session surveys Esri.com/ucsessionsurveys Tuesday: ID# 1209 Wednesday: ID# 1319
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Geodatabase Administration: An Introduction Jonathan Murphy @JonathanMurphy_ Russell Brennan @RussellBrennan
Esri UC2013 . Technical Workshop .
Getting Started •
This is an intro session
•
Assuming some familiarity with Enterprise Geodatabases
•
Focused on new tools at 10.1 - Demo Heavy
•
Please hold questions till the end
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Roadmap
•
Intro to the ArcGIS System
•
Evolution of Geodatabase Administration
•
Administration using the ArcGIS 10.1 System
•
Administration Workflows
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
The ArcGIS System
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Geodatabases •
Enterprise Geodatabases -
•
Support major database platforms DB2, Informix, PostgreSQL, SQL Server, Oracle
File Geodatabases -
File based geodatabase
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Administration done in Desktop and Server •
ArcGIS For Desktop -
•
GUI Tools GP Tools
ArcGIS For Server -
GP Tools / Python
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Evolution of Geodatabase Administration •
1996 ArcSDE – Administration done through the SDE Command Line Tools
•
1999 ArcGIS 8.0 – Enterprise Geodatabase, Versioning
•
2004 Geoprocessing – Python scripting, Model Builder automation of administration
•
2005 Geodatabase Toolset (GDBT)
•
2012 Geodatabase Administration Dialog
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Administration at ArcGIS 10.1
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Administration at ArcGIS 10.1
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
What do administrators need to do? •
Create New Connections
•
Create New Geodatabases
•
Manage Permissions
•
Create Users and Roles
•
Work with Locks
•
Disconnect Users
•
Prevent New Connections
•
Automation
•
Upgrade Geodatabases
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Administration Workflow Demo – Creating New Geodatabases •
New enterprise geodatabase created directly through desktop
•
Script the creation of new geodatabases
•
Automate, execute across platforms
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Admin Workflows – Upgrade Geodatabases •
Upgrade Geodatabase GP tool
•
Two options: -
Upgrade directly through desktop Script upgrade using python - Supported on all platforms supported by ArcGIS for Server
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Admin Workflows – Creating Connections 10.0
10.1
Direct Connect is the default connection type
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Admin Workflow Demo – Managing Privileges •
Create new users and roles
•
All privileges all in one spot
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Admin Workflow Demo – Managing Locks •
All lock info, all in one spot
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Admin Workflows – Managing Connections •
View Connected Users -
•
Connection information such as connected machine name and time connection was established
Disconnect Users
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Administration Workflow Demo – Automating Administration Administrators GP Cheatsheet -
Create role/user
-
Create Enterprise Geodatabase
-
Enable Enterprise Geodatabase
-
Reconcile versions
-
Rebuild indexes
-
Analyze Datasets
-
Upgrade GDB
-
GP functions -
list versions
-
list replicas
-
disconnect user
-
list users
-
accept connections
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Summary Geodatabase Administration
•
Administration is done through Desktop and Server technologies in the ArcGIS system
•
Administration is easy, and scriptable at 10.1
•
Many GUIs are now part of ArcGIS 10.1 to provide a live operational picture of your system
•
Administrators can do their work where they fell most comfortable -
Desktop experience or scripting through python
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
Questions Thanks for attending Please fill out session surveys Esri.com/ucsessionsurveys Tuesday: ID# 1209 Wednesday: ID# 1319
Esri UC2013 . Technical Workshop . Geodatabase Administration: An Introduction
