English

How To: Setup an SDE Database for Survey Analyst

Summary

Instructions provided are for setting up an ArcSDE database for Survey Analyst that involves an easy 3-step process. The steps must be completed to begin creating survey datasets in an ArcSDE geodatabase.

Note:
Survey Analyst is only supported with ArcSDE databases that use an SDE schema for the ArcSDE repository.

Procedure

A set of six tables, called the Survey Dictionary Tables, store the necessary information for the survey datasets. There is one set of tables for each SDE database. Assuming survey data is to be stored, create the set of dictionary tables for each new ArcSDE database.

Survey Analyst must be installed before continuing with the following steps.

  1. Locate the ArcGIS\bin folder; for example, C:\ArcGIS\arcexe82\bin or C:\Program Files\ArcGIS\bin. Within the folder is a file called SetupSDB.exe. This utility will create the dictionary tables.

    Note:
    - You must have Database Administrator Privileges (DBA) to run this utility.
    - Executing the utility without parameters invokes a mini help.


    Execute SetupSDB using the following syntax. Substitute the parameters according to your setup:

    Code:
    setupsdb -o create -i 5151 -s myDBserver -p myDBApassword -D myDBname


    Code:
    5151:
    ArcSDE service name. Check your ArcSDE configuration for this.

    myDBserver:
    The name of the server where ArcSDE is installed

    myDBApassword:
    The DBA password of this SDE instance (password of user sde)

    myDBname:
    The database for which the tables are to be created.
    This is an optional parameter.
    If it is omitted then the dictionary tables are installed into the database called sde.

  2. Update the DBTUNE.SDE file.

    Survey Analyst needs a specific keyword to be setup in the dbtune configuration of the SDE server. To update the dbtune configuration of an ArcSDE instance use the following ArcSDE utility on the command line. Substitute the parameters according to the setup:

    Code:
    sdedbtune -o export -f dbtune.sde -i 5151 -s myDBserver -D myDBname -u sde -p myDBApassword


    This will export the dbtune configuration into an editable dbtune.sde file in the ArcSDE home directory (%SDEHOME%). Once the file is exported, open it into a text editor of your choice.

    Depending on the database management system(DBMS), add the following statement:

    For SDE on DB2:
    Code:
    ##SURVEY_MULTI_BINARY
    END


    For ArcSDE on Informix:
    Code:
    ##SURVEY_MULTI_BINARY
    S_STORAGE "SBLOBDBS"
    END


    For ArcSDE on Oracle:
    Code:
    ##SURVEY_MULTI_BINARY
    ATTRIBUTE_BINARY "BLOB"
    END


    For ArcSDE on SQLServer:
    Code:
    ##SURVEY_MULTI_BINARY
    END


    Save the file dbtune.sde.
  3. Import the file into the running ArcSDE configuration using the following command:
    Code:
    sdedbtune -o import -f dbtune.sde -i 5151 -s myDBserver -D myDBname -u sde -p myDBApassword