Table of Contents

Search

  1. Preface
  2. Introduction to PostgreSQL Connector
  3. Connections for PostgreSQL
  4. Mappings and mapping tasks with PostgreSQL Connector
  5. PostgreSQL objects in mapping tasks
  6. Lookup transformation
  7. SQL transformation
  8. Migrating a mapping
  9. PostgreSQL SQL ELT optimization
  10. Data type reference

PostgreSQL Connector

PostgreSQL Connector

Configure SSL with serverless runtime environment

Configure SSL with serverless runtime environment

You can use the serverless runtime environment with PostgreSQL Connector to connect to an SSL-enabled PostgreSQL database.
Before you configure a secure PostgreSQL connection using the serverless runtime environment, complete the following prerequisite tasks to add the SSL certificates to the serverless runtime location:
  1. Create the following structure for the serverless agent configuration in AWS or Azure:
    <Supplementary file location>/serverless_agent_config
  2. Add the truststore and keystore certificates in the Amazon S3 bucket or Azure container in the following location in your AWS or Azure account:
    <Supplementary file location>/serverless_agent_config/SSL
  3. Copy the following code snippet to a text editor:
    version: 1 agent: agentAutoApply: general: sslStore: - fileCopy: sourcePath: SSL/<TrustStore_filename> - fileCopy: sourcePath: SSL/<KeyStore_filename>
    where the source path is the directory path of the certificate files in AWS or Azure.
  4. Ensure that the syntax and indentations are valid, and then save the file as
    serverlessUserAgentConfig.yml
    in the following AWS or Azure location:
    <Supplementary file location>/serverless_agent_config
    When the .yml file runs, the SSL certificates are copied from the AWS or Azure location to the serverless agent directory.
  5. In the PostgreSQL connection properties, specify the following certificate path in the serverless agent directory in the
    Trust Store
    and
    Key Store
    fields:
    /home/cldagnt/SystemAgent/serverless/configurations/ssl_store/<cert_filename>

0 COMMENTS

We’d like to hear from you!