topic Uploading files to EC2 server via Talend in Talend Studio

Uploading files to EC2 server via Talend

BA621858188 — Fri, 02 Dec 2022 05:13:13 GMT

Hi All,

I wanted to upload files from Talend to an EC2 server.

Can anyone let me know what components and properties I need to configure the connection between Talend and the EC2 server?

Thanks

Re: Uploading files to EC2 server via Talend

Anonymous — Fri, 02 Dec 2022 09:14:10 GMT

Hello @Vrushabh Malbari ,

You can use tFTPPut component to upload files to EC2 server

As the SSH will be running on the ec2 server, so you can check the SFTP Support for this component as the below which is an example

please refer to the below article for more details

https://help.talend.com/r/en-US/7.3/ftp/tftpput

Re: Uploading files to EC2 server via Talend

Anonymous — Fri, 02 Dec 2022 09:26:56 GMT

Hello,

Are you trying to upload files from talend studio to an EC2 server?

Do you mean a server hosted on Amazon EC2? So far, there is not a specific component for it. We have a KB article about:

https://community.talend.com/s/article/Adding-an-EC-server-in-Talend-Administration-Center-Ejpyk

Best regards

Sabrina

Re: Uploading files to EC2 server via Talend

BA621858188 — Mon, 05 Dec 2022 14:59:40 GMT

Okay @Xiaodi Shi let me check.

Re: Uploading files to EC2 server via Talend

BA621858188 — Mon, 05 Dec 2022 14:59:58 GMT

Okay @Aiming Chen let me check.

Re: Uploading files to EC2 server via Talend

BA621858188 — Thu, 08 Dec 2022 08:04:21 GMT

@Xiaodi Shi

The requirement is to just load file son EC2 server thats it. Talend job is running on job server which is different that EC2.

Re: Uploading files to EC2 server via Talend

BA621858188 — Thu, 08 Dec 2022 08:04:48 GMT

@Aiming Chen

The requirement is to just load file son EC2 server thats it. Talend job is running on job server which is different that EC2.

Will this component work in this scenario?

Re: Uploading files to EC2 server via Talend

Anonymous — Thu, 08 Dec 2022 08:10:14 GMT

@Vrushabh Malbari , yes, the tFTPPut component will also work in this scenario.

Re: Uploading files to EC2 server via Talend

BA621858188 — Thu, 08 Dec 2022 08:54:18 GMT

@Aiming Chen

Thanks for quick reply.

Source is table and that data I need to load and drop as a file on EC2. In this case what should I use in local directory as my source is table?

Re: Uploading files to EC2 server via Talend

Anonymous — Thu, 08 Dec 2022 10:55:29 GMT

@Vrushabh Malbari , you can output the source data from the table to a local file first, then use that local file by tFTPPut to upload to the EC2 server

Re: Uploading files to EC2 server via Talend

BA621858188 — Thu, 08 Dec 2022 15:04:39 GMT

Okay @Aiming Chen will do and let you know. I have one quick question If I have 2022-11-20 date in string data type and want to retrieve month 11 from it what function should I use as its of string type?

Thanks in advance

Re: Uploading files to EC2 server via Talend

Anonymous — Fri, 09 Dec 2022 01:01:04 GMT

@Vrushabh Malbari you can try the function like datestr.substring(5,7)

Re: Uploading files to EC2 server via Talend

BA621858188 — Fri, 09 Dec 2022 09:28:51 GMT

@Aiming Chen ,

If ftp services are not there on EC2 then what component should I use? SCP?

Please help.

Re: Uploading files to EC2 server via Talend

Anonymous — Mon, 12 Dec 2022 04:03:57 GMT

@Vrushabh Malbari , you can use tSCPPut component to do so, please refer to

https://help.talend.com/r/en-US/7.3/scp/tscpfileexists-tscpput-tscpclose-tjava-configuring-tscpput-component-standard-component

Re: Uploading files to EC2 server via Talend

BA621858188 — Tue, 13 Dec 2022 10:11:59 GMT

Thank you @Aiming Chen checking on this and will update you.

Re: Uploading files to EC2 server via Talend

BA621858188 — Fri, 16 Dec 2022 10:00:08 GMT

@Aiming Chen ,

Thank you. I need your help on one thing. Could you please tell me the component names that we can use to put the file on the server? I know we have SSH, SCP, and FTP. Is there any component we can use to put the file on an EC2 server?