Geodatabase Administration: An Introduction

1. 2013 Esri International User Conference July 8–12, 2013 | San Diego, California Technical Workshop Geodatabase Administration: An Introduction Jonathan Murphy @JonathanMurphy_ Russell Brennan @RussellBrennan

2. 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 Geodatabase Administration: An Introduction

3. Roadmap • Intro to the ArcGIS System • Evolution of Geodatabase Administration • Administration using the ArcGIS 10.1 System • Administration Workflows Geodatabase Administration: An Introduction

4. The ArcGIS System Geodatabase Administration: An Introduction

5. Geodatabases • Enterprise Geodatabases • Support major database platforms DB2, Informix, PostgreSQL, SQL Server, Oracle • File Geodatabases • File based geodatabase Geodatabase Administration: An Introduction

6. Administration done in Desktop and Server • ArcGIS For Desktop • GUI Tools • GP Tools • ArcGIS For Server • GP Tools / Python Geodatabase Administration: An Introduction

7. 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 Geodatabase Administration: An Introduction

8. Administration at ArcGIS 10.1 Geodatabase Administration: An Introduction

9. Administration at ArcGIS 10.1 Geodatabase Administration: An Introduction

10. 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 Geodatabase Administration: An Introduction

11. Administration Workflow Demo – Creating New Geodatabases • New enterprise geodatabase created directly through desktop • Script the creation of new geodatabases • Automate, execute across platforms Geodatabase Administration: An Introduction

12. 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 Geodatabase Administration: An Introduction

13. Admin Workflows – Creating Connections 10.0 10.1 Direct Connect is the default connection type Geodatabase Administration: An Introduction

14. Admin Workflow Demo – Managing Privileges • Create new users and roles • All privileges all in one spot Geodatabase Administration: An Introduction

15. Admin Workflow Demo – Managing Locks • All lock info, all in one spot Geodatabase Administration: An Introduction

16. Admin Workflows – Managing Connections • View Connected Users • Connection information such as connected machine name and time connection was established • Disconnect Users Geodatabase Administration: An Introduction

17. 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 Geodatabase Administration: An Introduction

18. 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 Geodatabase Administration: An Introduction

19. Questions Thanks for attending Please fill out session surveys Esri.com/ucsessionsurveys Tuesday: ID# 1209 Wednesday: ID# 1319 Geodatabase Administration: An Introduction