Skip to main content
Archived

Change FeatureReader/Writer behaviour to only re-read DB info when necessary

Related products:Transformers
  • April 20, 2017
  • 2 replies
  • 60 views

nic_ran
Contributor
Forum|alt.badge.img+20

Many settings on the FeatureReader/Writer transformers are format agnostic (e.g. the transformer name). It would be great if the transformers could be configured to NOT re-read from database connections when these types of settings are changed.

I almost always pass in my connection details as attributes or published parameter values so having to navigate the file system to find an SDE connection file, or specify a database connection each time I make a minor change to the transformer settings is frustrating. It's a minor inconvenience, I know, but just one of the "little things" that I think could be easily fixed.

I used to be able to work around this in many cases by editing the settings directly in the Navigator pane but in FME 2017 this option has been removed as the settings are more tightly integrated with the transformer.

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.

2 replies

Another example: I have a FeatureReader for a SQL Server database table ("myTable") using a database connection ("mySqlServer"). The database connection is only valid on a Production server, but I need to make some edits locally before republishing to the server.

If I change the WHERE clause in the FeatureReader, FME Desktop tries to connect to the database, fails, then decides that feature type "myTable" is no longer valid, so the transformer loses its output port.

Another example: I want to change my database connection from "myConnectionA" to "myConnectionB". Is there really a need to connect to the database and re-read all the valid tables names?


revesz
Supporter
Forum|alt.badge.img+21
  • Supporter
  • April 5, 2019

Correct point. I feel quite patronising when the FeatureReader wants to supervise me when it is totally unnecessary and it just takes time to find a sample datasource. I really miss a "Schema not changed" or similar button/functionality.