PostgreSQL Connector for Data Prep¶
User Persona: Data Prep User or Data Prep Admin
Note
This document covers all configuration fields available during connector setup. Some fields may have already been filled out by your Administrator at an earlier step of configuration and may not be visible to you. For more information on Data Prep's connector framework, see Data Prep Connector setup. Also, your Admin may have named this connector something else in the list of Data Sources.
Configure Data Prep¶
The ability to connect to PostgreSQL is part of the Data Prep JDBC Connector. This article provides details specific to setting up a connection to PostgreSQL. See also the JDBC Connector Documentation to configure the connection properly.
Example JDBC URI:¶
jdbc:postgresql://yourPostgresHost:yourPostgresPort/yourDatabaseName
Technical Specs¶
Driver Specs¶
-
PostgreSQL Database driver name & version:
-
Driver class name: org.postgresql.Driver
-
Version: 42.2.8
-
*Supported PostgreSQL Database versions:*
- 8.2 or newer
Driver Documentation¶
- General Driver Documentation: https://jdbc.postgresql.org/documentation/head/index.html