idea Use ArcPy to Determine Underlying Database in ArcGIS Enterprise Ideas

Use ArcPy to Determine Underlying Database

AndrewChapkowski — Thu, 28 Aug 2014 17:06:14 GMT

It would be nice if the arcpy Describe function would return the database name you are connected to.

For example:
>>> print arcpy.Describe(r"c:\temp\scratch.gdb").databaseName
File Geodatabase
>>> print arcpy.Describe(r"c:\temp\someconnection.sde").databaseName
Oracle
>>> print arcpy.Describe(r"c:\temp\someconnection.sde").databaseName
PostGRESql

etc...

This would really help in developing the slight SQL differences between databases in handling of specific datatypes.

Thank you

Re: Use ArcPy to Determine Underlying Database

MatthewYager — Tue, 14 Oct 2014 11:02:10 GMT

For your examples you could craft a routine to tell you this information
anything ending in a gdb will be file geodatabase
do a describe on a sde connection and look at the instance will tell you that database it is based on the connection string e.g.

sde:sqlserver:svr-gis-01 is SQL server
sde:oracle11g:GISDATA is Oracle 11g

desc = arcpy.Describe(Database Connections\Localhost SQL.sde)
cp = desc.connectionProperties
print cp.instance
> sde:sqlserver:svr-gis-01

The only issue I see are the old style SDE connection where the instance will be a port number.

Re: Use ArcPy to Determine Underlying Database - Status changed to: Closed

MaggieBusek — Wed, 12 Apr 2023 17:52:40 GMT