Skip To Content

Optional enterprise geodatabase management

The enterprise geodatabase included when you create a stand-alone ArcGIS Server site using one of the ArcGIS Enterprise on Amazon Web Services deployment tools does not require configuration before you can access it. However, you can perform some administration tasks—such as creating logins or groups or creating additional geodatabases—if your workflow requires it.

Manage logins

The ArcGIS Server sites created with ArcGIS Enterprise Cloud Builder for Amazon Web Services and sample Amazon Web Services CloudFormation templates from Esri come with default roles to administer geodatabases in Amazon Relational Database Service (RDS) instances and load spatial data to them. You may require additional login roles to manage your spatial data. For example, you may want to add a login that has read-only privileges in the database, require a login with a name other than the default name provided when you created the geodatabase using ArcGIS Enterprise on Amazon Web Services deployment tools, or want additional data owner logins in the database.

If you want additional logins, use SQL or your database management system tools to create them and assign privileges. If the new users will create data in the geodatabase, be sure to create schemas for the users. The schema must have the same name as the user name. See Amazon RDS documentation for more information on creating users and schemas.

Create additional geodatabases

If you include an enterprise geodatabase with the ArcGIS Server site you create with ArcGIS Enterprise Cloud Builder for Amazon Web Services, you have an option to include a geodatabase (named egdb) with the site. To create additional geodatabases—for example, if you want a geodatabase with a different name or you require additional geodatabases for different services or applications to access—or if you want a geodatabase in another supported AWS cloud database offering, you must do the following:

  1. Create the database service or a database on AWS using AWS tools.
  2. Create an sde user and sde schema in the database and grant the sde user privileges necessary to create a geodatabase.
  3. Create a database connection to connect to the database as the sde user. Use ArcGIS Pro installed in the same AWS region as the database service or run a geoprocessing tool from Python on an ArcGIS Server instance in the same AWS region as the database service to create the database connection file.
  4. Use the Enable Enterprise Geodatabase geoprocessing tool and the database connection file to create a geodatabase in the database. Run the tool from ArcGIS Pro installed in the same AWS region as the database service or run a geoprocessing tool from Python on an ArcGIS Server instance in the same AWS region as the database service.

After you create a geodatabase, connect to the database through SQL or a database management system app as an administrator, add the schemas and users you require, and grant permissions in the database.