Adding external files in Talend Studio - Cloud

Adding external files in Talend Studio - Cloud - 7.3

Talend Studio User Guide

Version

Cloud

7.3

Language

English

Product

Talend Big Data

Talend Big Data Platform

Talend Cloud

Talend Data Fabric

Talend Data Integration

Talend Data Management Platform

Talend Data Services Platform

Talend ESB

Talend MDM Platform

Talend Real-Time Big Data Platform

Module

Talend Studio

Content

Design and Development

Last publication date

2024-03-20

Cloud API Services Platform

Cloud Big Data

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Integration

Cloud Data Management Platform

Data Fabric

You can use a context parameter in Artifacts to allow web users to use external files during the Task execution.

The Artifact is open in the Studio and the Contexts tab below the design workspace is selected.

If this tab does not show in the Studio, click Window > Show view > Talend , and select Contexts.

As an example, we are creating a Artifact that imports customer records from an xlsx file.

Click the [+] button at the bottom of the Contexts view to add a line in the table.
In the Name field, define the context parameter following the pattern resource_file_<parameter_name>, all in lower case.
Use resource_file_customers in this example as you want to get data from the customers file.
Set the type of the parameter to String.
In the Value field, set the path to the file which is stored locally on your system.
Double-click the tFileInputExcel component to open its basic settings, define the schema, and define the file name as a context parameter, context.resource_file_customers.
Example
Run the Artifact in the Studio to test it.
Set the path to the customers file when prompted.

The customer records are imported from the xlsx file.
Right-click the Artifact in the Repository tree view and select Publish to Cloud.