# 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.](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/CHAP_AuroraOverview.html)
### 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
* **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
* 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
* 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!**
