Skip to main content
Solved

Use existing Oracle table schema for writing into csv

  • October 4, 2024
  • 3 replies
  • 81 views
stuart_miso
Contributor
Forum|alt.badge.img+9

I have a whopping great big table in my workbench with 2100 attribute fields in it! 😯

The data originates from JSON files, and I need to write it into several csv files.

The csv files need to pick up the schemas of tables in an Oracle db. These tables have a couple of hundred attribute fields / columns in, so many of my attribute fields will be dropped from the massive table in the workbench when creating the csv. This is good!

The Oracle tables do not feature in the workbench at all, so I just need to grab the schema of the existing tables, bring them into the workbench, and use them in the csv writers.

I’ve tried to use Schema Scanner, and Schema Mapper but with no luck. I am sure the answer must be really simple and I am doing something wrong.

Any help will be much appreciated.

Stuart

Best answer by nielsgerrits

In a FeatureWriter, you can set the target format to CSV, then import the schema from a different source by choosing “Import from Dataset...” You can then select source files.

 

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.

3 replies

nielsgerrits
VIP
Forum|alt.badge.img+62
  • nielsgerritsVIP
  • Best Answer
  • October 4, 2024

In a FeatureWriter, you can set the target format to CSV, then import the schema from a different source by choosing “Import from Dataset...” You can then select source files.

 

Buckle your seatbelt Dorothy, cause Kansas is going bye-bye...
geomancer
stuart_miso
Contributor
Forum|alt.badge.img+9
  • stuart_misoContributor
  • Author
  • Contributor
  • October 4, 2024

Thank you Niels, that is just what I am looking for, and it works perfectly. 😁

nielsgerrits
VIP
Forum|alt.badge.img+62

Cheers!

Buckle your seatbelt Dorothy, cause Kansas is going bye-bye...

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.