Configure PostgreSQL Connection Details

PostgreSQL is a powerful open-source relational database management system known for its extensibility and compliance with SQL standards. It offers advanced features, robust performance, and strong support for complex data types.

After you save the connection details for your PostgreSQL RDBMS, you can start using it as a data source in your data pipelines.

The Lazsa Platform offers various options for retrieving database credentials to establish a secure connection. You can either directly provide the credentials within the connection details, where they are securely stored in the Lazsa-managed secret manager. Alternatively, you can choose to retrieve credentials programmatically from your designated secrets management tool.

To configure the connection details of your PostgreSQL RDBMS, do the following:

1. Sign in to the Lazsa Platform and click Configuration in the left navigation pane.
2. On the Platform Setup screen, on the Cloud Platform, Tools & Technologies tile, click Configure.
3. On the Cloud Platform, Tools & Technologies screen, in the Databases and Data Warehouses section, click Configure.
   (After you save your first connection details in this section, you see the Modify button here.)
   

4. In the list of available database and data warehouse options, click .

5. On the RDBMS screen, do the following:

   1. In the Details section, provide the following details:

      Field	Description
      Name	Give a unique name to your PostgreSQL configuration. This name is used to save and identify your PostgreSQL connection details within the Lazsa Platform.
      Description	Provide a brief description that helps you identify the purpose or context of this PostgreSQL configuration.

   2. In the Configuration section, provide the following information:

      Field	Description
      Select RDBMS Subtype	Select PostgreSQL from the dropdown list.
      Host	Specify the host or IP address of the server where your PostgreSQL RDBMS is running.
      Port	Enter the port number on which your PostgreSQL RDBMS is listening for connections.
      Database Name	Provide the name of a specific database within your PostgreSQL RDBMS that you want to connect to.

   3. Depending on how you want to retrieve the credentials to connect to your PostgreSQL RDBMS, do one of the following:

      Field	Description
      Connect using Lazsa Orchestrator Agent	Turn on this toggle to use Lazsa Orchestrator Agent to programmatically resolve your PostgreSQL credentials stored in your secrets management tool within your private network and to establish communication with the PostgreSQL instance. In the Lazsa Orchestrator Agent dropdown list, all your configured agents are displayed. Select the one you want to use to connect to your PostgreSQL instance. The secrets management tool that the selected Orchestrator Agent is authorized to access for retrieving secrets is auto-selected. Currently, we support AWS Secrets Manager and Azure Key Vault. Specify the details of PostgreSQL secrets that the agent should retrieve from the secrets management tool. For AWS Secrets Manager, provide the secret name, username key, and password for your PostgreSQL credentials. For Azure Key Vault, provide the vault name, username secret, and password secret for your PostgreSQL credentials.
      Select Secret Manager	If you don't use the Lazsa Orchestrator Agent, you can directly provide the credentials in the configuration, or retrieve them from a secrets management tool of your choice (such as AWS Secrets Manager or Azure Key Vault). Do one of the following: Select Lazsa and type your PostgreSQL username and password. In this case, the user credentials are securely stored in the Lazsa-managed secrets store.   Select AWS Secrets Manager. In the Secrets Management Tool dropdown list, the AWS Secrets Manager configurations that you save and activate in the Secret Management section on the Cloud Platform, Tools & Technologies screen are listed for selection. Select the configuration of your choice. Provide the Secret Name, Username Key, and the Password Key for the Lazsa Platform to retrieve the secrets for your PostgreSQL RDBMS. Select Azure Key Vault. In the Secret Management dropdown list, the Azure Key Vault configurations that you save and activate in the Secret Management section on the Cloud Platform, Tools & Technologies screen are listed for selection. Select the configuration of your choice. Provide the Vault Name, Username Secret, and Password Secret for the Lazsa Platform to retrieve the credential values.

   4. Use SSL
      This toggle allows you to enable or disable a secure connection using SSL (Secure Sockets Layer) for communication between the Lazsa Platform and PostgreSQL. Enabling SSL enhances the security of data transmission by encrypting the communication channel.  To enable SSL, do one of the following:

   Option	Description
   Without using certificate	Clear the Use Certificate checkbox to use SSL without certificates.
   Use Certificate	To use SSL with certificates, use one of the following options: Use Existing Certificate Choose the storage type where you have stored your SSL certificate. Currently, the following storage options are supported: Databricks File System (DBFS) AWS S3 Upload New Certificate Browse to a location and upload an SSL certificate or drop an SSL certificate for upload. The supported file type is .PEM and the maximum permissible file size is 2 MB.

   5. JDBC String Parameters (Optional)
      JDBC (Java Database Connectivity) is a Java-based API that enables a client to interact with relational databases. The JDBC Connection String is a URL-like string that provides the necessary details for establishing a connection to PostgreSQL from the Lazsa Platform.
   Here is an example of a JDBC string:
   Based on the inputs that you provide, the Generated JDBC Connection String is displayed. The string consists of: host, port, database name, JDBC string parameters.
   
   6. Test Connection
      Click Test Connection to validate whether you have configured the correct connection details and you can connect to your PostgreSQL RDBMS Server successfully.
   7. Secure configuration details with a password
      To password-protect your PostgreSQL RDBMS connection details, turn on this toggle, enter a password, and then retype it to confirm. This is optional but recommended. When you share the connection details with multiple users, password protection helps you ensure authorized access to the connection details.
      

   8. Click Save Configuration. The configured connection details, you can see the configuration listed on the Databases and Data Warehouses screen.
      
      
      

Recommended Topics

What's next? Data Visualization