Adding external files in Talend Studio - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
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-02-29
Available in...

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 (artifact) execution.

Before you begin

  • The artifact is open in Talend Studio and the Context view below the design workspace is selected.

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

About this task

For example, create a artifact that imports customer records from an xlsx file.

Procedure

  1. Click the [+] button in the Context view to add a line in the table.
  2. 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.
  3. Set the type of the parameter to String.
  4. In the Value field, set the path to the file which is stored locally on your system.
  5. 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

    Basic settings view.
  6. Run the artifact in Talend Studio to test it.
    Set the path to the customers file when prompted.
    Execution results.

    The customer records are imported from the xlsx file.

  7. Right-click the artifact in the Repository tree view and select Publish to Cloud.