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- Supporter
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.
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.
+22- 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- Supporter
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- Supporter
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- Supporter
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?
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- Supporter
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?
@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- Supporter
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- Supporter
@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.