PostgreSQL
This quickstart describes how to create a PostgreSQL connection.
Create a connection to PostgreSQL
To ingest data from PostgreSQL using Upsolver, you must first create a connection that provides the appropriate credentials to access your database.
Your connection is persistent, so you won't need to re-create it for every job. The connection is also shared with other users in your organization.
Here’s the code for creating a connection to PostgreSQL:
// Syntax
CREATE POSTGRES CONNECTION <connection_identifier>
CONNECTION_STRING = '<connection_string>'
USER_NAME = '<user_name>'
PASSWORD = '<password>';
// Example
CREATE POSTGRES CONNECTION my_postgres_connection
CONNECTION_STRING = 'jdbc:postgresql://
cdc2.c02eyuedjkh9.eu-west-1.rds.amazonaws.com:5432/auction'
USER_NAME = 'your username'
PASSWORD = 'your password'
After you complete this step, you should see the my_postgres_connection connection in your navigation tree.
Learn More
Please see the SQL command reference for PostgreSQL for the full list of connection options, and examples.
Last updated