Informatica Connector Toolkit Getting Started Guide

Back Next

Step 2. Define the Connection Attributes

Define the connection attributes to specify the behavior and functionality of the connector when it connects to the MySQL database.

In the

Connector Navigator

view, right-click the project and select

Add Connection

The

Add Connection

dialog box appears.

Enter

MySQL

for the connection type name.

Select

Add New

and enter

Sample

for the category name.

The category name that you configure corresponds the connection object category.

Click

The

Connection Attributes

page appears.

Click

Add

to enter each connection attribute.

The attributes that you configure correspond to the connection object properties.

The

Add Attribute

dialog box appears:

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

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

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

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

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

Click

The

Configure Libraries

page appears.

Click

Add

to select each library that the connector requires to connect to the MySQL database.

Click

Generate Code

The Informatica Connector generates Java source code in the Connectivity folder of the connector project.

In the Connectivity folder of the connector 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.

Creating a Connector

Test and Debug the Connection to the Data Source

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal