Skip To Content

Connect from an ArcGIS Server instance to an enterprise geodatabase

You can connect from an ArcGIS Pro installation in Amazon Web Services (AWS) to an enterprise geodatabase in a supported AWS database instance.

Tip:

Esri Microsoft Windows Amazon Machine Images (AMI) include an installation of ArcGIS Pro. Once you license the installation, you can use it to connect to an enterprise geodatabase in AWS.

Follow these steps to connect to a geodatabase in an AWS database:

  1. As the Administrator, log in to the AWS instance where ArcGIS Pro is installed and authorize ArcGIS Pro.

    If your deployment includes an ArcGIS Enterprise portal, you can license ArcGIS Pro through the portal.

  2. Start ArcGIS Pro, create a project, and open the Catalog pane. Be sure you have the Project group open.
  3. Right-click the Databases node and click New Database Connection.
  4. Provide connection properties for the type of database instance you're using:

    The following table lists connection information for an Amazon RDS for SQL Server instance:

    FieldValue

    Database Platform

    SQL Server

    Instance

    Type a connection string composed of the following: <database_instance_identifier>.<region_id>.rds.amazonaws.com

    • database_instance_identifier—You provided this name when you created the RDS.
    • region_id—This is assigned by AWS. It includes an identifier and the name of the region in which you created the RDS.

    Authentication Type

    Database authentication

    User name

    Type the name of a database user.

    • If you created your site using ArcGIS Enterprise Cloud Builder Command Line Interface for Amazon Web Services or a CloudFormation template provided by Esri type sde for the user name.
    • If you created your own user in the database, type that user name.

    Password

    Type the password for the database user.

    Save user name and password

    Check the box next to this parameter.

    Database

    Choose the name of the geodatabase to which you want to connect

    The following table lists connection information for an Amazon RDS for PostgreSQL or Amazon Aurora (PostgreSQL-compatible edition) instance:

    FieldValue

    Database Platform

    PostgreSQL

    Instance

    Type a connection string composed of the following: <database_instance_identifier>.<region_id>.rds.amazonaws.com

    • database_instance_identifier—You provided this name when you created the RDS.
    • region_id—This is assigned by AWS. It includes an identifier and the name of the region in which you created the RDS.

    Authentication Type

    Database authentication

    User name

    Type the name of a database user.

    • If you created your site using a CloudFormation template provided by Esri, type owner for the user name.
    • If you created your own user in the database, type that user name.

    Password

    Type the password for the database user.

    Save user name and password

    Check the box next to this parameter.

    Database

    Choose the name of the geodatabase to which you want to connect.

  5. Click OK to connect and close the Database Connection dialog box.
  6. Type a name for the connection.

    For example, type egdb.

The database connection file is created in the project folder you designated when you created yourArcGIS Pro project.

You can connect to an enterprise geodatabase in an Amazon RDS instance from an on-premises installation of ArcGIS Pro; however, performance will be slower than if you connect from an ArcGIS Pro installation on an Amazon Elastic Compute Cloud (EC2) instance in the same AWS region as the RDS instance. Also, you must open ports in your security group to connect to the RDS instance from an on-premises machine.