Skip to main content
Question

Dynamic Writer

  • September 27, 2013
  • 3 replies
  • 34 views

Hi,

 

I have a doubt about FME.

 

I have a reader that reads a .mdb Geomedia , and a Writer to put the .mdb data into an Oracle Database.

 

The problem is: I have to create in the writer manually , all the attributes that I want to see in the oracle.

 

I would like to know if there is a way to make this dynamicly.

 

Without going into the writer and typing all the information.

 

I want the same attributes from the reader in the writer without typing the information.

 

Is there some way?

 

 

 

3 replies

davideagle
Contributor
Forum|alt.badge.img+21
  • Contributor
  • September 27, 2013
Either right click on the source featuretype and duplicate on writer and then remove the attributes you don't need. Or if the schema you want to copy is elsewhere then use the Writer drop down menu and "Import FeatureType" and this will allow you to copy the required schema onto your target writer without having to manually type each attribute name and set the datatype!

fmelizard
Safer
Forum|alt.badge.img+19
  • Safer
  • September 27, 2013
Try generating a ws in dynamic mode, that will read the input schema and apply it to the output. Search fmepedia for more info about dynamic translations

  • Author
  • September 30, 2013
Thanks everibody for the help about my problem with the writer.

 

But now, i have another doubt.

 

And, for this, i dont know unfortunately how to begin.

 

I have been building one fluxogram.

 

In that fluxogram, i have a reader that reads a .mdb Geomedia , and a Writer to put the .mdb data into an Oracle Database.

 

Between both, there is just one Geometry filter and three reprojectors.

 

That reprojectors exists in order to separate line, area and point.

 

When it is added to the database. He is renamed to GEO_AREA or GEO_LINHA or GEO_POINT.

 

 

 

Well, i can insert the data into an oracle database.

 

But, the geomedia metadata still have to be inserted  manually.

 

So, the problem now is: I have to insert the metadata from gdosy dynamically in order to show either the data in oracle as the feature in the Geomedia in just one fluxogram.

 

I tried to insert three transformers (Creator, Atribute Creato and SQL_Executor). But, without satisfactory results.

 

 

 

Could you help me?

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings