I'm looking for some help to use SQL in 'where clauses' for FME Readers.
I'm trying to read from an ArcSDE database, using SQL operations like GROUP BY or DISTINCT. But I am under the impression that ArcSDE is not compatible with more complex statements than the simple terms like: equals/is null/not null/ in range / and so on.
On the documentation page I read however: "Enter any SQL where clause that constrains the attributes of the layers selected in the layer list."
I have found the SQLCreator and SQLExecutor transformers, however these do not support ArcSDE format.
I'm starting to think that the ArcSDE format simply does not suppport 'advanced' SQL querying in FME. Is this correct?
So far I have found 1 alternative: a PythonCaller using these ArcSDESQLExecute functions from ArcPy.
Could someone tell me if this is indeed the only workaround? Are there other workarounds? I've not found any further documentation on this topic, perhaps someone else has some useful references for me?
