Retrieving SAS table schemas - Cloud

Talend Cloud Data Management Platform Studio User Guide

English (United States)
Talend Cloud
Talend Management Console
Talend Studio
Design and Development


  1. Right-click the SAS connection you created and then select Retrieve Schema from the contextual menu.
    A new wizard opens up where you can filter and show different objects (tables, views) in your database connection, select tables of interest, and define table schemas.
  2. Filter databases objects according to your need, select one or more tables of interest, and modify the table schemas if needed. For details, see Retrieving table schemas.
    Warning: Avoid using any Java reserved keyword as a schema column name.
    Make sure the data type in the Type column is correctly defined.
    For more information regarding Java data types, including date pattern, see Java API Specification.
    Below are the commonly used Talend data types:
    • Object: a generic Talend data type that allows processing data without regard to its content, for example, a data file not otherwise supported can be processed with a tFileInputRaw component by specifying that it has a data type of Object.

    • List: a space-separated list of primitive type elements in an XML Schema definition, defined using the xsd:list element.

    • Document: a data type that allows processing an entire XML document without regarding to its content.

    When done, you can drag and drop any table schema of the SAS connection from the Repository tree view onto the design workspace as a new component or onto an existing component to reuse the metadata. For more information, see Using centralized metadata in a Job and Setting a repository schema in a Job.