Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Mastering ArcGIS Enterprise Administration
Mastering ArcGIS Enterprise Administration

Mastering ArcGIS Enterprise Administration: Install, configure, and manage ArcGIS Enterprise to publish, optimize, and secure GIS services

eBook
$43.99
Paperback
$54.99
Subscription
Free Trial
Renews at $12.99p/m

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Table of content icon View table of contents Preview book icon Preview Book

Mastering ArcGIS Enterprise Administration

Chapter 2. Enterprise Geodatabase Administration

At the heart of any good enterprise GIS system lives a clean, tidy, and performant enterprise geodatabase. The geodatabase is the core of a strong GIS system; without data, you have nothing. Likewise, a poorly installed, configured, or maintained geodatabase leads to disappointing applications for end users. Proper installation, configuration, tuning, maintenance, and administration of the geodatabase is crucial to the health and usability of a GIS.

Before we can cover enterprise geodatabase administration, we first need to discuss what makes an enterprise geodatabase; how we install, create, or enable one; how we connect to it; and how we load data into it. Also, keep in mind that, in no way can we cover all aspects of Enterprise geodatabase administration in one chapter; an entire book could be dedicated just to this topic. Instead, this chapter will highlight several aspects of installing, configuring, and maintaining an SQL Server enterprise...

What constitutes an enterprise geodatabase?


A geodatabase is a spatially-enabled database. Within the ArcGIS Enterprise framework, there are three types of geodatabases:

  • Personal geodatabase: This uses Microsoft Access for data storage, and it has a size limit of 2GB.
  • File geodatabase: This uses the file system folder for storage of GIS datasets; each dataset can be 1TB in size. If not using an enterprise geodatabase, this is the recommended file-based storage type.
  • Enterprise geodatabase: This uses a relational database management system (RDBMS) for data storage, supports multiple simultaneous user connections, and is limited in size by the RDBMS.

Personal and file geodatabases are intended for single users and small workgroups with one writer and multiple readers, where concurrent user connections eventually degrade performance with more and more readers. File geodatabases can have only one editor per feature dataset, stand-alone feature class, or table. For medium to large organizations needing...

Relational database management system installation and configuration


The first step in setting up an enterprise geodatabase is to install your RDBMS. In many organizations, this is handled by someone in the IT department, such as a database administrator or systems administrator. If so, try to work with them as much as possible for the setup of your RDBMS; not only will you build a stronger working relationship with them, you will further understand how your RDBMS was installed and configured.

For this book, we will be using SQL Server 2014 Standard Edition SP2 as our RDBMS. As always, consult the documentation of your RDBMS for detailed installation and configuration instructions.

RDBMS installation

RDBMS installations can be quite lengthy with dozens of steps. For this reason, we will not cover every step in the SQL Server 2014 installation, but instead touch on those points that might be tricky or otherwise important regarding our GIS system. Remember to check your RDBMS documentation regarding...

Creating or enabling an enterprise geodatabase


To create a geodatabase, you must use ArcGIS Desktop licensed at either Standard or Advanced level, ArcGIS Pro Standard or Advanced, or a Python script on a machine with the proper level of Desktop or Pro installed. There are two ways to create an enterprise geodatabase in SQL Server, depending upon your level of access to the database:

  • You create the enterprise geodatabase using the Create Enterprise Geodatabase geoprocessing tool. Here, you are both the SQL Server database and geodatabase administrator. This option applies if you installed SQL Server and/or you have sysadmin access to the SQL Server instance.

Note

In SQL Server, the database administrator owns everything in the entire SQL Server instance. The geodatabase administrator, on the other hand, owns only the objects within a geodatabase.

  • Your SQL Server administrator creates the database and the geodatabase administrator (you) creates the geodatabase.

Let's break down these options in...

Connecting to the geodatabase


Now that we have a shiny new enterprise geodatabase, we need to connect to it. A connection allows us to use, manage, and administer the geodatabase. Before we can connect, there are a few items to configure.

To allow connections from machines other than the SQL Server machine itself, we must ensure that remote connections to the database server are allowed. To do this, first open SQL Server Management Studio on your database server and log in with the sysadmin credentials. In the Object Explorer pane, right-click on the database server and go to Properties. In the Properties window, select the Connections page. Under remote server connections, ensure that Allow remote connections to this server are checked. Click on OK.

