Upload CSV file to server, trigger ETL job to load the contents to DB

Highlighted
One Star

Upload CSV file to server, trigger ETL job to load the contents to DB

I am new to Talend Open Studio and have been playing with it for a week or so. Please excuse me for my lack of knowledge. 
Problem Statement: I have a CSV file (~5GB) in my local drive. I have to load the contents of the CSV to a DB table sitting in a remote server. The access to the server is restricted via domain check, so I cannot run my job on my local machine to load the file. It will have to run on a job server in the trusted domain. Also, I won't be allowed to manually drop the file in the job server. I have to use a web interface to drop the file there. How can I achieve this?
CSV file needs to be uploaded to a server via http. And once the file upload is complete, I need to trigger an ETL job to load the uploaded file contents to DB tables. A good to have feature is to respond back with to the user (me) with the status of the job completion.
Many Thanks,
Jc.
Four Stars

Re: Upload CSV file to server, trigger ETL job to load the contents to DB

Hi jc, i'm jcs, an upgrade of you lol (just kidding)
You can try to capture the HTTP request (with its parameters) then 'copy' it to tHttpRequest. maybe it contains a header key with the path of the file
to capture your request on google press ctrl + maj + I and go to network, or use wireshark.
Uploading a 5 GB file on a http protocol will takes some time... 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now

Getting Started with APIs

Find out how to get started with APIs

Read