Schema (From Table) Reader Parameters
Reader
The format of the database table to be read.
The file from which the data is to be read.
This field will usually display Read from Source, which means that FME will simply use default values. In most cases, the default value is all you will need.
Edit parameters specific to the format you have chosen. For detailed help with all format parameters, click Help in the applicable Parameter box.
Select Table
Select the table you want to read from the drop-down list.
Select Columns
Specifies the column name that contains the feature type name to use when creating schema information feature. The output attribute that will be set is fme_feature_type_name.
Specifies the column name that contains the attribute names to use when creating schema information feature. Output attributes that will be affected will be of the form attribute{n}.name.
Specifies the column name that contains the attribute’s type to use when creating schema information feature. Output attributes that will be affected will be of the form attribute{n}.fme_data_type.
See FME Data Types.
Specifies the column name that contains the geometry type to use when creating schema information feature. Output attributes that will be affected will be of the form fme_geometry{n}.
Specifies the column name that contains information about how to order the schema attributes.
Choose the character that will separate multiple values.
Schema Attributes
Use this parameter to expose Format Attributes in FME Workbench when you create a workspace:
- In a dynamic scenario, it means these attributes can be passed to the output dataset at runtime.
- In a non-dynamic scenario, this parameter allows you to expose additional attributes on multiple feature types. Click the browse button to view the available format attributes (which are different for each format) for the reader.