Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Connector Toolkit
  3. Before you begin
  4. Develop a connector for Cloud Data Integration
  5. Develop a connector for Data Loader
  6. Import a connector
  7. Connection attributes
  8. Type system
  9. Connector metadata
  10. Partitioning capability
  11. Pushdown capability
  12. Mappings in advanced mode
  13. Manual changes to Informatica Connector Toolkit source code
  14. Runtime behavior
  15. Connector example: MySQL_Cloud
  16. Version control integration
  17. Appendix A: Metadata models
  18. Appendix B: ASO model
  19. Appendix C: Connector project migration
  20. Appendix D: Frequently used generic APIs in Informatica Connector Toolkit
  21. Appendix E: Frequently asked questions

Cloud Data Integration Connector Toolkit Developer Guide

Cloud Data Integration Connector Toolkit Developer Guide

Create a connection

Create a connection

Define the connection attributes, create connection pages, and add third-party libraries required to create a connection.
  1. In the
    Connector Progress
    view, under
    Phase 1: Establish a Connection
    , click
    Create Connection
    .
    Create a new connection.
  2. Configure the connection attributes.
    Configure the connection attributes.
    1. Click
      Add
      to add a new connection attribute.
      The attributes that you configure correspond to the connection object properties.
      Add a connection attribute and configure the properties in the Add Attribure window.
    2. In the
      Add Attribute
      window, enter the following properties for the connection attribute:
      Attribute Property
      Description
      Name
      Name of the connection attribute.
      Display Name
      Display name for the attribute.
      Description
      Description of the attribute.
      Data Type
      Data type of the 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.
      Encrypted
      Indicates whether you can encrypt the attribute.
      Supports Parameter
      Indicates whether you can parameterize 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.
      Has Dependent Fields
      Indicates whether the attribute has dependent fields.
      Allowed Values
      List of values allowed for the attribute.
    3. Click
      OK
      .
  3. Click
    Next
    .
  4. Configure the connection pages.
    Configure the connection pages.
    1. To create a new connection section, click
      Add Section
      and enter the section name, section title, tool tip, and section description.
    2. Add attributes to specific sections. You can group similar attributes under a section.
    3. To change the order in which connection sections appear in a connection page, use
      Move Up
      or
      Move Down
      .
  5. Click
    Next
    .
  6. Add the third-party libraries.
    Click
    Add
    to add the third-party libraries required to connect to the data source.
    Add the third-party libraries.
  7. Click
    Generate Code
    .
    After you define the connection attributes, the Informatica Connector Toolkit generates the following Java files:

      <ConnectorName>ConnectInfoAdapter.java

      <ConnectorName>Connection.java

  8. Update the
    ConnectInfoAdapter.java
    file to implement connection validation and attribute dependancies. Also, update the
    Connection.java
    file to implement the methods that open and close connection to the data source.
  9. You can test and debug the connection to the data source.
If you regenerate code for the connection 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 modify connection attributes.

0 COMMENTS

We’d like to hear from you!