Configuring
Suggest editsImplementing Esri ArcGIS Pro and Esri ArcGIS Enterprise with EDB Postgres Advanced Server requires the following components:
- A running EDB Postgres Advanced Server instance
- PostGIS version 3.2 or later, installed on EDB Postgres Advanced Server
- Your GIS data
- A running Esri ArcGIS Pro instance
- Optionally, a running Esri ArcGIS Enterprise configuration for data and map sharing
Configuring EDB Postgres Advanced Server and PostGIS
You can configure PostGIS on your EDB Postgres Advanced Server instance and set up the appropriate users and extensions needed for PostGIS to work with Esri ArcGIS Pro and Esri ArcGIS Enterprise.
Prerequisites
You need these components before integrating EDB Postgres Advanced Server with Esri ArcGIS Pro and Esri ArcGIS Enterprise:
- A running instance of EDB Postgres Advanced Server
- PostGIS version 3.2 or later, installed on your EDB Postgres Advanced Server instance
You must create a gisadmin user, which is an administrator read/write user with superuser privileges. You must also install a PostGIS database and all of the extensions needed for PostGIS to operate correctly. We recommend then entering some data to ensure PostGIS is working and that you can view data with geometry data types.
- Create a gisadmin user:
- Log in as the new gisadmin user:
- Create a
postgis
database and connect to it:
- Create all of the PostGIS extensions:
- Create a table to test that PostGIS is working properly:
- Insert some data into the table that you created:
- Show the data that was added in table format:
- Show the PostGIS version:
Configuring ArcGIS Pro with EDB Postgres Advanced Server
After you configure PostGIS with your EDB Postgres Advanced Server instance and ensure that PostGIS is configured correctly, your database is ready to interact with Esri ArcGIS Pro as you create an enterprise geodatabase.
GIS data
You can create your own GIS datasets or download GIS data.
These test cases are using the sample HongKong GDB
data file, which you can find here.
Enable environment to create an enterprise geodatabase
Generate an authorization file for Esri ArcGIS Server license to generate a keycodes file for your enterprise geodatabase according to the ArcGIS documentation.
Verify that you have the authorization file, which is typically located in
C:\Program Files (x86)\Common Files\ArcGIS\bin
.To run the authorization wizard to start generating your keycodes file, double-click
SoftwareAuthorization.exe
.In the Software Authorization wizard, under Authorization Options, select I have received an authorization file and am now ready to finish the authorization process.
Select Browse to select the
.ecp
authorization file obtained in step 1.For Product to be Authorized, make sure ArcGIS Server is selected, and then select Next.
On the Authorization Method page, accept the default option, Authorize with Esri now using the Internet, and select
Next
.On the Authorization Information page, confirm that your contact information is correct, and then select Next.
On the Authorization Information (continued) page, enter your industry information, confirm your selections, and then select Next.
On the Software Authorization Number screen, enter your license number, and then select Next.
If you don't want any extensions, on the Authorize Software Extensions page, select the default option, I do not want to authorize any extensions at this time. Select Next.
The authorization process starts. When it finishes, a message reports that the software has been authorized.
After your license is successfully authorized, select Finish. Your keycodes file is created.
Navigate to the following location to verify the newly created keycodes file is present:
C:\Program Files(x86)\Esri\License10.x\sysgen
.This keycodes file is used when you create an enterprise geodatabase.
Configuring an Esri ArcGIS Enterprise environment
If you need an Esri ArcGIS Enterprise environment, you must configure and run it. For instructions see this ArcGIS Enterprise tutorial.
Esri ArcGIS Pro configuration for enterprise sharing
Before you can share from your Esri ArcGIS Pro environment to an Enterprise portal that you created, you need to add that portal in your Esri ArcGIS Pro environment.
- In ArcGIS Pro, select Projects > Portals.
- To add the URL of the portal you want to use, select Add Portal.
- Set the portal as the active portal by selecting the option from the ... menu to the right.
- Right-click the portal name, and then select Sign in.
After you sign in to your Esri ArcGIS Enterprise portal, you're ready to share to an Esri ArcGIS Enterprise environment.
Could this page be better? Report a problem or suggest an addition!