Perform the following steps after creating the FTP connection to transfer files to the FTP server using Sigma Studio:
- Right-click the created FTP server connection and select the Create Data Source option.
Refer Connectors - FTP for more information on creating a FTP connection.
The Create Request page appears. - Enter a unique data source name in the Data Source Name field, e.g. FTP_DS.
Select the Put File option in Request Type to send the requested file to the FTP server.
Provide the appropriate file path on the FTP server to which the files need to be transferred to the server in the Relative Path on Server field.
Note The Local File Path and File Name are optional fields. Both the Local File Path and File Name fields are not required to create a FTP DS, with the Put File Request Type. It is sufficient only if you provide the appropriate server path in the Relative Path on Server field. You can receive files of following formats from the FTP server:
- CSV
- XLS
- DOCX
- TXT
- HTML
- XML
- Click Save to save the FTP data source.
A success message for creating the data source appears as shown in the following screenshot: Click Ok.
Note In order to trigger the FTP service connection, the CT platform's server-side API, CT.ftp must be used while passing the ExecutionContext action in a Java Handler class. Refer the following sample code snippet for better understanding on the triggering process:
Here, on the following sample code snippet a new ExecutionContext action is created within which a map (HashMap) is built. The FTP datasource ID is passed as the input to activate the connection request within which the CT.ftp API is passed to trigger the process.
Code Block language js ExecutionContext ec = new ExecutionContext(); Map inputParams1 = new HashMap(); inputParams1.put("DATA_SRC_ID","FTP_DS"); // FTP_DS refers to the Datasource ID. ec.setInitialRequestData(inputParams1); try { CT.ftp(ec); } catch(Exception e){ }
...