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:
- 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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
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