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 Adapter Metadata for Procedure Pattern Manually

Defining the Adapter Metadata for Procedure Pattern Manually

When you use the procedure pattern type to define the native metadata for the adapter, you can use the manual method to define the native metadata object.
Procedure pattern is available only for Informatica Cloud and not supported for PowerCenter and Big Data Management in this release.
  1. In the Connector Navigator view, right-click the project and select Add Native Metadata Definition.
    The Add Native Metadata Definition dialog box appears.
  2. Enter the native metadata details.
    The following table describes the properties to enter:
    Property Description
    Name Name for the native metadata.
    Display Name Display name for the native metadata.
    Description Description of the native metadata.
  3. Specify the pattern type as procedure to create a native metadata object for procedures or functions in a data source.
  4. To manually define the native metadata object for the data source with procedure pattern type, select Manual as the creation method.
  5. Click Next.
    The Native Metadata Procedure Definition page appears.
  6. To add additional metadata information for procedure, select Add Procedure Extension and add the following properties for the attribute:
    Attribute Property
    Description
    Name
    Name of the attribute.
    Display Name Display name for the connection attribute.
    Description
    Description of the connection attribute.
    Data Type Data type of the connection attribute.
    Default Value Default value for the attribute.
    Min Length
    Minimum length for the value of the attribute.
    Max Length
    Maximum length for the value of the attribute.
    The maximum length of any attribute cannot be greater than Integer.MAX_VALUE, which is 2,147,483,647.
    Encrypted Indicates whether you can encrypt the attribute.
    Mandatory
    Indicates whether a connection attribute requires a value.
    If you set the Mandatory property to True but you do not display the attribute on the connection management user interface, you must set a default value for the attribute.
    Hidden
    Indicates whether you can hide the attribute.
    Allowed Values
    List of values allowed for the attribute.
  7. Click Next.
    The Native Metadata Parameter Definition page appears.
  8. To add additional metadata information for parameters, select Add Parameter Extension and add the attribute properties.
  9. Click Next.
    The Native Metadata Call Capability Attributes page appears.
  10. To add call capability attributes, click Add and add the attribute properties.
    You can select Override Partitions to specify if the attribute can be overridden for each partition. Implement the <ConnectorID><NMOName>AutoPartitioningMetadataAdapter file to define the partition support.
  11. Click Next.
    The Import Dialog Box Settings page appears.
  12. In the Metadata Import Dialog Box Settings section, select the metadata import options that appear in the client tool when an adapter consumer creates a data object and click Save.
  13. Click Generate Code.
    After you define the adapter metadata, the Informatica Connector Toolkit generates the <NMOName>MetadataAdapter.java file in the Metadata folder. Implement the following methods in the <NMOName>MetadataAdapter.java file to import metadata.
    populateObjectCatalog()
    Populates metadata details in the import wizard for the adapter consumer.
    Data preview in the PowerCenter client or Informatica Cloud does not work if the values of the Record.setName and Record.setNativeName methods are different.
    populateObjectDetails()
    Gets metadata from the data source based on the import dialog options settings.
If you configured metadata write settings for the connector, implement the writeObjects method in the <NMOName>MetadataAdapter.java file.
If you regenerate code for the native metadata definition project, the Informatica Connector Toolkit does not regenerate code for the user-exposed source code visible in the Informatica perspective. You have to manually edit the source code and make changes if you add, remove, or change the native metadata attributes.

Updated May 15, 2019


Explore Informatica Network