Introduction to storing the Workflow Manager workspace in a geodatabase in Oracle

For the ArcGIS Workflow Manager for Desktop applications to function, all the Workflow Manager (WMX) system tables must exist in the database, and of those, the tables that host required configuration information must be populated with values that will drive the application behavior. The following section details how to create and start configuring the Workflow Manager system tables.

This guidebook is intended for database administrators as recommendations for establishing the WMX workspace in a geodatabase in Oracle. The enterprise geodatabase uses ArcSDE technology as the gateway between GIS clients and Oracle.

Before starting this guidebook, you need to install the ArcSDE service and Oracle software.

ArcSDE software installation

Connections to enterprise geodatabases use direct connections by default, but the ArcSDE application service is required if you want to connect to your geodatabase using the ArcSDE service connections. Direct connections are recommended.

If you will only be using direct connections and don't want the administration command line tools, ArcSDE installation isn't required.

If you want to install the ArcSDE application service or the administration command line tools, you need to download the ArcSDE installation files for your database management system and operating system from the Esri Customer Care portal. It may be useful to install the ArcSDE administration command line tools to perform certain advanced configuration operations.

For more information about ArcSDE services, see What is an ArcSDE service.

Oracle software installation

The Oracle software media kit contains instructions to install Oracle on different platforms. Refer to software media kits for an easy and fast installation. Alternatively, review documentation provided Oracle 11g standard edition software on Windows.