Preface
Introduction to PostgreSQL Connector
- PostgreSQL Connector assets
Connections for PostgreSQL
Mappings and mapping tasks with PostgreSQL Connector
PostgreSQL objects in mapping tasks
Lookup transformation
- Rules and guidelines for uncached lookups
SQL transformation
- Rules and guidelines for SQL transformations
Migrating a mapping
- Use the same object path for the migrated mapping
- Use a different object path for the migrated mapping
  - Migration options
  - Rules and guidelines for migrating a mapping
PostgreSQL SQL ELT optimization
Data type reference

PostgreSQL Connector

Back Next

Authentication types

You can configure one of the following authentication modes to connect to PostgreSQL databases:

Database: Uses your PostgreSQL user name and password to connect to PostgreSQL.

Kerberos:

Uses Kerberos authentication to connect to PostgreSQL.

When you choose this option on Windows, ensure that the user account that starts the Secure Agent service is available in the PostgreSQL database. You don't need to enter your credentials to access PostgreSQL.

You can't configure Kerberos authentication when you use a Hosted Agent or serverless runtime environment.

Select the required authentication type and then configure the authentication-specific parameters.

Default is Database.

Connect to PostgreSQL

Database authentication

Kerberos authentication

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

PostgreSQL Connector

PostgreSQL Connector

Authentication types

Authentication types