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.