topic Copying SDE credentials from ArcGIS Server Datastores into MXD in Python Questions https://community.esri.com/t5/python-questions/copying-sde-credentials-from-arcgis-server/m-p/26346#M1967 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P></P><P>I am trying to determine if this is just a dead-end of an approach.&nbsp; I have a fairly convoluted deployment workflow whereby various actors test a given MXD and deploy to varied AGS servers.&nbsp; As the trustee of the MXD I have little direct control over these resources though I can make suggestions.&nbsp; One approach which has worked okay with registered folders is to have a common AGS data store name that everyone agrees represents a project's data source.&nbsp; Each AGS server can set this up as needed under the rubric of that name.&nbsp; Then I have an ArcPy deployment script that I provide to these folks that (via an administrator connection) reads the data store publisher folder location and swaps the correct folder path in the MXD before deploying to AGS.&nbsp; This works okay.</P><P></P><P>Ideally it would be grand to do the same with SDE connections.&nbsp; However as one might expect the management of the passwords is the issue.&nbsp; As the AGS administrator, one can run arcpy.ListDataStoreItems and get the SDE credentials for a given data store (only interested here in publisher).&nbsp; But the password is returned as "ENCRYPTED_PASSWORD".&nbsp; In the current security model for 10.2.2 is there any arcpy method whereby I can take that encrypted password and create a new SDE connection with it to then install into a MXD? </P><P></P><P>When using arcpy.CreateArcSDEConnectionFile_management it wants the clear text version of the password and not the encrypted text string.&nbsp; Is there a way to provide this method the encrypted string or am I just going off into dodgy security territory?&nbsp; I have no need of the actual password itself but I suppose I am moving the credential out of AGS and into the MXD (just for the deployment) and I can see that might be a tad insecure.&nbsp; However, as this is run through an AGS administrator connection I would think that is within my scope. I am not quite sure.</P><P></P><P>Any feedback would be appreciated.</P><P></P><P>Thanks,</P><P>Paul</P></BODY></HTML> Thu, 04 Dec 2014 13:00:46 GMT PaulDziemiela 2014-12-04T13:00:46Z Copying SDE credentials from ArcGIS Server Datastores into MXD https://community.esri.com/t5/python-questions/copying-sde-credentials-from-arcgis-server/m-p/26346#M1967 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P></P><P>I am trying to determine if this is just a dead-end of an approach.&nbsp; I have a fairly convoluted deployment workflow whereby various actors test a given MXD and deploy to varied AGS servers.&nbsp; As the trustee of the MXD I have little direct control over these resources though I can make suggestions.&nbsp; One approach which has worked okay with registered folders is to have a common AGS data store name that everyone agrees represents a project's data source.&nbsp; Each AGS server can set this up as needed under the rubric of that name.&nbsp; Then I have an ArcPy deployment script that I provide to these folks that (via an administrator connection) reads the data store publisher folder location and swaps the correct folder path in the MXD before deploying to AGS.&nbsp; This works okay.</P><P></P><P>Ideally it would be grand to do the same with SDE connections.&nbsp; However as one might expect the management of the passwords is the issue.&nbsp; As the AGS administrator, one can run arcpy.ListDataStoreItems and get the SDE credentials for a given data store (only interested here in publisher).&nbsp; But the password is returned as "ENCRYPTED_PASSWORD".&nbsp; In the current security model for 10.2.2 is there any arcpy method whereby I can take that encrypted password and create a new SDE connection with it to then install into a MXD? </P><P></P><P>When using arcpy.CreateArcSDEConnectionFile_management it wants the clear text version of the password and not the encrypted text string.&nbsp; Is there a way to provide this method the encrypted string or am I just going off into dodgy security territory?&nbsp; I have no need of the actual password itself but I suppose I am moving the credential out of AGS and into the MXD (just for the deployment) and I can see that might be a tad insecure.&nbsp; However, as this is run through an AGS administrator connection I would think that is within my scope. I am not quite sure.</P><P></P><P>Any feedback would be appreciated.</P><P></P><P>Thanks,</P><P>Paul</P></BODY></HTML> Thu, 04 Dec 2014 13:00:46 GMT https://community.esri.com/t5/python-questions/copying-sde-credentials-from-arcgis-server/m-p/26346#M1967 PaulDziemiela 2014-12-04T13:00:46Z