Skip to main content
Solved

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


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

 

 

View original
Did this help you find an answer to your question?

4 replies

david_r
Evangelist
  • 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
Evangelist
  • April 12, 2017
david_whiteside wrote:
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.


Reply


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