Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for JDBC V2
  3. PowerExchange for JDBC V2 Configuration Overview
  4. JDBC V2 Connections
  5. PowerExchange for JDBC V2 Data Objects
  6. JDBC V2 Mappings
  7. PowerExchange for JDBC V2 Dynamic Mappings
  8. JDBC V2 Lookup
  9. JDBC V2 Run-Time Processing
  10. JDBC V2 Datatype Reference

PowerExchange for JDBC V2 User Guide

PowerExchange for JDBC V2 User Guide

Configuring a Mapping to Run in a Native or Non-Native Environment

Configuring a Mapping to Run in a Native or Non-Native Environment

You can configure a mapping to run in a native or non-native environment. To configure a mapping, you must select a validation environment and an execution environment.
  1. Select a mapping from a project or folder from the
    Object Explorer
    view to open in the editor.
  2. In the
    Properties
    view, select the
    Run-time
    tab.
  3. Select
    Native
    ,
    Hadoop
    , or
    Databricks
    as the value for the validation environment.
    When you select the Hadoop environment, select the Spark engine. Disable the engines that you do not want to use.
  4. Select
    Native
    ,
    Hadoop
    , or
    Databricks
    for the execution environment.
    The following image displays the validation environments that you can select:
    In the non-native environment, you can choose Databricks, or Spark on the Hadoop environment.
  5. Select
    Connection
    and use the drop down in the value field to browse for a connection or to create a connection parameter:
    • To select a connection, click
      Browse
      and select a connection.
    • To create a connection parameter, click
      Assign Parameter
      .
  6. Configure the rest of the properties for the execution environment.
  7. Right-click an empty area in the editor and click
    Validate
    .
    The Developer tool validates the mapping.
  8. View validation errors on the
    Validation Log
    tab.
  9. To view the execution plan for a mapping that runs in the non-native environment, right-click the editor and select
    Show Execution Plan
    .

0 COMMENTS

We’d like to hear from you!