Skip to main content
Question

SQL definiton conversion from ArcPro to FME

  • May 29, 2026
  • 1 reply
  • 32 views
marta.podsiad
Supporter
Forum|alt.badge.img+10

Hi,

I have a file geodatabase (.gdb) containing feature classes, along with an Excel file that includes ArcGIS Pro SQL definition queries intended for specific feature classes.

Example:

 

gdb with feature classes

 

ArcPro definition query

Schema = '1' And Rodzaj NOT LIKE '%B%'

 

I’d like to understand how I can automatically convert these ArcGIS Pro SQL queries into FME SQL syntax. The queries will vary each time and are tailored to individual feature classes.

 

This SQL works in FeatureReader but it requires a lot of manual work 

 

 

    1 reply

    hkingsbury
    Celebrity
    Forum|alt.badge.img+71
    • hkingsburyCelebrity
    • Celebrity
    • June 2, 2026

    The underlying isssue here appear to be that you’re not specifying the featureclasses from the GDB to read, therefore you’re needing to specify the table qualifier in the where clause, so the reader knows where to look for those fields.

    I can see two approaches here (assuming you need to dynamically specify the Feature Type/featureclass):

     

    1. ensure that the excel sheet has the featureclass (in a separate column) each sql query relates to. Then you can read in that sheet, using the column the featureclass is in to populate the ‘Feature Types to Read’ parameter in the FeatureReader and the SQL to populate the ‘WHERE Clause’ parameter.
    2. Break down the sql WHERE into each component and prefix the column qualifier with the required table qualifier.

     

    I’d heavily lean towards #1 as that is a more FME Dynamic process centric approach. With #2 you’d risk incorrectly breaking down the WHERE clause unless you over engineered the logic to ensure you’re breaking it apart and rebuilding it correctly. 

    Community Stats

    32,661
    Posts
    123,952
    Replies
    41,090
    Members
    Terms & ConditionsAccessibility statement
    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.