Next, open SQL Server Configuration Manager and under SQL Server Network Connection, select Protocols for <your server>. Ensure that TCP/IP is enabled. Right-click on TCP/IP and go to Properties. Select the IP Address tab and scroll down...

Users, roles, and privileges


Within the geodatabase, there is a hierarchy of users, with each level being based on what actions the user can perform. We have talked at length about the most powerful two of these users, the database administrator and geodatabase administrator. These users are vital to the creation, management, and maintenance of the enterprise geodatabase. As the following diagram shows, with great power, there must also come great responsibility. Database administrators and geodatabase administrators are both powerful accounts with far-reaching privileges. The following diagram shows that with increased privileges in the database, come increased responsibilities:

Note

Remember that the geodatabase administrator account should never own data in the geodatabase.

The data owner account

Another important account is the data owner; this account owns the schema and therefore the data, sets privileges, performs maintenance tasks, and probably most importantly, loads data into the geodatabase...

Loading data


For our purposes here, loading data refers to initially creating datasets in a geodatabase. Any user with proper edit privileges can insert data into an existing feature class or table. Loading data into the geodatabase is a task typically reserved for those with access to the data owner account credentials. Data should always be loaded (and feature classes and tables created) under the data owner account; in other words, the user loading the data must be connected to the geodatabase as the data owner.

Note

Never load data while connected as the sde user; this will make the sde account the owner of that data.

There are many ways to load data into the geodatabase, and these vary based on the format of the source data. Let's discuss some of these methods where they are applicable, and their pros and cons.

Storage

Before discussing data loading, we should briefly touch on storage, the primary role of an enterprise database. Each RDBMS supported by ArcGIS Enterprise has its own mechanisms...

Database maintenance


A well-maintained geodatabase is a performant geodatabase. Database maintenance requirements vary from system to system, but there are several routine tasks that need to be carried out on all systems.

Backups

Although not necessary for performance, database backups taken on a routine schedule are crucial to the safety, integrity, and security of your system. Not only do database backups protect you from data loss in the event of system failure, they also protect you in the case of data corruption. Database backups are typically scheduled and handled by the database administrator, but it should also be the responsibility of the geodatabase administrator to ensure that this process is in place and carried through.

Just as important as taking the backups, is to routinely, yet randomly, test your database backups. This entails restoring backups to a different SQL Server instance to ensure that the backups are valid and current. This also keeps the staff current on the protocols...

Summary


A GIS is only as good as the data that powers it. Geodatabase administration is crucial in keeping a well maintained, performant geodatabase that users will be able to utilize efficiently. In this chapter, we discussed how to create a geodatabase, connect to it, create accounts for users to access it, load data into it, manage user privileges, manage user connections, and perform routine maintenance. Next up in Chapter 3, Publishing Content, we will look at using our data in published content in ArcGIS Server.

 

 

 

 

 

 

Left arrow icon Right arrow icon
Download code icon Download Code

Key benefits

  • - Install and configure the components of ArcGIS Enterprise to meet your organization's requirements
  • - Administer all aspects of ArcGIS Enterprise through user interfaces and APIs
  • - Optimize and Secure ArcGIS Enterprise to make it run efficiently and effectively

Description

ArcGIS Enterprise, the next evolution of the ArcGIS Server product line, is a full-featured mapping and analytics platform. It includes a powerful GIS web services server and a dedicated Web GIS infrastructure for organizing and sharing your work. You will learn how to first install ArcGIS Enterprise to then plan, design, and finally publish and consume GIS services. You will install and configure an Enterprise geodatabase and learn how to administer ArcGIS Server, Portal, and Data Store through user interfaces, the REST API, and Python scripts. This book starts off by explaining how ArcGIS Enterprise 10.5.1 is different from earlier versions of ArcGIS Server and covers the installation of all the components required for ArcGIS Enterprise. We then move on to geodatabase administration and content publication, where you will learn how to use ArcGIS Server Manager to view the server logs, stop and start services, publish services, define users and roles for security, and perform other administrative tasks. You will also learn how to apply security mechanisms on ArcGIS Enterprise and safely expose services to the public in a secure manner. Finally, you’ll use the RESTful administrator API to automate server management tasks using the Python scripting language. You’ll learn all the best practices and troubleshooting methods to streamline the management of all the interconnected parts of ArcGIS Enterprise.

