PostgreSQL
Boltic supports Integration with SQL databases like PostgreSQL. It fetches data from your PostgreSQL data source and allows you to create a Bolt that contains a sequence of actions such as Integration, Transformation, and Destination. In addition to this, you can schedule a Bolt at a fixed interval or date and time.
Note
You will need to Whitelist the following IPs to allow Boltic to connect to your database:
3.108.32.225 , 13.234.253.96
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.
Step 1: Add Integration
First, visit the Add Integration page to select PostgreSQL as an integration.
Step 2: Configuration
Once you select PostgreSQL the data source into Boltic, provide the following details to your Configure PostgreSQL Integration Page-
Description | |
---|---|
Host | A hostname is the IP address of the PostgreSQL. |
Port | A list of PostgreSQL port numbers. (Default- 5432) |
Database Name | Name of the Database that has to be connected. |
Step 3: Authentication
To validate the identity of database users and ensure high-level security, you can authenticate the database by using any combination of the methods mentioned below-
Option 1- Basic Authentication
Username
Password
Option 2- SSH Authentication
Note
Basic authentication and SSH can also work together or independently.
Step 4: Test & Save
To validate data source configuration, click on the Test & Save, and determine whether the connection is successfully established or not.
Add Info
Its metadata, which includes description can be used for surfacing information to end-users and as tags for monitoring. Click on the More Options button to enter the metadata.
Congratulations
You have now successfully integrated your PostgreSQL database to Boltic!
Any Question? 🤓
We are always an email away to help you resolve your queries. If you need any help, write to us at - 📧 support@boltic.io