Preface
Introduction to Informatica Connector Toolkit
- Supported features
- Informatica Connector perspective
  - Connector Navigator
  - Connector Progress
Before you begin
- Download the welcome kit
- Download and install Eclipse IDE
- Download and install the Informatica Connector Toolkit
- Download OpenJDK and configure environment variables
- Log in to Informatica Intelligent Data Management Cloud
Develop a connector for Cloud Data Integration
- Create a new connector project
- Phase 1: Establish a connection
  - Create a connection
  - Test a connection
- Phase 2: Define the metadata
- Phase 3: Configure the runtime behavior
- Phase 4: Generate the connector package
  - Naming Convention
- Phase 5: Generate and run the test scenarios
  - Generate the test scenarios
    - Configure parameters in test suite file
    - Regenerate a test case
  - Run the test scenarios
    - Unit tests and sanity tests
    - Integration tests
Develop a connector for Data Loader
- Create a new connector project
- Phase 1: Establish a connection
  - Create a connection
  - Test a connection
- Phase 2: Define the metadata
- Phase 3: Configure the runtime behavior
- Phase 4: Generate the connector package
  - Naming Convention-DLT
- Phase 5: Generate and run the test scenarios
  - Generate the test scenarios
    - Configure parameters in test suite file
    - Regenerate a test case
  - Run the test scenarios
    - Unit tests and sanity tests
    - Integration tests
Import a connector
Connection attributes
- Connection attribute properties
Type system
- Native types and semantic categories
  - Native Type Properties
- Cloud Data Integration types
Connector metadata
- Metadata components
- Import dialog box settings
Partitioning capability
- Automatic partitioning
- Static partitioning
Pushdown capability
- Pushdown optimization execution flow
- Classes and methods for pushdown capabilities
Mappings in advanced mode
- Project, classes, and methods
Manual changes to Informatica Connector Toolkit source code
- Code changes for connection pooling
  - Connection Pooling through API
- Code changes for custom query
- Code changes for object path override
- Code changes for pushdown capability
- Code changes for SQL transformation
- Code changes for stored procedures
Runtime behavior
- Runtime Java functions
Connector example: MySQL_Cloud
- MySQL_Cloud Connector requirements
- Building the sample connector
- MySQL_Cloud Connector components
Version control integration
- Git version control integration
  - Prerequisites
  - Build a connector in Git repository
- Perforce version control integration
Appendix A: Metadata models
- Metadata model components
- Metadata patterns
- Features of type A metadata template
Appendix B: ASO model
- ASO model components
- ASO projections
Appendix C: Connector project migration
- Migrate connector project from Windows platform to other platforms
Appendix D: Frequently used generic APIs in Informatica Connector Toolkit
Appendix E: Frequently asked questions

Cloud Data Integration Connector Toolkit Developer Guide

Back Next

Create a connection

Define the connection attributes to authenticate access to a data source. Create a connection page to define the attributes to authenticate access to a data source. Organize attributes into specific sections, grouping similar ones. Include the required third-party libraries to set up the connection.

In the

Connector Progress

view, under

Phase 1: Establish Connection

, click

Create Connection

Connector progress with Phase 1 create a new connection.

Configure the connection attributes.

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 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 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.
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.

Click

Configure the connection pages.

To create a new connection section, click

Add Section

and enter the section name, section title, tool tip, and section description.

Add attributes to specific sections. You can group similar attributes under a section.

To change the order in which connection sections appear in a connection page, use

Move Up

Move Down

Click

Add the third-party libraries.

Click

Add

to add the third-party libraries required to connect to the data source.

Click

Generate Code

After you define the connection attributes, the Informatica Connector Toolkit generates the following Java files:

<ConnectorName>ConnectInfoAdapter.java

<ConnectorName>Connection.java

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.

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.

Rename Saved Search

Table of Contents

Cloud Data Integration Connector Toolkit Developer Guide

Cloud Data Integration Connector Toolkit Developer Guide

Create a connection

Create a connection