Skip to main content
Question

Oracle Non Spatial Reader to CSV Writer

E
I'm relatively new to FME, so any help here would be greatly appreciated.

 

I can link to a SQL server to pull specific information from a table. However, I don't have write-access to the server, so I want to save the results of my SQL query in a CSV file. I've tried just doing a Reader of Oracle Non Spatial to a Writer of CSV. It reads the data fine, but nothing actually gets copied into the CSV File; it is just an empty file.

 

I'm obviously missing something here. Can anyone help? Much obliged!

3 replies

fmelizard
Contributor
Forum|alt.badge.img+17
  • fmelizardContributor
  • Contributor
  • July 9, 2013
Hi,

 

 

Are the attributes of your reader schema present on the csv writer?

 

You can quickly copy the input attributes by right click on the writer> copy atribute from feature ....(select your input feature type)
fmelizard
Contributor
Forum|alt.badge.img+17
  • fmelizardContributor
  • Contributor
  • July 9, 2013
Optionally you can set the translation to dynamic and not worry about attributes any more....
E
  • erin
  • Author
  • July 9, 2013
Ah, brilliant! That was the piece I've been missing. Thanks so much!

Reply


Most helpful members this week

Community Stats

30,845
Posts
116,934
Replies
38,666
Members
Terms & ConditionsCookie settings

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
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.