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

Endpoint object metadata

Add object metadata for a connector for Data Loader.

Click

Add Object Metadata

Select

Enable Read Capability

to define read capability for the connector.

To add runtime attributes, select Configure Runtime Attributes
, and then click Add
and configure the following attribute properties:

Property	Description
Name	Name of the 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. The maximum length of any attribute cannot be greater than Integer.MAX_VALUE, which is 2,147,483,647.
Supports Parameter	Indicates whether you can parameterize the attribute. When you parameterize an attribute, you can assign values for the attribute at run time. Full Parameterization. Indicates you can parameterize the value of an attribute completely. Partial Parameterization. You can parameterize a part of the attribute value. No. The attribute does not support parameterization.
Encrypted	Indicates whether you can encrypt 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.
Override Partitions	Indicates if the attribute can be overridden for each partition. Implement the <ConnectorID><NMOName>AutoPartitioningMetadataAdapter file to define the partition support.
Allowed Values	List of values allowed for the attribute.

Click

Generate Code

After you define the connector metadata, the Informatica Connector Toolkit generates the

<NMOName>MetadataAdapter.java

file in the

Metadata

folder.

Implement the following methods in the

<NMOName>MetadataAdapter.java

file to import metadata:

populateObjectCatalog(): Populates metadata details in the import wizard for the connector consumer.
populateObjectDetails(): Gets metadata from the data source based on the import dialog options settings.

If you regenerate code for the endpoint metadata definition 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 change the endpoint metadata attributes.

Edit endpoint object metadata

You can edit the endpoint metadata to update the metadata properties and add additional metadata information for the objects and fields.

Click Edit
for the endpoint.

Enter the object details.

Property	Description
Name	Name for the object.
Display Name	Display name of the object.
Description	Description of the object.

Click

To add additional metadata information for the object, select

Add Record Extension

Click

Add

to add a record extension and configure the following properties:

Property	Description
Name	Name of the 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. The maximum length of any attribute cannot be greater than Integer.MAX_VALUE, which is 2,147,483,647.
Encrypted	Indicates whether you can encrypt the attribute.
Mandatory	Indicates whether a connection attribute requires a value. If you set the Mandatory property to True but you do not want to display the attribute on the connection management user interface, you must set a default value for the attribute.
Hidden	Determines whether you want to display or hide the attribute.
Allowed Values	List of values allowed for the attribute.

Click

To add additional metadata information for the fields, select

Add Field Extension

Click

Add

to add a field extension and configure the following properties:

Property	Description
Name	Name of the 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. The maximum length of any attribute cannot be greater than Integer.MAX_VALUE, which is 2,147,483,647.
Supports Parameter	Indicates whether you can parameterize the attribute. When you parameterize an attribute, you can assign values for the attribute at run time. Full Parameterization. Indicates you can parameterize the value of an attribute completely. Partial Parameterization. You can parameterize a part of the attribute value. No. The attribute does not support parameterization.
Encrypted	Indicates whether you can encrypt 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.
Allowed Values	List of values allowed for the attribute.