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

Creating a JDBC V2 Target

Creating a JDBC V2 Target

You can create a JDBC V2 target using the
Create Target
option.
  1. Select a project or folder in the
    Object Explorer
    view.
  2. Select a source or a transformation in the mapping.
  3. Right-click the Source transformation and select
    Create Target
    .
    The
    Create Target
    dialog box appears.
    The following image shows the
    Create Target
    option:
    You can view the 
					 Create Target option.
  4. Select
    Others
    and then select
    JDBC V2
    data object from the list in the
    Data Object Type
    section.
    The following image shows the
    Data Object Type
    section:
    You can view the selected JDBC V2 data object type from the list of data objects.
  5. Click
    OK
    .
    The
    New JDBC V2 Data Object
    dialog box appears.
  6. Enter a name for the data object.
  7. Click
    Finish
    .
    The new target appears under the
    Physical Data Objects
    category in the project or folder in the
    Object Explorer
    view.
  8. In the JDBC V2 connection
    Details
    tab, verify the connection details.
    The following image shows the connection properties:
    You can view the configured parameters in the connection.
  9. In the JDBC V2 advanced target properties, select the target schema strategy as
    Create - Create target if it does not exist
    .
    The following image shows the configured advanced properties:
    You can view the configured target schema strategy.

0 COMMENTS

We’d like to hear from you!