Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Authoring
  • Any way to have a FeatureReader (ESRI Legacy) to read a DBMS JOIN the same way it is possible directly from a Reader?

I already use Readers (ESRI Legacy) to "merge" tables based on a relation condition. This can be done by adding the SDE30_IDs clause to the mapping file. (Since it's not supported in Workbench)

Since Readers and FeatureReaders seems to use the same underlying libraries, would it be possible to do the same thing at the FeatureReader level. This would allow flexible and efficient way to retrieve data since a more complex conditional clause could be built along the transformers way.

Thanks,

Mathieu

At the moment (FME 2017 and earlier) FeatureReader does not support select or where clauses for individual feature types. is not possible with any of the database readers. Regarding Esri Legacy (SDE) - it is very unlikely that any further development work will be done in FME on this format since it has been deprecated by Esri.

At the moment (FME 2017 and earlier) FeatureReader does not support select or where clauses for individual feature types. is not possible with any of the database readers. Regarding Esri Legacy (SDE) - it is very unlikely that any further development work will be done in FME on this format since it has been deprecated by Esri.

Hi @markatsafe, I'm trying to do the same with having multiple feature types in FeatureReader with different WHERE condition for each of the FeatureType.

I've tried this FME 2019, but looks like not feasible. Is this supported in FME 2020 ?

 

Thanks!

Hi @markatsafe, I'm trying to do the same with having multiple feature types in FeatureReader with different WHERE condition for each of the FeatureType.

I've tried this FME 2019, but looks like not feasible. Is this supported in FME 2020 ?

 

Thanks!

@fmeuser_gc Sorry - this has not yet been addressed in 2020

Hi @markatsafe, I'm trying to do the same with having multiple feature types in FeatureReader with different WHERE condition for each of the FeatureType.

I've tried this FME 2019, but looks like not feasible. Is this supported in FME 2020 ?

 

Thanks!

@fmeuser_gc Sorry - access to Feature Type parameters, like the WHERE clause, has not yet been addressed in FME 2020

@fmeuser_gc Sorry - access to Feature Type parameters, like the WHERE clause, has not yet been addressed in FME 2020

@markatsafe - Do you know atleast if this functionality is being considered for the next releases?

@markatsafe - Do you know atleast if this functionality is being considered for the next releases?

@fmeuser_gc it is not currently on the release schedle - you might add a vote here and a comment on why the existing FeatureReader does not meet your needs.

Reply


Community Stats

30,159
Posts
114,479
Replies
37,803
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.