I want to load all the dbf files under a folder into an Oracle database, each creating a new table. Attached is workspace I created, but it gives an error that the schema is not defined for the writer. This can be easily done using ESRI arcpy, so should be easy in FME.
Solved
Batch load dbf files into Oracle failed
+11- Contributor
Best answer by fmelizard
Hi @ag, can you try with "Dynamic Schema Definition" enabled on the the Writer Feature Type? The FeatureReader will output a schema feature that should be linked to the Feature Type.
+19- Safer
- Best Answer
Hi @ag, can you try with "Dynamic Schema Definition" enabled on the the Writer Feature Type? The FeatureReader will output a schema feature that should be linked to the Feature Type.
+11- Contributor
fmelizard wrote:
Hi @ag, can you try with "Dynamic Schema Definition" enabled on the the Writer Feature Type? The FeatureReader will output a schema feature that should be linked to the Feature Type.
The log says 35 features are written, but ANKOR table is not created at all.
+11- Contributor
fmelizard wrote:
Hi @ag, can you try with "Dynamic Schema Definition" enabled on the the Writer Feature Type? The FeatureReader will output a schema feature that should be linked to the Feature Type.
+11- Contributor
fmelizard wrote:
Hi @ag, can you try with "Dynamic Schema Definition" enabled on the the Writer Feature Type? The FeatureReader will output a schema feature that should be linked to the Feature Type.
Could this be a bug in FME 2017.1?
fmelizard wrote:
Hi @ag, can you try with "Dynamic Schema Definition" enabled on the the Writer Feature Type? The FeatureReader will output a schema feature that should be linked to the Feature Type.
+11- Contributor
takashi wrote:
The schema feature will be output from the <Schema> port of the FeatureReader. Have you connect between the <Schema> port and the writer feature type?
aguan wrote:
@takashi, not sure how to do this. Can you show a screen shot what it looks like? The dbf table rows only come from the Generic port, so I can only connect the Generic port to the writer feature type.
+11- Contributor
takashi wrote:
@TiaAtSafe's screenshot exactly illustrates my intention.
+11- Contributor
fmelizard wrote:
Hi @ag, can you try with "Dynamic Schema Definition" enabled on the the Writer Feature Type? The FeatureReader will output a schema feature that should be linked to the Feature Type.
+11- Contributor
aguan wrote:
@TiaAtSafe and @takashi, your advice works great with dynamically loading dbfs into an Oracle DB. I applied exactly the same method to loading shape files dynamically to an ArcSDE geodatabase, but it does not work. The error is "Unable to find the schema definition 'ROWPIPE' for feature with feature type name 'ROWPIPE'. Ensure the feature type name is correct and that its schema definition exists in the schema source". See attached template.gom3-shape2sde-test.fmwt
Ok, it works if the shape files are in upper cases or removing the upper case for feature type name in the dynamic writer in which case the loaded SDE feature class name will be in the same case as the shape file name.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.