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

Informatica Platform Types

Informatica Platform Types

Informatica platform types include all the data types that are recognized by Informatica. The Informatica Connector Toolkit API uses ODBC as a model to describe the Informatica platform data types.
In addition to assigning semantic categories to native types, you must match each semantic category with one or more Informatica platform data types. The Informatica platform uses ODBC types to determine what type of data buffers to bind to the run-time adapter for data access. In some cases, the match between a semantic type and an Informatica platform type is not exact. For example, the Informatica platform always binds a timestamp buffer if the semantic category is mapped to an Informatica platform date, time, or timestamp data type.
In many cases, a semantic category matches one of the available Informatica platform types. In cases where there is no exact match between types, select the best possible match.
In addition to defining the best mappings to convert native types to Informatica platform types, you can specify alternate mappings. An alternate mapping allows the end user to select alternate transformation data types to associate with the input and output ports of a data source used in a mapping.
Use the Informatica Connector Toolkit to add matching Informatica platform data types for the semantic category. You can indicate whether the mapping is the exact match or whether the mapping can result in a lossy data conversion due to a match that is not exact.
Informatica platform types are not the same as the transformation data types that appear in a transformation that you add to a mapping. Informatica platform types are internal data types used only within the adapter type system. Informatica can convert Informatica platform types to transformation data types.

Updated May 15, 2019


Explore Informatica Network