Table of Contents

Search

  1. Preface
  2. Introduction to the Informatica Connector Toolkit
  3. Installing and Upgrading the Informatica Connector Toolkit
  4. Building an Adapter
  5. Connection Attributes
  6. Type System
  7. Metadata Objects
  8. Partitioning Capability
  9. Run-time Behavior
  10. Adapter Example: MySQL
  11. Adapter Example: YouTube
  12. Metadata Models
  13. ASO Model
  14. Adapter Project Migration

Informatica Connector Toolkit Developer Guide

Informatica Connector Toolkit Developer Guide

Defining the Type System Manually

Defining the Type System Manually

You can manually define a type system that maps the data types that the data source supports with the data types that Informatica Platform supports.
  1. In the
    Connector Navigator
    view, right-click the project and select
    Define Typesystem
    .
    The
    Define Type System
    dialog box appears.
  2. To manually define a type system that matches the data types in the data source, select
    Manually Create Type System
    .
  3. To map the native data types to the Informatica platform data types, select
    Native to Platform Type
    .
  4. To map the native data types to the Java data types, select
    Native to Java Type
    .
  5. Click
    Add
    to configure each type system attribute.
    The
    Add Type
    dialog box appears.
  6. Enter the following properties for the type system attribute:
    Property
    Value
    Type Name
    Name for the native type system attribute.
    Comments
    Comments for the native type system attribute.
    Best Platform Type for Read/ Best Java Type for Read
    The platform or Java data type that maps best to the native data type when the adapter reads from the data source.
    Properties
    Based on the selected best platform or Java type for read, you must set one or more of the following native type properties:
    • Precision properties such as max precision and default precision.
    • Scale properties such as max scale, default scale, and min scale.
    • Length properties such as max length and default length.
      The maximum length of any attribute cannot be greater than Integer.MAX_VALUE, which is 2,147,483,647.
    • Unit of length such as characters, bytes, and bits.
    • Date properties such as hour, minute, second, year, month, day, and time zone.
  7. If the platform data type or Java data type is the best match when writing to the native data type, select
    Mapped
    and then select
    Best Native Type to Write
    . For example, to map the Java INTEGER data type to the MySQL data type INT as one of the Best Native Type to Write, select Mapped in the INTEGER row and then select Best Native Type to Write.
  8. If you want to map a platform data type or Java data type to the native data type but not as a best match, select only
    Mapped
    . For example, if the Java SHORT data type maps to the MySQL data type INT but might result in loss of data when converted, select Mapped in the INTEGER row.
  9. Click
    OK
    . The
    Define Type System
    dialog box appears.
  10. After you add and map the required native data types for the adapter, click
    Generate Code
    .


Updated April 11, 2019