topic Re: get path of sde file in ArcGIS Pro SDK Questions

get path of sde file

LaurentiuIchim2 — Wed, 07 Jun 2017 13:55:33 GMT

Hello for all,
I have a problem and please help me.
I need to get path of sde file for enterprise geodatabase.

Up to 1.3 version for ArcGIS Pro, the Geodatabase class had GetPath() method which returned path for Geodatabase (File Geodatabase, Enterprise Geodatabase and so on) .

Starting with 1.4 version this method is depricated (and return empty string) and it's recomended to work with Conector and appropriate class (DatabaseConnectionFile, DatabaseConnectionProperties and so on)

I need to get path of sde file (Enterprise Geodatabase), but Connector is not DatabaseConnectionFile.
When Geodatabase is Enterprise, the Connector is only DatabaseConnectionProperties-type.
But DatabaseConnectionProperties does not allow to get path of sde file.

(_table.GetDatastore() as Geodatabase).GetConnector() is DatabaseConnectionFile is false

How can I get the path of sde file?

Thanks all,
Laurentiu Ichim

Re: get path of sde file

ColinZwicker — Wed, 07 Jun 2017 19:25:41 GMT

Laurentiu,

Could you please expand on the workflow where you require a connection file for an existing enterprise geodatabase connection?

Thanks,

Colin

Re: get path of sde file

LaurentiuIchim2 — Thu, 08 Jun 2017 06:04:14 GMT

Hello sir,

Yes, I do!

On the workflow, I need to run a python script. For this python script, I need to send path of particular table (like this @"F:\PROIECTE\Utilitati\Pro\Date\Utilitati1\database.sde\utilitati.SDE.Documente").

Why run a python script?

I need to insert various files into BLOB field of <utilitati.SDE.Documente> table.

Working with attachment file of Geodatabase does not cover the particular functionality.

In other words:

1. I have a table with a BLOB field:

Table documentTable = standaloneTable.GetTable();

2. I have a python script which insert file into table (table of point 1)

3. In the ArcGIS Pro Add-In, I have a ExecuteToolAsync(...) which call python script (script of point 2)

var parameters = Geoprocessing.MakeValueArray(
@"C:\Users\lichi_000\Pictures\eu1.jpg",
@"F:\PROIECTE\Utilitati\Pro\Date\Utilitati1\dataweb@utilitati@sde.sde\utilitati.SDE.Documente",
foreignKey,
extension,
dateTime,
no,
author
);
var result = await Geoprocessing.ExecuteToolAsync(@"F:\PROIECTE\Utilitati\Pro\scripturi\Utilitati.tbx\Insert0", parameters);

4. The <@"F:\PROIECTE\Utilitati\Pro\Date\Utilitati1\dataweb@utilitati@sde.sde\utilitati.SDE.Documente"> parameter of point 3 is documentTable object of point 1

Thank you very much,

Laurentiu Ichim

Re: get path of sde file

GKmieliauskas — Thu, 15 Jun 2017 14:39:34 GMT

Laurentiu,

I had the same problem with sde file path. I have made workaround:

1. Read all project geodatabases using Project.Current.GetItems<GDBProjectItem>().

GDBProjectItem contains Path property.

2. Read connection properties from your table object (pTable.GetDatastore().GetConnector() as DatabaseConnectionProperties).

3. Check all GDBProjectItem's from 1 step by comparing connection properties (item.GetDatastore().GetConnector() and try cast to DatabaseConnectionProperties). Equal method does not work for Connector or DatabaseConnectionProperties objects, so you need to check all DatabaseConnectionProperties object properties (DBMS, Database, Instance and etc.) one by one.

I hope it helps you

Gintautas

Re: get path of sde file

ColinZwicker — Thu, 22 Jun 2017 19:16:55 GMT

Laurentiu, (and Gintautas)

This issue has sparked a lot of discussion between teams since its original posting. Giantautas's workaround is valid if a matching connection file exists (including the correct version). However the edge case that no matching file exists anywhere is still problematic and is the reason GetPath was deprecated. We will work towards a resolution to this in a future release with your workflow in mind.

