Postgres Integration

Objective

Amazon Aurora, a cloud-based relational database, offers compatibility with PostgreSQL. This guide helps you connect quickly and implement various methods to extract data. Learn how simple it is to integrate an external database such as Amazon Aurora with ixHello.

For an introduction to Amazon Aurora, you can refer to the official documentation.

Pre-requisites

• An active AWS-Account

You should have an active AWS-Account. If you do not have it, you can create an AWS account at https://portal.aws.amazon.com/billing/signup#/start

• At least one Amazon Aurora Instance

If you do not have any Aurora DB instance, you can create one quickly.

• Login to AWS Management Console at https://console.aws.amazon.com/

• In the Search bar, enter Aurora.

• Select Aurora and RDS

• Scroll down and select Create Database

On clicking Create database, you will be redirected to the Engine options screen. Select Standard Create and Amazon Aurora (PostgreSQL Compatible).

Enter the credentials. The remaining information is generated automatically. Click "Create Database" to proceed.

The Aurora Instance should support remote connection, which can be done by making it publicly accessible.

After clicking "Create Database," you'll be taken to the Database Screen, where you can view the list of created databases.

Select the newly created database to view all the essential keys and information required for connecting to iX Hello.

Setup connection to PostgreSQL.

• Login to the iX Hello portal at https://bots.ixhello.com

• Click on the Studio Mode link at the Top of the page:

Browse to: Integration > Connect System as shown below. Click Add New Connection.

From the dropdown list, select PostgreSQL and press Next

Fill out the Configuration screen, The table below explains each of the inputs shown on this screen.

Input	Information
Service Instance Name	You can give any value of your choice.
Username	Username for PostgreSQL connection. Ensure this user has appropriate permissions
Database Name	The name of the Database that you want to connect to.
Host	Host Name or IP address of the Postgre SQL server. If your server is not using default port, specify it too. eg. x.x.x.x:5432
Port	PostgreSQL port number (default is 5432)

Fill the required information and click on Validate and Connect. If the details are correct, the integration will be saved, and you will be redirected back to the integrations listing page.

After the validation process finishes and the connection to PostgreSQL is established, a confirmation message will indicate the connection's success.

Congratulations, you have successfully integrated PostgreSQL to iX Hello!