Learn the necessary system requirements and supported database-as-a-service options for integrating ArcGIS 10.8.x and Pro with cloud databases.

Introduction

Integrating ArcGIS with cloud databases has become essential for organizations aiming to harness the full potential of their geospatial data. Esri Cloud DB Services provide robust solutions that enable seamless connectivity, efficient data management, and enhanced performance. Understanding the system requirements and the supported database-as-a-service (DBaaS) options is crucial for a smooth integration process.

Types of Cloud Databases

When integrating ArcGIS with cloud databases, it’s important to recognize the two primary types available:

1. Databases Installed on Virtual Machines

Databases installed on virtual machines (VMs) in the cloud offer greater control over the environment. However, this also means that you are responsible for maintaining the VM, including tasks like applying security patches and managing the operating system. Whether you install the database manually or use a pre-configured image, the onus of upkeep lies with you.

2. Database-as-a-Service (DBaaS) Offerings

DBaaS provides a managed database environment where the service provider handles maintenance tasks such as updates and security patches. This option reduces the administrative burden, allowing you to focus more on data management and analytics rather than infrastructure maintenance.

Supported Cloud-Based Database Services

Esri supports a variety of cloud-based database services to ensure compatibility and optimal performance with ArcGIS. The primary supported platforms include:

Amazon Web Services (AWS)

Amazon Aurora (PostgreSQL-compatible edition): Supports versions 10.13 and 11.8 with compatible PostGIS versions.
Amazon RDS for Oracle: Compatible with ArcGIS Pro 2.6 and above.
Amazon RDS for PostgreSQL (Single Server option): Supports versions 10.1.4, 11.9, and 12.4 with compatible PostGIS versions.
Amazon RDS for SQL Server
Autonomous Transaction Processing database in Oracle Cloud: Supported from ArcGIS Pro 2.7.

Microsoft Azure

Azure Database for PostgreSQL (Single Server option): Supports versions 10.11 and 11.6, compatible with ArcGIS-supported PostGIS versions.
Azure SQL Database and Azure SQL Managed Instance
SAP HANA Cloud: Supported from ArcGIS Pro 2.6.

Limitations

Spatial Types: Only PostGIS spatial types are supported for PostgreSQL-compatible services, and SDO_Geometry for Oracle-based services.
Functions: Certain geoprocessing functions like GDB_UTIL.get_extent() and GDB_UTIL.geometry_type are not available in some DBaaS environments.
Deployment Tools: Esri’s specialized deployment tools are recommended for AWS and Azure. For other platforms, support is limited to replicating issues on-premises.

Software Requirements

To ensure seamless connectivity between ArcGIS and your chosen cloud database, the following software components are necessary:

Database Clients

ArcGIS Enterprise and ArcGIS Desktop: When deployed using Esri-provided AMIs or Azure images, the required database clients are pre-installed.
Custom Deployments: If deploying ArcGIS clients on other virtual machines or connecting to unsupported databases, you may need to manually install the appropriate database management system (DBMS) client files from the respective vendors.

Connectivity Considerations

Same Cloud Region: For optimal performance, connections between ArcGIS clients and cloud databases should originate from machines within the same cloud region.
Network Latency: Avoiding cross-regional connections reduces latency and minimizes the risk of connection timeouts.

Best Practices for Integration

To achieve a successful integration of ArcGIS with cloud databases, consider the following best practices:

Use Specialized Deployment Tools

Leverage Esri’s specialized tooling and images for AWS and Azure to simplify the deployment process and ensure compatibility.

Ensure Compliance with System Specifications

Verify that your cloud virtual machines meet the operating system and system specifications required by the ArcGIS clients and the chosen database service.

Implement Real-Time Monitoring

Utilize real-time monitoring tools to maintain visibility into database health and performance, enabling proactive management of potential issues.

Optimize Query Performance

Employ automated query optimization features to enhance database performance, ensuring efficient data retrieval and processing within ArcGIS.

Conclusion

Integrating ArcGIS with cloud databases using Esri Cloud DB Services offers significant advantages in terms of scalability, performance, and ease of management. By understanding the system requirements and selecting the appropriate DBaaS options, organizations can effectively leverage their geospatial data to drive informed decision-making and operational efficiency.

Ready to elevate your database management? Discover Incerto’s AI Database Co-Pilot and revolutionize your data operations today!