Editing a Connection

Spectrum Spatial Manager allows you to edit the path of a file-system connection or the URL and optional properties of a JDBC database connection if you have Modify permissions for the named connection. You cannot change the type of connection (for example, you cannot change a file system connection to a database connection). Editing will update other resources (for which you have Modify permissions) that reference the modified connection to reflect the new path or database connection URL, therefore preserving references between resources and the permissions assigned to the modified resource.

Note: Editing is not allowed for FDO and Extensible Data Provider (non-JDBC database) connections.

To edit a connection in Spectrum Spatial Manager:

  1. Select the connection you want to modify.
    The details page for the connection appears on the right side of the screen.
  2. On the details page, click Edit.
    Note: This button does not appear if you do not have sufficient permissions or if the connection is not a file-system or JDBC type of connection,.
    The Edit Connection page appears.
  3. Edit the connection depending on the type:
    File System
    Click the Browse button to change the folder that contains your datasources on your server file system. Alternatively, enter a folder path (for example, C:\data) or a UNC path (for example, \\localhost\share) in the Source Folder field. UNC paths are supported for Windows.
    Note: If you cannot locate a folder, check with your administrator to determine if restrictions have been placed at the file-server level. You must have access rights to this folder.
    1. Edit the JDBC connection URL to the database as required. This URL is in the format jdbc:subprotocol:subname. For example:
      • Oracle— jdbc:oracle:thin:@oracle.example.com:1521:pbspatial
      • SQL Server—jdbc:sqlserver://sqlserver.example.com:1234;databaseName=pbspatial
      • Postgres/PostGIS— jdbc:postgresql://postgres.example.com:1433/pbspatial
      • Generic JDBC —jdbc:mysql://mysql.example.com:3306/pbspatial
      For specific information on the JDBC connection URL format, refer to the database's website.
    2. In the Username field, optionally specify the user for connecting to the database resource.
    3. In the Password field, optionally specify the password for the user connecting to the database resource.
    4. In the Properties field, optionally specify any database-specific connection properties. Consult the database documentation for property names and value types that can be appended to a connection string. For example, property value networkProtocol and key tcp.
    5. Click Test to make sure your connection is valid.
    Note: To apply row level security on a database, see Applying Row Security for a Database.
  4. Click Save.

    A confirmation dialog opens to inform you about other resources that may be affected by modifying the connection. Click a link to open the associated resource in a new tab, to help you determine whether or not you want to proceed with the edit.

  5. Click Save.
    The details page for the modified connection appears.