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.
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.
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:
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.
List: a space-separated list of primitive type elements in an XML Schema definition, defined using the xsd:list element.
Dynamic: a data type that can be set for a single column at the end of a schema to allow processing fields as VARCHAR(100) columns named either as ‘Column<X>’ or, if the input includes a header, from the column names appearing in the header. For more information, see Dynamic schema.
Document: a data type that allows processing an entire XML document without regarding to its content.