Table of Contents

Search

  1. Preface
  2. Introduction to the Informatica Connector Toolkit
  3. Installing and Upgrading the Informatica Connector Toolkit
  4. Building an Adapter
  5. Connection Attributes
  6. Type System
  7. Metadata Objects
  8. Partitioning Capability
  9. Run-time Behavior
  10. Adapter Example: MySQL
  11. Adapter Example: YouTube
  12. Metadata Models
  13. ASO Model
  14. Adapter Project Migration
  15. Frequently Asked Questions

Informatica Connector Toolkit Developer Guide

Informatica Connector Toolkit Developer Guide

Test the Read Capability of the Adapter

Test the Read Capability of the Adapter

When you test the read capability of the adapter, you test the connection definition, metadata of the data source, and operations that the adapter supports. After you specify the test settings and run the test, you can view the result of the read operation, read operation statistics, and the log file.
To debug the code, use the same debug configuration that you used to test the connection and metadata components of the adapter. You can also set breakpoints in the code that you want to debug.
After you define the debug configuration, you can launch the
Test Read
dialog box to test the read capabilities of the adapter.
  1. In the
    Connector Progress
    view, select the native metadata object that appears under
    Test Read
    .
    The
    Test Read
    dialog box appears with the default JVM environment settings and tracing level. The Informatica Connector Toolkit uses the JVM settings to run the debug configuration.
  2. If required, edit the JVM environment settings. Ensure that you use the same port number that appears in JVM settings for the connection properties in the debug configuration.
  3. Select the required tracing level. The default is normal. Based on the amount of detail that you require in the log file, you can override the default tracing level.
    You can set the following types of tracing level:
    None
    Does not override the default tracing level.
    Terse
    Logs initialization information and error messages and notification of rejected data.
    Normal
    Logs initialization and status information, errors encountered, and skipped rows due to transformation row errors. Summarizes mapping results, but not at the level of individual rows. This is the default tracing level.
    Verbose Initialization
    In addition to normal tracing, logs additional initialization details, names of index and data files used, and detailed statistics.
    Verbose Data
    In addition to verbose initialization tracing, logs each row. You can also get detailed statistics on where string data was truncated to fit the precision of a column.
  4. Click
    Next
    .
    The connection attributes that you defined for the adapter appears.
  5. Enter values for the connection attributes to test the connection to the data source.
  6. Click
    Connect
    .
    The
    Test Metadata
    page appears with the metadata imported from the data source.
  7. Select the native metadata objects and the corresponding native metadata fields to test the read operation.
  8. Click
    Next
    .
    Based on whether the selected native metadata object supports join and filter operations, the
    Join Condition
    page or
    Filter Condition
    page appears.
  9. If the native metadata object supports join operation, specify an expression in the
    Join Condition
    page.
    • To specify an Informatica platform expression for the join operation, perform the following steps:
      1. In the
        Definition
        section, select the native metadata object for which you want to specify the join condition.
      2. To change the join order, click
        Move Up
        or
        Move Down
        .
      3. Specify the join type in
        Join condition
        .
      4. To define a join condition, select values in the
        Left Field
        ,
        Operator
        , and
        Right Field
        columns.
      5. To add additional join conditions, click
        Add
        .
      6. To remove a join condition, select the join condition and click
        Remove
        .
    • To specify a native expression for the join operation, enter the expression in the
      Definition
      section.
  10. If the native metadata object supports filter operation, select the
    Configure Filter
    option in the
    Filter Condition
    page and specify the filter condition.
    • To specify an Informatica platform expression for the filter operation, perform the following steps:
      1. In the
        Definition
        section, click
        Add
        to add an Informatica platform expression.
      2. In the
        Field
        column, select the field to use in the expression.
      3. In the
        Operation
        column, select a conditional operator to use in the expression.
      4. In the
        Value
        column, enter a value for the conditional expression.
    • To specify a native expression for the filter operation, enter the expression in the
      Definition
      section.
  11. After you specify expressions for the native metadata object, click
    Next
    .
    The
    Read Capability
    page appears.
  12. Specify values for the read capability attributes and then click
    Run
    .
    The
    Result
    page appears. You can view the result of the read operation, read operation statistics, and the log file in the
    Result
    page.
  13. Click
    Close
    .


Updated December 12, 2019