ArcFM Desktop Configuration Guide
Database Connections

Version: 10.2.1c and 10.2.1c SP3

Resource Center Home
ArcFM Desktop > Geodatabase Manager > Database Connections

The Database Connections tab allows you to set connections to your Process Framework and SDE databases. These are the databases Geodatabase Manager uses to post and reconcile versions.

Ensure you have the correct licenses selected on the Licenses tab before setting up your database connections.
  1. Ensure you have the correct service selected in the Available Services window.
  2. Select the Database Connections tab.

Process Framework

  1. If you wish to reconcile or post sessions and/or designs using Geodatabase Manager, select the "Enable Processing of Sessions and Designs" checkbox. If you don't plan to process sessions or designs, skip to the Connection Properties section.
  2. Select an option from the Provider field. This indicates whether the Process Framework is Oracle or SQLServer.
  3. Enter the TNS name for the database in the Data Source field.
  4. Enter the user name that should be used to log into the Process Framework database when reconciling or posting. This login user must have permissions to read/write the Process Framework tables and have the roles assigned that allow it to execute any tasks that may be executed during reconcile or post. Most commonly this will be the login that is used to log into the Process Framework Administrator tool (by default, the PROCESS user).
  5. Enter the password for the user. This should be the password for the Process user.
  6. If you have selected SQLOLEDB as a Provider, enter the Database name (sde). If you selected OraOLEDB.Oracle as the Provider, this field is disabled.
  7. Select the extension(s) available in the Process Framework database. You may select either Session Manager, Workflow Manager, both, or neither.
  8. Click Test Connection to ensure the properties entered are valid.
  9. If you want to set a new connection, click Clear Connection and start with step 1.

MSSQL Connection Properties

  1. Enter the geodatabase instance in the Instance field. If MSSQL is not installed at the site, you should enter a valid direct connect string in the Instance field. It should look something like the following:
    • sde:sqlserver:localhost\sqlexpress
    • sde:sqlserver:giants.miner.com\mssql7
  2. The User field must contain the SDE user name.
  3. Enter the password for the SDE user in the Password field.
  4. Enter the name of the database (arcfm).
  5. Click Test Connection to ensure the properties entered are valid.
  6. Click Apply to save changes and retain the Geodatabase Manager window. Click OK to save changes and dismiss the window. Click Close to dismiss the window. You will be prompted to save changes before closing.

    You can modify the configuration of a service while it is running, but your changes will not be active until the service is restarted.
  7. If you want to set a new connection, click Clear Connection and start with step 1.

    If the Test Connection tool fails, select the Licenses tab and ensure you have the correct Esri license selected. Errors in the event log will indicate incorrect licensing.

Oracle Connection Properties

  1. Enter the geodatabase instance in the Instance field. Assuming you have your client set up to support EZCONNECT connections, use the following string:
    • sde:oracle11g:giants.miner.com/orce.giants (for Oracle 11g client)
    • sde:oracle12c:giants.miner.com/orce.giants (for Oracle 12c client)
  2. If you do have an entry for orce.giants in your tnsnames.ora file, use the following string:
    • sde:oracle11g:orce.giants (for Oracle 11g client)
    • sde:oracle12c:orce.giants (for Oracle 12c client)
  3. The User field must contain the SDE user name.
  4. Enter the password for the SDE user in the Password field.
  5. Leave the Database field blank.
  6. Click Test Connection to ensure the properties entered are valid.
  7. Click Apply to save changes and retain the Geodatabase Manager window. Click OK to save changes and dismiss the window. Click Close to dismiss the window. You will be prompted to save changes before closing.

    You can modify the configuration of a service while it is running, but your changes will not be active until the service is restarted.
  8. If you want to set a new connection, click Clear Connection and start with step 1.

    If the Test Connection tool fails, select the Licenses tab and ensure you have the correct Esri license selected. Errors in the event log will indicate incorrect licensing.

 

SDE Connection Properties

  1. Enter the name of your geodatabase server in the Server field.
  2. Enter the corresponding instance in the Instance field. If ArcSDE is not installed at the site, you should enter a valid direct connect string in the Instance field.
  3. The User field must contain the SDE user name.
  4. Enter the password for the SDE user in the Password field.
  5. If you're connecting to a SQLServer, enter the name of the database (arcfm). If it's Oracle, leave the Database field blank.
  6. Click Test Connection to ensure the properties entered are valid.
  7. Click Apply to save changes and retain the Geodatabase Manager window. Click OK to save changes and dismiss the window. Click Close to dismiss the window. You will be prompted to save changes before closing.

    You can modify the configuration of a service while it is running, but your changes will not be active until the service is restarted.
  8. If you want to set a new connection, click Clear Connection and start with step 1.

    If the Test Connection tool fails, select the Licenses tab and ensure you have the correct Esri license selected. Errors in the event log will indicate incorrect licensing.

 

 

 

Send Comment to ArcFMdocumentation@schneider-electric.com