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 May 15, 2019


Explore Informatica Network