Connections

CartoPac utilizes connections to databases and map services with Feature Access (Feature Services) through CartoPac Studio and CartoPac Server (CPS).

CartoPac Studio (Mobile Form Configuration Application) supports a broad range of connection types for transferring data to and from a mobile device.

The CartoPac Server (CPS) System Data connection is a single ADO.NET connection to a proprietary set of tables used to manage the CPS web application (refer to System Data Overview for more information).

Database Platforms

Database Platforms

Platform

Version*

Desktop

Server

Studio Connection Method

CPS System Data Connection Method

Oracle 11 g, 12.1 c

Ado.Net, ArcObjects (x32), ArcGIS Feature Service (see below)

Ado.Net (x32 Managed|un-managed)

SQL Server

2012 SP3, 2014, 2016, 2017

Ado.Net, ArcObjects (x32), ArcGIS Feature Service (see below)

Ado.Net (x32)

Postgres

9.5.3

ArcObjects (x32), ArcGIS Feature Service (see below)

Ado.Net (x32)

Access

2010, 2013

Ado.Net, ArcObjects (x32) (see below)

 

ESRI FGDB

Supported ArcGIS Version (refer to Compatibility with Other Systems

-

Ado.Net, ArcObjects (x32) (see below)

-

*The database version assume that you are using ArcGIS Server 10.5. If you are using a newer version of ArcGIS, you will require newer versions of your databases. Refer to the SQL Server, Oracle, or Postgres web sites for updated version requirements.

Ado.Net Connections (Native)

CartoPac Server may establish connections to Native Oracle, SQL Server, and Postgres Enterprise Databases with an appropriate Ado.Net provider configured on the Server.

CartoPac Studio (Mobile Form Configuration Application) may establish connections to native Oracle and SQL Server databases.

CartoPac Studio does not support ADO.NET connectivity to Postgres databases. Postgres ADO.NET connections may only be used for accessing the CartoPac Server System Database (refer to ). CartoPac Studio does support Feature Service Connections and Direct Connections to ArcGIS Enterprise Geodatabases stored in a Postgres dbms.

ArcObjects Connections (SDE Direct)

CartoPac Server may establish connections to Enterprise Geodatabases with SDE Direct Connect Syntax using ArcObjects (x32).

ArcObjects (x32) connections require:

  • ArcGIS Server Installed Locally and Licensed

  • ArcGIS Desktop Installed Locally (No License Required)

Feature Service Connections (HTTP)

CartoPac Server may establish connections to Enterprise Geodatabases through an ArcGIS Feature Service (Map Service with Feature Access Enabled).

Feature Service connections require:

  • Network access to an ArcGIS Feature Service with Layers used in data collection

  • Feature Service connections allow for greater flexibility in System Architecture but may result in decreased performance when downloading projects in the field.