Who is this book for?

This book will be geared toward senior GIS analysts, GIS managers, GIS administrators, DBAs, GIS architects, and GIS engineers that need to install, configure, and administer ArcGIS Enterprise 10.5.1.

What you will learn

  • - Effectively install and configure ArcGIS Enterprise, including the Enterprise geodatabase, ArcGIS Server, and Portal for ArcGIS
  • - Incorporate different methodologies to manage and publish services
  • - Utilize the security methods available in ArcGIS Enterprise
  • - Use Python and Python libraries from Esri to automate administrative tasks
  • - Identify the common pitfalls and errors to get your system back up and running quickly from an outage

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Oct 27, 2017
Length: 382 pages
Edition : 1st
Language : English
ISBN-13 : 9781788296847
Vendor :
ESRI
Category :
Languages :
Tools :

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Product Details

Publication date : Oct 27, 2017
Length: 382 pages
Edition : 1st
Language : English
ISBN-13 : 9781788296847
Vendor :
ESRI
Category :
Languages :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$12.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 6,500+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$129.99 billed annually
Feature tick icon Unlimited access to Packt's library of 6,500+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
$179.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 6,500+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total $ 164.97
Mastering ArcGIS Enterprise Administration
$54.99
Building Web and Mobile ArcGIS Server Applications with JavaScript ??? Second Edition
$54.99
ArcPy and ArcGIS
$54.99
Total $ 164.97 Stars icon
Visually different images

Table of Contents

10 Chapters
ArcGIS Enterprise Introduction and Installation Chevron down icon Chevron up icon
Enterprise Geodatabase Administration Chevron down icon Chevron up icon
Publishing Content Chevron down icon Chevron up icon
ArcGIS Server Administration Chevron down icon Chevron up icon
Portal for ArcGIS Administration Chevron down icon Chevron up icon
Security Chevron down icon Chevron up icon
Scripting Administrative Tasks Chevron down icon Chevron up icon
The ArcGIS Python API Chevron down icon Chevron up icon
ArcGIS Enterprise Standards and Best Practices Chevron down icon Chevron up icon
Troubleshooting ArcGIS Enterprise Issues and Errors Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.8
(15 Ratings)
5 star 80%
4 star 20%
3 star 0%
2 star 0%
1 star 0%
Filter icon Filter
Top Reviews

Filter reviews by




Mesaque Botelho Junior Feb 26, 2019
Full star icon Full star icon Full star icon Full star icon Full star icon 5
It has all we need to start an environment implementation and administration. Also has some scripts orientations and best practices.
Amazon Verified review Amazon
R. Brian Culpepper Dec 06, 2017
Full star icon Full star icon Full star icon Full star icon Full star icon 5
A super useful book for the existing ArcGIS Server user or those planning to migrate into the ArcGIS Enterprise GIS platform. It also contains excellent supplemental information that you WILL APPRECIATE later!!This is a well-organized 345-page guide to ArcGIS Enterprise 10.5.x and how it is different from earlier versions of ArcGIS Server. The author clearly describes what/why of the four major components of ArcGIS Enterprise, and continues with a recommended installation, set-up and management of an Enterprise GIS system within the windows operating system. Chad Cooper provides helpful tips or best practices throughout each chapter, plus a handful of handy, open-source management resources and useful, sample python scripts are described within the text. I’ve got to try some of these too! This book was written by a long-time GitHub contributor with extensive experience within small and large organizations leveraging these ArcGIS products so the tips and tricks alone are worthwhile.
Amazon Verified review Amazon
J. M. Ramirez May 25, 2018
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Mr. Cooper’s new book, Mastering ArcGIS Enterprise Administration, is a useful and handy guide worthy of your desktop reference library and as a thorough step-by-step guide to deploying ArcGIS Enterprise 10.5.1.Chad’s “from nothing to fully deployed” approach in Mastering ArcGIS Enterprise Administration begins with the basic components of an ArcGIS Enterprise deployment and finishes with excellent recommendations for administration. Along the way, he manages to balance providing well indexed reference content that is easily accessible while still including what most GIS practitioners would consider advanced content. For the adventurous and seasoned veterans, there are a few chapters (Chapter 7: Scripting Administrative Tasks & Chapter 8: The ArcGIS Python API) containing impactful sample code in Python and advanced administration techniques. While delivering all of this, Chad includes quick primers for some big and frequently complicated topics like enterprise geodatabases configuration, security, and troubleshooting techniques – for once you have everything up and running.I’ve had Mr. Cooper’s reference book handy now for deployments in Azure and AWS both of which are included in the section entitled “ArcGIS Enterprise in the cloud”. Chad’s book is a vital tool for negotiating the sometimes-scary topic of ArcGIS Enterprise administration. It is my opinion that he succeeds here in delivering a comprehensive reference book for ArcGIS Enterprise administration, and I’d recommend it heartily to those about to tackle a new deployment.
Amazon Verified review Amazon
Mike S Jan 25, 2018
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Wow this is a helpful book, and it is up to date as of 10.5.1 (which is hard to come by). It clarifies a lot of Esri-specific terminology (i.e. what exactly is a PSA account, and what are some examples), and walks through installation step by step.It even helps with automated deployment (like Chef) by helping the reader to understand key variables.
Amazon Verified review Amazon
Roshan Kumar Jul 20, 2019
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Perfect content if you’re looking for ArcGIS server 10.5
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How do I buy and download an eBook? Chevron down icon Chevron up icon

