Configuring and Managing the Multiuser Geodatabase

Configuring and Managing the Multiuser Geodatabase

Configuring and Managing the Multiuser Geodatabase

Configuring and Managing the Multiuser Geodatabase

Product: ArcGIS
ArcGIS 10.7
ArcGIS for Desktop
Training type: Scheduled training
Software version:
V10.7
Duration: 2 Days
Price range: $ 1050

Quick Enquiry

This course prepares you to successfully deploy a multiuser geodatabase to manage your organization's critical geographic data assets. You will learn about the multiuser geodatabase architecture and installation options, and how to configure the geodatabase for efficient data storage and delivery of data access and editing capabilities to many users. Although course exercises use the enterprise geodatabase, many course concepts also apply to workgroup geodatabases.

Audience

Spatial database administrators and GIS data managers who need to create, configure, and manage a multiuser ArcSDE geodatabase.

Pre-requisites

Completion of ArcGIS 2: Essential Workflows or equivalent knowledge is required.
Experience managing a relational database management system is required.

Install ArcSDE technology and configure it for your relational database management system.
Create and connect to a multiuser geodatabase.
Efficiently load and update data in a multiuser geodatabase.
Configure storage settings to support your organization's data management workflows.
Set up user roles and permissions to provide secure data access.
Apply best practices to optimize geodatabase performance.

Download table of contents

Introduction to the geodatabase

Types of geodatabases
Licensing
Geodatabase workflow

What is ArcSDE?

ArcSDE components and architecture
Geodatabase management options
Creating an enterprise geodatabase using a geoprocessing tool

Connecting to the geodatabase

Types of connections
Client-server compatibility

Loading data into the geodatabase

Creating a data owner user account
Workflow to load data
Workflow to update data
Automation using ModelBuilder

Managing storage settings

Configuration keywords
Using command-line tools to modify DBTune

Spatial types

RDBMS spatial types
Configuring spatial types
Converting a dataset's spatial type

Configuring permissions

Operating system versus database users
Creating user roles
Assigning permissions to datasets
Securing login credentials

Associating data

Query layers
Database views

Geodatabase maintenance

Updating statistics
Creating and updating indexes
Using Python scripts to maintain performance

Managing locks

Schema and feature locks
Identifying and removing locks

Bringing it all together

Applying the geodatabase workflow to implement a multiuser geodatabase
Install, create, and configure a multiuser geodatabase
Load data and perform maintenance tasks

Best GIS Training will provide the following software to use during class:

ArcGIS 10.7 for Desktop (Standard)
ArcGIS 10.7 for Server Enterprise (Basic)
Microsoft SQL Server Standard 2012
PyScripter for Python 2.5.3