Informatica Connector Toolkit Getting Started Guide

Informatica Connector Toolkit Getting Started Guide

Step 3. Define the Adapter Type System

Step 3. Define the Adapter Type System

Define the type system to specify the datatypes supported by the data source and how they map to the datatypes supported by the Informatica platform.
  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
    .
    The
    Define Type System
    dialog box appears.
  3. To map the native data types to the Informatica platform data types, select
    Native to Platform Type
    .
  4. Click
    Add
    to configure each type system attribute.
    The
    Add Type
    dialog box appears.
    1. Enter the following values for the Timestamp attribute:
      Property
      Value
      Type Name
      Timestamp
      Comments
      Stores a period of time in years, months, days, hours, minutes, and seconds.
      Platform Type
      Date
      Max Scale
      6
      Default Scale
      6
      Supported Units
      Year, Month, Day, Hour, Minute, and Second.
    2. To map the Informatica Platform DATE data type to the MySQL data type Timestamp as one of the Best Native Type to Write, select Mapped in the DATE row and then select Best Native Type to Write.
    3. Enter the following values for the Double attribute:
      Property
      Value
      Type Name
      Double
      Comments
      A double-precision, floating-point number that is accurate to approximately 15 decimal places. Permissible values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308.
      Platform Type
      Double
      Max Precision
      15
      Default Precision
      15
      Precision Radix
      Decimal
      Max Exponent
      11
      Min Exponent
      0
      Exponent Radix
      Binary
    4. To map the Informatica Platform Double data type to the MySQL data type Double as one of the Best Native Type to Write, select Mapped in the Double row and then select Best Native Type to Write.
    5. Enter the following values for the String attribute:
      Property
      Value
      Type Name
      String
      Comments
      Variable-sized field of characters.
      Platform Type
      string
      Max Length
      8000
      Default Length
      50
      Length Unit
      characters
      Restrictions
      Allow Length Modifications and Allow Variable Allocation.
    6. To map the Informatica Platform string type to the MySQL data type String as one of the Best Native Type to read, select Mapped in the String row and then select Best Native Type to Read.
  5. Click
    Generate Code
    .


Updated April 11, 2019