Where there is an eBook version of a title available, you can buy it from the book details for that title. Add either the standalone eBook or the eBook and print book bundle to your shopping cart. Your eBook will show in your cart as a product on its own. After completing checkout and payment in the normal way, you will receive your receipt on the screen containing a link to a personalised PDF download file. This link will remain active for 30 days. You can download backup copies of the file by logging in to your account at any time.

If you already have Adobe reader installed, then clicking on the link will download and open the PDF file directly. If you don't, then save the PDF file on your machine and download the Reader to view it.

Please Note: Packt eBooks are non-returnable and non-refundable.

Packt eBook and Licensing When you buy an eBook from Packt Publishing, completing your purchase means you accept the terms of our licence agreement. Please read the full text of the agreement. In it we have tried to balance the need for the ebook to be usable for you the reader with our needs to protect the rights of us as Publishers and of our authors. In summary, the agreement says:

  • You may make copies of your eBook for your own use onto any machine
  • You may not pass copies of the eBook on to anyone else
How can I make a purchase on your website? Chevron down icon Chevron up icon

If you want to purchase a video course, eBook or Bundle (Print+eBook) please follow below steps:

  1. Register on our website using your email address and the password.
  2. Search for the title by name or ISBN using the search option.
  3. Select the title you want to purchase.
  4. Choose the format you wish to purchase the title in; if you order the Print Book, you get a free eBook copy of the same title. 
  5. Proceed with the checkout process (payment to be made using Credit Card, Debit Cart, or PayPal)
Where can I access support around an eBook? Chevron down icon Chevron up icon
  • If you experience a problem with using or installing Adobe Reader, the contact Adobe directly.
  • To view the errata for the book, see www.packtpub.com/support and view the pages for the title you have.
  • To view your account details or to download a new copy of the book go to www.packtpub.com/account
  • To contact us directly if a problem is not resolved, use www.packtpub.com/contact-us
What eBook formats do Packt support? Chevron down icon Chevron up icon

Our eBooks are currently available in a variety of formats such as PDF and ePubs. In the future, this may well change with trends and development in technology, but please note that our PDFs are not Adobe eBook Reader format, which has greater restrictions on security.

You will need to use Adobe Reader v9 or later in order to read Packt's PDF eBooks.

What are the benefits of eBooks? Chevron down icon Chevron up icon
  • You can get the information you need immediately
  • You can easily take them with you on a laptop
  • You can download them an unlimited number of times
  • You can print them out
  • They are copy-paste enabled
  • They are searchable
  • There is no password protection
  • They are lower price than print
  • They save resources and space
What is an eBook? Chevron down icon Chevron up icon

Packt eBooks are a complete electronic version of the print edition, available in PDF and ePub formats. Every piece of content down to the page numbering is the same. Because we save the costs of printing and shipping the book to you, we are able to offer eBooks at a lower cost than print editions.

When you have purchased an eBook, simply login to your account and click on the link in Your Download Area. We recommend you saving the file to your hard drive before opening it.

For optimal viewing of our eBooks, we recommend you download and install the free Adobe Reader version 9.