•  Introduction to PostgreSQL Connector
  •  PostgreSQL Connector assets
•  Connections for PostgreSQL
  •  Prepare for authentication
    •  Prepare for Kerberos authentication
  •  Connect to PostgreSQL
    •  Before you begin
    •  Connection details
    •  Authentication types
    •  Advanced settings
    •  Encryption types
    •  Related links
  •  Configure SSL with serverless runtime environment
•  Mappings and mapping tasks with PostgreSQL Connector
  •  PostgreSQL sources in mappings
    •  Adding multiple source objects
    •  Rules and guidelines for adding multiple source objects
  •  Configuring key range partition
  •  PostgreSQL targets in mappings
    •  Specifying a target
    •  Override the target query
  •  PostgreSQL lookups in mappings
  •  Rules and guidelines for custom query, SQL override, and batch size
•  PostgreSQL objects in mapping tasks
  •  PostgreSQL sources in mapping tasks
  •  PostgreSQL targets in mappings
    •  Rules and guidelines for error files
  •  Dynamic schema handling for mappings
    •  Rules and guidelines for dynamic schema handling in mappings
•  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
  •  SQL ELT optimization functions and operators
  •  SQL ELT optimization operations and transformations
  •  Configuring a PostgreSQL ODBC connection
    •  Configuring a PostgreSQL ODBC connection on Windows
    •  Configuring a PostgreSQL ODBC connection on Linux
  •  Create an ODBC connection
  •  Cross-schema SQL ELT optimization
    •  Configuring cross-schema SQL ELT optimization for PostgreSQL mapping
•  Data type reference
  •  PostgreSQL and transformation data types
  •  PostgreSQL and transformation data types supported for create target at runtime option
  •  Rules and guidelines for data types

Introduction to PostgreSQL Connector

Rules and guidelines for data types

REL_POSTGRESQL_CONN

REL_POSTGRESQL_CONN-CONN_NAME

REL_POSTGRESQL_CONN-CONN_DESC

REL_POSTGRESQL_CONN-CONN_TYPE

REL_POSTGRESQL_CONN-AGENTGROUPID

REL_POSTGRESQL_CONN-AUTHENTICATIONTYPE

REL_POSTGRESQL_CONN-AUTHENTICATIONTYPE-DATABASE

REL_POSTGRESQL_CONN-DATABASE-USERNAME

REL_POSTGRESQL_CONN-DATABASE-PASSWORD

REL_POSTGRESQL_CONN-HOSTNAME

REL_POSTGRESQL_CONN-PORT

REL_POSTGRESQL_CONN-DATABASE

REL_POSTGRESQL_CONN-AUTHENTICATIONTYPE-KERBEROS

REL_POSTGRESQL_CONN-KERBEROS-SERVICEPRINCIPALNAME

REL_POSTGRESQL_CONN-KERBEROS-KERBEROSCONNECTIONPROPERTIES

REL_POSTGRESQL_CONN-SCHEMA

REL_POSTGRESQL_CONN-CONNECTIONENVIRONMENTSQL

REL_POSTGRESQL_CONN-ADDITIONALCONNECTIONPROPERTIES

REL_POSTGRESQL_CONN-ENCRYPTIONMETHOD

REL_POSTGRESQL_CONN-ENCRYPTIONMETHOD-NOENCRYPTION

REL_POSTGRESQL_CONN-ENCRYPTIONMETHOD-SSL

REL_POSTGRESQL_CONN-VALIDATESERVERCERTIFICATE

REL_POSTGRESQL_CONN-TRUSTSTORE

REL_POSTGRESQL_CONN-TRUSTSTOREPASSWORD

REL_POSTGRESQL_CONN-HOSTNAMEINCERTIFICATE

REL_POSTGRESQL_CONN-KEYSTORE

REL_POSTGRESQL_CONN-KEYSTOREPASSWORD

REL_POSTGRESQL_CONN-KEYPASSWORD

REL_POSTGRESQL_CONN-SSLV3

REL_POSTGRESQL_CONN-TLSV1_2

REL_POSTGRESQL_CONN-ENCRYPTIONMETHOD-REQUESTSSL