Accessing ArcSDE data in tools


If you use ArcSDE data as project data in tools you share across your LAN or in geoprocessing services, you need to provide an unambiguous connection to the ArcSDE database. This topic shows you how to copy an ArcSDE connection file to your ToolShare folder and use the copied connection in your models, as illustrated below.

ToolShare folder with ArcSDE connection

When you, or other users on your LAN, connect to ArcSDE, they browse to the Database Connections folder in their ArcCatalog tree and double-click Add Spatial Database Connection to connect to an ArcSDE database using their credentials. They may also choose to rename the connection from the default (such as "Connection to DeepThought.sde" to "DeepThought.sde"). The connection you use (such as DeepThought.sde) may not exist on another user's computer, and the model will fail because it cannot find the data it needs. You need to account for this situation when you share your tools across a LAN or as a geoprocessing service. This is what is meant by providing an unambiguous connection.

The steps below result in an unambiguous ArcSDE connection in the ToolData directory. If you share your folder across the LAN you can use a UNC pathname to your ArcSDE Database Connection.

  1. In ArcCatalog, browse to the Database Connections entry.
  2. If needed, add a connection to the database.
  3. Right-click the connection and click Copy.
  4. Browse to the ToolData folder of your ToolShare folder and paste the connection. The example below shows the pasted connection, renamed to the name of the ToolShare folder, Forest, as illustrated below. Be sure to add the .sde suffix if you rename.
  5. Copied SDE connection

  6. When you add ArcSDE data to a model, browse to this new connection file rather then the connection file in the Database Connections folder.
  7. You now have an unambiguous Database Connection. When your model is executed across the LAN or as an geoprocessing service, the database will be found.

See Also