Informatica Development Platform

Informatica Connector Toolkit

Java data types

You can map the native data types to Java data types. When you map the native data type, select the best Java data type to read from the data source and select the best native data type to write to the target database or application.

Multiple native metadata objects

You can define multiple native metadata definitions for an adapter. For example, you can create different native metadata objects for tables, views, and synonyms in a relational data source.

Sort and select

You can define Sort statement support for an adapter to retrieve data from the data source in a specific order. You can define whether the adapter supports Select statement when the adapter reads from the data source. You can use the Informatica Connector Toolkit to define the following Select statements for an adapter:

• - Select All
• - Select Any
• - Select Distinct
• - Select First Row
• - Select Last Row

Partition

You can specify the partition type and implement the partition logic to use when the adapter reads or writes data.

You can specify one of the following partition types or all the partition types for an adapter:

• - Dynamic. The Data Integration Service determines the number of partitions at run time based on the partition information from the data source.
• - Static. The Data Integration Service determines partitioning logic based on the partition information that the user specifies, such as the number of partitions or key range partitioning.

Parameterization

You can specify whether the read and write capability attributes of a native metadata object support full parameterization or partial parameterization. The read and write capability attributes of the native metadata object can be assigned values or parameters at run time.

Pre and Post data operation

You can implement pre and post tasks that can be run before or after a read or write operation. For example, you can implement the functionality to truncate a target table before a write operation.

Messages

You can create messages to handle exceptions that occur during the design time or run time of the adapter. You can use the Message wizard to add, edit, or delete messages. You can localize the message files if required.

C run time

You can implement the run-time behavior of the adapter in C. You can write code to define how the adapter reads from and writes to the data source in C.

Informatica Cloud support

You can export the connector package for publishing the connector to Informatica Cloud.