Deploying and Maintaining a Multiuser Geodatabase

Strictly by pre-registration only

What is this course about?

Support your organization's data management workflows.

This course prepares you to successfully create a multiuser geodatabase that stores and manages your organization's authoritative geographic data. Learn about the multiuser geodatabase architecture and apply techniques to efficiently load data, assign user privileges, and maintain performance over time. 

During course exercises, you may work with the RDBMS product that is relevant for your organization (Oracle, Microsoft SQL Server, or PostgreSQL).

Course details






2 days




Geodata Course

CPD points


Esri will provide the following software to use during class:

  • ArcGIS Pro (Standard or Advanced)
  • Oracle Database Express Edition
  • PostgreSQL
  • Microsoft SQL Server

Are there any prerequisites?

What skills will I learn?

  • Create a multiuser geodatabase.
  • Load and update data in a multiuser geodatabase.
  • Configure user roles and permissions to provide secure data access.
  • Apply best practices to optimize geodatabase performance.

What can I expect?

  • 1. What is a multiuser geodatabase?
    • Multitier architecture
    • Identifying the appropriate software tier
    • Multiuser geodatabase components
    • Hierarchy of users
    • Comparing tools for making a multiuser geodatabase
    • Create an enterprise geodatabase
    • Explore the repository
    • Exercise 1: Create a multiuser geodatabase in SQL Server/Oracle/PostgreSQL
  • 2. Connecting to the geodatabase
    • RDBMS client software
    • Create a connection
    • Software version compatibility
    • Authentication methods
    • Connection files
    • Exercise 2: Configure connections to a multiuser geodatabase
  • 3. Loading data into the geodatabase
    • Data owner account
    • Create the data owner account
    • RDBMS considerations
    • Geoprocessing environment settings
    • Choosing a data-loading tool
    • Updating datasets
    • Automation
    • Use ModelBuilder
    • Exercise 3: Load data into the geodatabase
  • 4. Configuring privileges
    • Data users
    • Creating data users
    • Roles
    • Manage users
    • Defining roles
    • Designing roles
    • Securing credentials
    • Exercise 4: Configure privileges for data use
  • 5. Managing storage
    • Configuration parameters
    • Configuration keywords
    • Supported spatial types
    • DBTUNE table
    • Create and update keywords
    • Exercise 5: Customize storage using configuration keywords
  • 6. Maintaining the geodatabase
    • Attribute indexes
    • Statistics
    • Manage attribute indexes and statistics
    • Spatial indexes
    • Maintaining geodatabase performance for versioned data
    • Scheduling tasks
    • Manage performance tasks with Python
    • Schema locks
    • View and clear locks
    • Exercise 6: Maintain performance in your geodatabase
  • 7. Associating data
    • Query layers
    • Create query layers
    • Database views
    • Create database views
    • Choosing between query layers and database views
    • Determining whether to create query layers or database views
    • Exercise 7: Associate data with database views and query layers
  • 8. Applying the geodatabase workflow
    • Geodatabase workflow
    • Geodatabase responsibilities
    • Geodatabase tasks
    • Exercise 8: Configure and manage a multiuser geodatabase