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 May 15, 2019


Explore Informatica Network