Skip to main content
  • EN
I would like to know how to do the following operation with FME Server:

 

 

I have an Oracle table from which I want to read some records with a given field value. I want to use an Oracle Spatial Reader with SQL query. I want to implement it with FME Server, and I want the user to enter the field value, which is used in the SQL query. 

 

An example: At the Oracle Spatial table there is a field called "selector". I would like to create a schema with an Oracle reader with an SQL query.

 

 

Select * from table_name

 

Where selector = XXX

 

XXX=is the value the user enter in order to activate the server schema,

 

Thanks.
First thing to do is create a published parameter called “selector_value’:

 

 

When you run your workspace on the FMEServer, you can set it up so your user will be prompted to enter a value for the selector_value.

 

 

In your reader where statement set it up like below so the statement uses the parameter value:

 

Selector = ‘$(selector_value)’

 

 

Then that should read only the features with the selector_value.

Reply


Community Stats

30,108
Posts
114,295
Replies
37,744
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.