Skip to main content

PostgreSQL

Boltic supports Integration with SQL databases like PostgreSQL. It fetches data from your PostgreSQL data source and allows you to create a Pipe that contains a sequence of actions such as source integration, choosing databases and destination integration. In addition to this, you can schedule a pipe at a fixed interval or date and time.

Getting Started​

Requirements​

To integrate PostgreSQL as a source, you'll need:

  1. PostgreSQL User Access

    • A PostgreSQL user with read access to both:
      • The target database
      • The local database

  2. SSH Details

    • SSH access details (if using an SSH tunnel server)
    • A private key for secure connections

  3. IP Whitelisting

    • Visit our IP Whitelisting Guide for whitelisting IPs and CIDR ranges to ensure secure access to your database or service.

  4. PostgreSQL Configuration

    • To ensure that Change Data Capture (CDC) functions seamlessly, proper configuration of PostgreSQL is essential. For comprehensive instructions on setting up PostgreSQL for CDC, please check out the PostgreSQL Configuration documentation.

Setup Guide to Integrate PostgreSQL With Boltic​

This guide will give you a brief idea of what steps you need to follow to integrate PostgreSQL into Boltic.

  1. Integration Name: Enter a unique name for this integration.

    Integration Name

  2. Host Details:

    ParameterDescription
    Host nameIP address of the PostgreSQL server.
    Port NumberEnter PostgreSQL port number (default is 5432).
    Database NameName of the database to connect to (required).

    Using Host

Authentication​

To validate the identity of database users and ensure high-level security, authentication can be done using the following methods:

  • Username and Password (Required)

  • SSH Authentication (If needed):

  • SSH Host

  • SSH Port

  • SSH Username

  • SSH Authentication Method (supports private key and password). For more details, refer to SSH Authentication.

Additional Info​

Provide metadata to enhance data management:

FieldDetails
TagsUse tags for easy data discovery for you and your team.
DescriptionProvide a detailed and meaningful description of your database.

Tags & Description

Test & Save​

Click on Test & Save to validate your data source configuration and confirm that the connection is successfully established.

Test & Save

Congratulations! You have successfully integrated PostgreSQL with Boltic.

🤓 Have Questions?​

We're here to help! Feel free to reach out via email at 📧 [email protected].