https://community.esri.com/t5/python-questions/access-egdb-from-sde-regardless-of-filepath/m-p/1417864#M70508 <P>Then add an input parameter (DEWorkspace) and have the user set the database connection manually to whatever they want.</P> Wed, 01 May 2024 23:28:50 GMT BlakeTerhune 2024-05-01T23:28:50Z https://community.esri.com/t5/python-questions/access-egdb-from-sde-regardless-of-filepath/m-p/1417651#M70502 <P>I've created a python toolbox that pulls data from an enterprise GDB, defined by an SDE file.</P><P>SDE_connection = os.path.join(SDE_dir, 'mydb_database.windows.net.sde')</P><P>my_gdb = os.path.join(SDE_connection, 'my_table')<BR />arcpy.conversion.ExportTable(my_gdb, some_filepath)</P><P>This works fine, however I recently realized when trying to run this toolbox on someone else's computer that Arcpy treats os.path.join('C:\Computer1\my_project', SDE_connection, my_gdb) as being a completely different table than os.path.join('C:\Computer2\my_project', SDE_connection, my_gdb). Trying to access data from the second one results in a table not found error.</P><P>I originally created the table in the EGDB with something like: arcpy.conversion.ExportTable(csv_filepath, my_gdb)</P><P>How do I use an SDE to access data regardless of the exact filepath to the SDE?</P> Wed, 01 May 2024 17:10:21 GMT https://community.esri.com/t5/python-questions/access-egdb-from-sde-regardless-of-filepath/m-p/1417651#M70502 sbrowneotogo 2024-05-01T17:10:21Z https://community.esri.com/t5/python-questions/access-egdb-from-sde-regardless-of-filepath/m-p/1417691#M70504 <P>One way is to put a copy of the SDE connection file on a network drive that everyone has access to, then use the full network path to that SDE connection file as input to the toolbox.</P><P>R_</P> Wed, 01 May 2024 18:10:07 GMT https://community.esri.com/t5/python-questions/access-egdb-from-sde-regardless-of-filepath/m-p/1417691#M70504 RhettZufelt 2024-05-01T18:10:07Z https://community.esri.com/t5/python-questions/access-egdb-from-sde-regardless-of-filepath/m-p/1417740#M70505 <P>If everyone is using the same database connection and it's not changing often, maybe you can <A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/create-database-connection.htm" target="_self">create the database connection</A> in the script when it's run? Just output to a <A href="https://docs.python.org/3/library/tempfile.html" target="_self">temp directory</A> that will get cleaned up when the script finishes. Or you can try a <A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/create-database-connection-string.htm" target="_self">database connection string</A> instead of using .sde files.</P> Wed, 01 May 2024 19:35:49 GMT https://community.esri.com/t5/python-questions/access-egdb-from-sde-regardless-of-filepath/m-p/1417740#M70505 BlakeTerhune 2024-05-01T19:35:49Z https://community.esri.com/t5/python-questions/access-egdb-from-sde-regardless-of-filepath/m-p/1417858#M70506 <P>The problem is we need to pull data from the GDB to the users workspace when the tool runs, so they can't just create a new one each time. We all need to be accessing the same table. I'm trying out using a database connection string but unable to figure out how to create a GDB with a connection string.</P> Wed, 01 May 2024 23:04:35 GMT https://community.esri.com/t5/python-questions/access-egdb-from-sde-regardless-of-filepath/m-p/1417858#M70506 sbrowneotogo 2024-05-01T23:04:35Z https://community.esri.com/t5/python-questions/access-egdb-from-sde-regardless-of-filepath/m-p/1417864#M70508 <P>Then add an input parameter (DEWorkspace) and have the user set the database connection manually to whatever they want.</P> Wed, 01 May 2024 23:28:50 GMT https://community.esri.com/t5/python-questions/access-egdb-from-sde-regardless-of-filepath/m-p/1417864#M70508 BlakeTerhune 2024-05-01T23:28:50Z