List of Supported Formats

Search the Online Transformer Gallery

SAP HANA Non-Spatial Writer Feature Type: User Attributes

For information on the parameters in this dialog that are specific to all formats, see About Writer Feature Types: User Attributes

User attributes for this format are defined below.

Name The name of the field to be written.
Type

This section describes the attribute types for a table.

Closedalphanum

Represents strings of up to 127 alpha-numeric characters.

Closedbigint

Represents 64-bit signed integers.

Closedblob

Represents variable-length binary data up to a length of 2 GB.

Closedclob

Represents variable-length ASCII character data up to a length of 2 GB.

Closeddate

Represents date data from January 1, 0001 to December 31, 9999.

See Standard FME Date/Time Format.

Closeddecimal

Represents fixed precision and scale numeric data.

Closeddouble

Represents 64-bit floating precision numbers.

Closedinteger

Represents 32-bit signed integers.

Closednclob

Represents variable-length Unicode character data up to a length of 2 GB.

Closednvarchar

Represents variable-length Unicode character data up to a length of 5000 characters.

Closedreal

Represents 32-bit floating precision numbers.

Closedseconddate

Represents date and time data from January 1, 1900 to June 6, 2079 with an accuracy of one second.

See Standard FME Date/Time Format.

Closedsmallint

Represents 16-bit signed integers.

Closedtime

This type is used to represent time data with an accuracy of up to one second.

See Standard FME Date/Time Format.

Closedtimestamp

This type is used to represent date and time data from January 1, 0001 to December 31, 9999 with an accuracy of up to 100 nanoseconds.

See Standard FME Date/Time Format.

Closedtinyint

This type is used to represent numbers between 0 and 255.

Closedvarchar

This type is used to represent variable-length ASCII character data up to a length of 5000 bytes.

Closedvarbinary

This type is used to represent variable-length binary data up to a length of 5000 bytes.
Index

This type is used to create bitmap indexes. A bitmap index stores a bitmap for each index key. Each index key stores pointers to multiple rows. They are primarily designed for data warehousing or environments in which queries reference many columns in an ad hoc fashion.

Indexes and constraints are only created if the table is created.

The valid values for the column type are listed below:

PrimaryKey: This type specifies that the column is a primary key for the table. Only one primary key is allowed per table.

Unique: This type specifies that the column has a UNIQUE constraint.

NotNull: A non-nullable constraint.

UniqueNotNull: An index with a non-nullable and unique constraints.