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 do not require configuration before you can access them. However, you can perform some administration tasks—such as creating another geodatabase, creating roles or groups, or moving data between instances—if your workflow requires it. Listed here are some of these optional advanced administration tasks, tools used to perform them, and links to documentation with further instructions.

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 with the Esri Amazon Machine Image (AMI), 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 your 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.