On a similar note the requirement to use a custom gp script for blob manipulation should be removed with the native core.Data support of blobs via memoryblobstreams in the ArcGIS Pro 2.0 timeframe.

Thanks,

Colin

Re: get path of sde file

LaurentiuIchim2 — Fri, 23 Jun 2017 06:35:29 GMT

Thank you very much sir Gintautas. Isn't a solution for me. The geoprocessor object wait path for processing input (as parameters). The DatabaseConnectionProperties class isn't solution for me.

Thank you very much for your answer!

Re: get path of sde file

LaurentiuIchim2 — Fri, 23 Jun 2017 06:43:57 GMT

Good afternoon,

The suport of blobs for version 2.0 it's a really good news.

Thank you sir for your answer,

Laurentiu

Re: get path of sde file

GKmieliauskas — Fri, 23 Jun 2017 07:11:07 GMT

Laurentiu,

You must use DatabaseConnectionProperties only to find right geodatabase from 1 step. Then you need to read Path property from GDBProjectItem. It contains full path to sde file. I can send you detailed source code sample if you need.

Re: get path of sde file

LakshmiAlaparthi — Wed, 16 Jun 2021 00:37:26 GMT

Hi Gintautas

Re: get path of sde file

MarvisKisakye1 — Thu, 22 Jul 2021 00:07:05 GMT

@GKmieliauskas are you able to post the code on how you retrieve the full correct sde path?

Re: get path of sde file

GKmieliauskas — Thu, 22 Jul 2021 06:26:58 GMT

Hi,

Situation with ArcGIS Pro SDK has changed since 2017.

We have used workaround with adding database to project Catalog-Databases. Then we checked database connection properties with all databases added to Catalog-Databases. On right one we used GDBProjectItem Path property to get right sde file path.

All registered to project databases you can get using code:

IEnumerable<GDBProjectItem> projectDatabases = Project.Current.GetItems<GDBProjectItem>();

We do not use this way now. We are trying to work without sde file path or save it to project as settings.

The copy of sde file you can get by calling GetPath from Geodatabase object.

Could you explain why do you need right sde file path? Maybe I will suggest you a way how to avoid sde file path.

Re: get path of sde file

MarvisKisakye1 — Thu, 22 Jul 2021 17:16:12 GMT

@GKmieliauskas I need to create a relationship class using the geoprocessing module since the ddl module can't do it. I need to let the tool know what the path to the relationship class is.

var tName = table.GetName(); var rlcName = $"{ValidateMemberName(tName)}_HTE"; var rlcpath = System.IO.Path.Combine(gdb.GetPath().LocalPath, rlcName); var originTable = gdb.OpenDataset<Table>(tName); var destTable = gdb.OpenDataset<Table>(etTableName); var originPrimaryKey = originTable.GetDefinition().GetObjectIDField(); var k=Geoprocessing.ExecuteToolAsync("CreateRelationshipClass_management", Geoprocessing.MakeValueArray(originTable, destTable, rlcpath, "SIMPLE", ForwardPathLabel, BackwardPathLabel, "NONE", "ONE_TO_MANY", "NONE", originPrimaryKey, originForeignKey));

Re: get path of sde file

GKmieliauskas — Thu, 22 Jul 2021 18:56:58 GMT

Have you tried to execute CreateRelationshipClass tool from ArcGIS Pro? Run the tool then go to History and right click mouse on CreateRelationshipClass record and select Copy Python Command from context menu.

Paste content to Notepad and check Python script for relationship class path parameter.

Re: get path of sde file

MarvisKisakye1 — Mon, 26 Jul 2021 18:16:00 GMT

@GKmieliauskas yes I have. It still shows me the temporary/local path of the sde file which won't work in the pro sdk.

Re: get path of sde file

GKmieliauskas — Wed, 28 Jul 2021 13:36:53 GMT

It seems like a bug. I would recommend to start new thread in ArcGIS Pro SDK. Maybe some from Esri could help you.