Skip to main content
Solved

Extract data from a database to a csv file and upload to s3

  • April 12, 2017
  • 4 replies
  • 84 views

New to FME. I roughly know the first half, i.e. extract data to csv file is simple. But how to get the csv writer to trigger the next step of the workflow to upload it to s3 bucket? The writer has no output.

Thanks!

Best answer by david_whiteside

You could use FeatureWriter which has output ports to trigger an S3 uploader when successful.

 

 

FeatureWriter is a transformer that works just like a writer but allows for the continuation of the workbench

 

 

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.

4 replies

david_r
Celebrity
  • April 12, 2017

The easiest is to have two workspaces.

Workspace 1:

  • Creator
  • WorkspaceRunner to execute workspace 2
  • S3Uploader

Workspace 2:

  • Read from database
  • Write to CSV

Forum|alt.badge.img
You could use FeatureWriter which has output ports to trigger an S3 uploader when successful.

 

 

FeatureWriter is a transformer that works just like a writer but allows for the continuation of the workbench

 

 


david_r
Celebrity
  • April 12, 2017
You could use FeatureWriter which has output ports to trigger an S3 uploader when successful.

 

 

FeatureWriter is a transformer that works just like a writer but allows for the continuation of the workbench

 

 

Agreed, great solution. Even easier than using the WorkspaceRunner.

  • Author
  • April 19, 2017

Thank you both David. Gonna give it a go.