Create System Data

The CartoPac System Data tables may be created with a single script included with server installation files in the ..\Program Files (x86)\CartoPac\Bin\sql directory.

Run the script corresponding to the appropriate database platform:

  • CP_SYSTEMDATA_MSSQL.sql

  • CP_SYSTEMDATA_ORACLE.sql

  • CP_SYSTEMDATA_POSTGRES.sql

CartoPac System Data tables must be in a separate schema from field collection data. The System Data views require select privileges on all collection data, but they should be stored in a separate schema. For example: Collection Data may reside in an ArcGIS Enterprise Geodatabase in the SDE schema. The CartoPac System Data Tables should be created in a separate schema such as CARTOPAC; not in the SDE schema.

Run the script for the appropriate database platform to create the tables and views in a unique schema and store the credentials for later use in the CartoPac Server Setup Wizard's Configure System Data menu.