PostgreSQL popularly known as Postgres, is a powerful, open-source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale data workloads.
To integrate PostgreSQL with AI Squared, you need to establish a destination connector. This connector will enable AI Squared to extract data from your PostgreSQL database efficiently. Below are the steps to set up the destination connector in AI Squared:
destinations
section where you can manage your data destinations.Add destination
button.PostgreSQL
from the list of available destination types.You’ll need to provide the following details to establish a connection between AI Squared and your PostgreSQL database:
Host
The hostname or IP address of the server where your PostgreSQL database is hosted.
Port
The port number on which your PostgreSQL server is listening (default is 5432).
Database
The name of the database you want to connect to.
Schema
The schema within your PostgreSQL database you wish to access.
Username
The username used to access the database.
Password
The password associated with the username.
Enter these details in the respective fields on the connector configuration page and press continue.
By following these steps, you’ve successfully set up a PostgreSQL destination connector in AI Squared.
PostgreSQL popularly known as Postgres, is a powerful, open-source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale data workloads.
To integrate PostgreSQL with AI Squared, you need to establish a destination connector. This connector will enable AI Squared to extract data from your PostgreSQL database efficiently. Below are the steps to set up the destination connector in AI Squared:
destinations
section where you can manage your data destinations.Add destination
button.PostgreSQL
from the list of available destination types.You’ll need to provide the following details to establish a connection between AI Squared and your PostgreSQL database:
Host
The hostname or IP address of the server where your PostgreSQL database is hosted.
Port
The port number on which your PostgreSQL server is listening (default is 5432).
Database
The name of the database you want to connect to.
Schema
The schema within your PostgreSQL database you wish to access.
Username
The username used to access the database.
Password
The password associated with the username.
Enter these details in the respective fields on the connector configuration page and press continue.
By following these steps, you’ve successfully set up a PostgreSQL destination connector in AI Squared.