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

JDBC V2 Connections Overview

JDBC V2 Connections Overview

You can use the JDBC V2 connection to read data from or write data to any database that supports the Type 4 JDBC driver.
When you create a JDBC V2 connection, select the appropriate database type,
Aurora PostgreSQL
or
Azure SQL Database
, to which you want to connect to in the connection properties. Select
Other
to connect to any other database that supports the Type 4 JDBC driver.
You can use the connection to create data objects and run mappings. The Developer tool uses the connection when you create a data object. The Data Integration Service uses the connection when you run mappings.
You can create an connection from the Developer tool or the Administrator tool. The Developer tool stores connections in the domain configuration repository. Create and manage connections in the connection preferences.
You can use the connection in a mapping that runs on the native or non-native environment such as Spark and Databricks.

0 COMMENTS

We’d like to hear from you!