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.
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.