HOW TO
GIS managers and database administrators sometimes desire to create sdeconnections for multiple users in their environment.
folderName = r"C:\sdeconnections"
serverName = "Prod1"
serviceName = "sde:sqlserver:Prod1\sql2008r2"
databaseName = "Replica"
authType = "DATABASE_AUTH"
saveUserInfo = "SAVE_USERNAME"
versionName = "SDE.DEFAULT"
saveVersionInfo = "SAVE_VERSION"
Code:
# Import system modules
import arcpy, os, string
from arcpy import env
# Set environment parameters
arcpy.env.overwriteOutput = True
# Set variables
folderName = r"C:\sdeconnections"
serverName = "Prod1"
serviceName = "sde:sqlserver:Prod1\sql2008r2"
databaseName = "Replica"
authType = "DATABASE_AUTH"
saveUserInfo = "SAVE_USERNAME"
versionName = "SDE.DEFAULT"
saveVersionInfo = "SAVE_VERSION"
username = {'sde':'sde', 'gisadmin':'gisadmin','User2':'user2'}
for key, val in username.iteritems():
arcpy.CreateArcSDEConnectionFile_management (folderName, key + "@" + serverName + ".sde", serverName, serviceName, databaseName, authType, key, val, saveUserInfo, versionName, saveVersionInfo)
print "Created connection file : " + key + "@" + serverName + ".sde"
Article ID: 000011676
Get help from ArcGIS experts
Download the Esri Support App