Table of Contents

  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: Instagram
  11. Adapter Example: MySQL
  12. Adapter Example: YouTube
  13. Metadata Models
  14. ASO Model
  15. Adapter Project Migration
  16. Frequently Asked Questions

Informatica Connector Toolkit Developer Guide

Informatica Connector Toolkit Developer Guide

Test the Write Capability of the Adapter

Test the Write Capability of the Adapter

When you test the write capability of the adapter, you test the components of the adapter and write sample data to the data source. After you specify the test settings and run the test, you can view the result of the write operation, write 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 Write dialog box to test the write capabilities of the adapter.
  1. In the Connector Progress view, select the native metadata object that appears under Test Write.
    The Test Write 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 a native metadata object to test the write operation.
    The metadata of the native metadata object along with the data type, scale, and precision appears in the Test Write page.
  8. Select the columns to which you want to write data.
  9. Click Next.
    The Test Data page appears.
  10. In the Test Data page, you can load test data from a file or you can generate test data.
    • To load the test data from a file, perform the following steps:
      1. Select the Load from a File option. You must load a comma-delimited TXT file or CSV file.
        The date and time data types in the file must have the following timestamp format: MM/DD/YYYY hh24:mm:ss
      2. Click Browse and select the file that contains the test data.
    • To generate test data, perform the following steps:
      1. Select the Auto generate data option.
      2. Enter the number of rows to generate. You can specify a maximum of 1000 rows.
      3. Click Generate. The test data appears in the Data Preview section.
      4. If required, you can edit the test data that appears in the Data Preview section.
  11. After you load a test data file or generate test data, click Next.
    The Write Capability page appears.
  12. Specify values for the write capability attributes and then click Run.
    The Result page appears. You can view the result of the write operation, write operation statistics, and the log file in the Result page.
  13. Click Close.


Updated May 15, 2019


Explore Informatica Network