Mapping Custom Data Types
When mapping source and target fields in a Block for a Map, you may need to use a custom data type. Some datastores, such as Microsoft SQL Server, allow users to define fields with custom or user-defined data types. Because custom data types are so flexible, TIBCO Scribe® Online simply converts any field with a custom data type to a field of type Object with an unspecified length.
As the Map designer, you need to understand enough about these fields to map them correctly. If needed, use one of the TIBCO Scribe® Online Data Conversion Functions to convert the data type from Object to a standard data type.
Tip: If necessary, talk to the database administrator for the datastore to determine the native data type.
Note: As with any other mapped fields, if TIBCO Scribe® Online cannot successfully map an Object field, a Data Type Mismatch error occurs.
See Data Conversion for more information about converting fields with custom data types.
