• Home
  • Forums
  • FME Form
  • General
  • Read directory of SDE connection files and list database and all feature classes, tables, etc. to create an inventory
Question

Read directory of SDE connection files and list database and all feature classes, tables, etc. to create an inventory

  • 20 April 2023
  • 5 replies
  • 66 views
jonvelco
Rank

My goal is to read a directory of SDE connection files and then list out the database name and all the feature class names, tables, geometry types, etc. associated with each connection file.

 

I've reviewed the articles below and can't figure out how to set the Feature Types to Read parameter since it only shows tables/feature classes from the one Reader as a Resource SDE connection. This isn't an issue if there is only one database but when there are multiple (like what I'm trying to do), it doesn't seem to work. Is this possible or is there another way to get this info?

 

Here are the articles I've been using:

https://community.safe.com/s/article/how-to-read-all-feature-classes-from-multiple-esri

 

https://community.safe.com/s/question/0D54Q000080hHCASA2/read-multiple-sde-connect-file

 

https://community.safe.com/s/question/0D54Q00008qzlJhSAI/how-to-dynamically-read-entire-schema-of-sde-geodatabase

 

 

 

5 replies

hkingsbury
Rank
Userlevel 5
Badge +29

The way i'd approach it is using a FeatureReader with the directory being c:\\temp\\*.sde (read all files ending in SDE in that folder) then set the FeatureReader to only read the schema and process the output schema from there into the required format

Check out the Abley FME Firesides on Youtube: https://www.youtube.com/@ableyltd
jonvelco
Rank

@hkingsbury​ if I use the FeatureReader like you suggested, you have to set the Format to something.  I tried the Schema (Any Format) option but results in this:

Generic Reader: Unable to guess a valid reader name from dataset '<name of SDE connection file>.sde'. A NULL reader will be used instead.

If you set the Format to SDE, then you can only set it to 1 SDE connection file AND you have to set the Feature Types to Read.

 

Any other ideas?

hkingsbury
Rank
Userlevel 5
Badge +29

@hkingsbury​ if I use the FeatureReader like you suggested, you have to set the Format to something.  I tried the Schema (Any Format) option but results in this:

Generic Reader: Unable to guess a valid reader name from dataset '<name of SDE connection file>.sde'. A NULL reader will be used instead.

If you set the Format to SDE, then you can only set it to 1 SDE connection file AND you have to set the Feature Types to Read.

 

Any other ideas?

You'll still need to set the FeatureReader as SDE, but just enable the read only schema optionimage.png 

As I think more about this problem I realise that you can't then use a wild card as a feature type to read in the feature classes.

 

Attached is an example workspace that firstly uses ArcPy to get all the FCs in the SDE connection, then passes them through to a FeatureReader(SDE) to get the schema. You could also achieve the same with and SQLExecuter, but unsure if you have direct SQL access to the underlying DB

 

Check out the Abley FME Firesides on Youtube: https://www.youtube.com/@ableyltd
jonvelco
Rank

You'll still need to set the FeatureReader as SDE, but just enable the read only schema optionimage.png 

As I think more about this problem I realise that you can't then use a wild card as a feature type to read in the feature classes.

 

Attached is an example workspace that firstly uses ArcPy to get all the FCs in the SDE connection, then passes them through to a FeatureReader(SDE) to get the schema. You could also achieve the same with and SQLExecuter, but unsure if you have direct SQL access to the underlying DB

 

Thanks for the workbench. This works for 1 SDE connection but I'm trying to run an entire folder of them. The current Connection File user parameter only allows 1 selection - is there a way to use a wildcard like  c:\\temp\\*.sde instead?

gogopotter90
Rank
Badge +13

You'll still need to set the FeatureReader as SDE, but just enable the read only schema optionimage.png 

As I think more about this problem I realise that you can't then use a wild card as a feature type to read in the feature classes.

 

Attached is an example workspace that firstly uses ArcPy to get all the FCs in the SDE connection, then passes them through to a FeatureReader(SDE) to get the schema. You could also achieve the same with and SQLExecuter, but unsure if you have direct SQL access to the underlying DB

 

Hello ,

thanks for ur workspace .

i have used it but I have found that the output of Python caller has not all feature classes .

could I ask if there is a reason for that ? Why did it read most of feature classes but not all of them ?

Reply


Community Stats

28,700
Posts
109,456
Replies
36,549
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.