Configuring the source file

XML connectors

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Open Studio for ESB
Talend Data Fabric
Talend Big Data
Talend Open Studio for MDM
Talend ESB
Talend Big Data Platform
Talend Open Studio for Data Integration
Talend Real-Time Big Data Platform
Talend Data Integration
Talend MDM Platform
Talend Open Studio for Big Data
Talend Data Services Platform
Talend Data Management Platform
task
Data Governance > Third-party systems > XML components > XML connectors
Data Quality and Preparation > Third-party systems > XML components > XML connectors
Design and Development > Third-party systems > XML components > XML connectors
EnrichPlatform
Talend Studio
  1. Drop a tFileInputDelimited and a tAdvancedFileOutputXML from the Palette onto the design workspace.
  2. Alternatively, if you configured a description for the input delimited file in the Metadata area of the Repository, then you can directly drag & drop the metadata entry onto the editor, to set up automatically the input flow.
  3. Right-click on the input component and drag a row main link towards the tAdvancedFileOutputXML component to implement a connection.
  4. Select the tFileInputDelimited component and display the Component settings tab located in the tab system at the bottom of the Studio.
  5. Select the Property type, according to whether you stored the file description in the Repository or not. If you dragged & dropped the component directly from the Metadata, no changes to the setting should be needed.
    If you didn't setup the file description in the Repository, then select Built-in and manually fill out the fields displayed on the Basic settings vertical tab.
    The input file contains the following type of columns separated by semi-colons: id, name, category, year, language, director and cast.
    In this simple use case, the Cast field gathers different values and the id increments when changing movie.
  6. If needed, define the tFileDelimitedInput schema according to the file structure.
  7. Once you checked that the schema of the input file meets your expectation, click on OK to validate.