Skip to main content
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?

 

 

 

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!
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
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?

 


Reply