Table of Contents

  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: Instagram
  11. Adapter Example: MySQL
  12. Adapter Example: YouTube
  13. Metadata Models
  14. ASO Model
  15. Adapter Project Migration
  16. Frequently Asked Questions

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


Explore Informatica Network