Informatica Connector Toolkit Getting Started Guide

Informatica Connector Toolkit Getting Started Guide

Step 2. Define the Adapter Connection Attributes

Step 2. Define the Adapter Connection Attributes

Define the connection attributes to specify the behavior and functionality of the adapter when it connects to the MySQL database.
  1. In the
    Connector Navigator
    view, right-click the project and select
    Add Connection
    .
    The
    Add Connection
    dialog box appears.
  2. Enter
    MySQL
    for the connection type name.
  3. Select
    Add New
    and enter
    Sample
    for the category name.
    The category name that you configure corresponds the connection object category.
  4. Click
    Next
    .
    The
    Connection Attributes
    page appears.
  5. Click
    Add
    to enter each connection attribute.
    The attributes that you configure correspond to the connection object properties.
    The
    Add Attribute
    dialog box appears:
    1. Enter the following values for the username attribute:
      Property
      Value
      Name
      username
      Display Name
      User Name
      Description
      The user name to connect to the MySQL database. [Required]
      Datatype
      String
      Min Length
      0
      Max Length
      16
      Options
      • Mandatory
    2. Enter the following values for the password attribute:
      Property
      Value
      Name
      password
      Display Name
      Password
      Description
      The password associated with your user name. [Required]
      Datatype
      String
      Min Length
      0
      Max Length
      16
      Options
      • Encrypted
      • Mandatory
    3. Enter the following values for the host name attribute:
      Property
      Value
      Name
      hostname
      Display Name
      Host Name
      Description
      Host name of the MySQL server to connect. [Required]
      Datatype
      String
      Default Value
      localhost
      Min Length
      0
      Max Length
      16
      Options
      • Mandatory
    4. Enter the following values for the port number attribute:
      Property
      Value
      Name
      port
      Display Name
      Port
      Description
      Port number of the MySQL server to connect. [Required]
      Datatype
      Integer
      Default Value
      3306
      Options
      • Mandatory
    5. Enter the following values for the catalog attribute:
      Property
      Value
      Name
      catalog
      Display Name
      Catalog
      Description
      Database catalog to connect. [Required]
      Datatype
      String
      Min Length
      0
      Max Length
      255
      Options
      • Mandatory
  6. Click
    Next
    .
    The
    Configure Libraries
    page appears.
  7. Click
    Add
    to select each library that the adapter requires to connect to the MySQL database.
  8. Click
    Generate Code
    .
    The Informatica Connector generates Java source code in the Connectivity folder of the adapter project.
  9. In the Connectivity folder of the adapter project, double-click each file to review the source code and update it as required.
    Update the following source code files in the Connectivity folder:
    MySQLConnectInfoAdapter.java
    This file contains optional methods for connection validation and attribute dependencies.
    MySQLConnection.java
    This file contains methods that open and close the connection to the MySQL service.
    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.


Updated January 29, 2020