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
Solved
I need to change table in Oracle reader, but how (FME dt 2014)
+2Is there any way to easily switch Oracle Spatial reader to read from another similar (ie. replica) table - than to rewrite to whole reader part ?
Best answer by kathyross
In FME 2014, you can specify a different Oracle database via:
View original- 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
<strong>This post is closed to further activity.</strong><br />
It may be a question with a best answer, an implemented idea, or just a post needing no comment.<br />
If you have a follow-up or related question, please <a href="https://community.safe.com/topic/new">post a new question or idea</a>.<br />
If there is a genuine update to be made, please contact us and request that the post is reopened.
+4In 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
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.