I tried pasting my SQL command in the feature reader, but it keeps bringing in everything from that database or schema.
Question
Hi, I have a non spatial SQL command that I want to use in FME. Is there a way to plug it in without 1. making it a view in SSMS, or 2. without using a sql executor transformer?
+10- Contributor
In a reader you can use the where box to limit the features you want by a where SQL statement:
For example, if I had a SQL ArcSDE I could go something like this in my reader:
##Example of nonspatial query; query by attributes on road_ln (feature class)
##Give me features where the field PLAN_AUTH is equal to Organization value or where my PLAN_ROUTE_DSGNTN is equal to ORG Road.
where "PLAN_AUTH"='Organization' OR "PLAN_ROUTE_DSGNTN"='ORG Road'What is the SQL statement you are trying to execute?
*Note: If you are using a featureReader it is sometimes helpful to use the option: single output and then use the <generic> output and bring in the attributes you need via an attribute exposer after the fact.
My command is more complicated than that, so this will not work. However, I am now able to do it using SQLCreator instead.
SQL Executor requires a reader where by SQLCreator does not. With SQLCreator, I can use plug my whole command in and it will run. At least this is how I understood it.
+47- Celebrity
SQL Executor requires a reader where by SQLCreator does not. With SQLCreator, I can use plug my whole command in and it will run. At least this is how I understood it.
Ah right - You can also start a workspace with a Creator transformer. an SQLCreator is similar to having a Creator > SQLExcecutor.
The Creator is a very helpful transformer.