replace Username/Password with SDE connection

kapalczynski

 

I am currently doing the below

 

from arcgis.gis import GIS
import arcgis
gis = GIS('https://xyz.maps.arcgis.com', agol_username, agol_password)

 

 

But I do not want to hard code the Username and Password in the script

Can I do something like point to an SDE connection?

I want a way to HIDE the credentials

 

from arcgis.gis import GIS
import arcgis
gis = GIS('https://xyz.maps.arcgis.com', '\\DatabaseConnections\conectionfile.sde)

 

Or add in a workspace for this?

 

arcpy.env.workspace = "C:\\Users\\GIS_projects\\Python\\Test@EDIT.sde"

 

Jen_Zumbado-Hannibal

@kapalczynski  I piecemeal solutions from different sources; you might want to check them out. 

 

• https://community.esri.com/t5/arcgis-api-for-python-questions/unable-to-protect-credentials-by-storing-them/m-p/810024#M2424

 

• I also would like to add that to set a password using keyring I ran Python Interactive Terminal (C:\Program Files\ArcGIS\Pro\bin\Python\Scripts\propy.bat) and followed the instructions on this video https://www.youtube.com/watch?v=lLMhq3c_YQk.

This is what I came up with: 

 

import keyring
from arcgis.gis import GIS
from arcgis.gis.server import Server

# Specify the name of the profile
profile_name = "GIS_Admin"  # Replace with your profile name

# Get username and password stored in keyring

credentials = keyring.get_credential("keyring_portaladmin", username=None)
vusername = credentials.username
vpassword = credentials.password

# Connect to the ArcGIS Portal using the specified profile
gis = GIS(url="https://your.domain.com", username=vusername, password=vpassword,profile=profile_name)

# Check if the connection is successful
if gis:
    print("Connected to ArcGIS Portal as '{}'.".format(gis.properties.user.username))
else:
    print("Failed to connect to ArcGIS Portal.")