Skip to main content
Is there any way to easily switch Oracle Spatial reader to read from another similar (ie. replica) table - than to rewrite to whole reader part ?

 

This would ease my job a lot as I have several FME wb's with input data filtering (to reduce memory usage) from the same source data.

 

 

Rgrds, Esko
In FME 2014, you can specify a different Oracle database via:

 

 - In the left-hand side within the Navigator, locate the Oracle Reader denoted by a brown cylinder with a green arrow going out.

 

- Expand the Reader by double clicking on it

 

- Expand the Parameters cog by double clicking on it

 

- Double click on the "Source Oracle Service" and configure it as desired

 

- Test workspace

 

 

To specify a different Oracle table for your workspace:

 

In FME 2014, you can specify a different Oracle database via:

 

- In the left-hand side within the Navigator, locate the Oracle Reader denoted by a brown cylinder with a green arrow going out.

 

- Expand the Reader by double clicking on it

 

- Expand the Parameters cog by double clicking on it

 

- Expand the Advanced cog by double clicking on it

 

- Double click the "Feature Types to Read"

 

- Choose which table to read

 

- Double click on the Feature Types cog just below the "Feature Types to Read" cog

 

- Right click on the Oracle table you wish to change

 

- Select Properties

 

- Ensure the "Merge Feature Type" is checked

 

- Set a "Merge Filter" of *

 

- Click OK

 

- Test workspace

 

 


Reply