> For the complete documentation index, see [llms.txt](https://docs.ixhello.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.ixhello.com/ixhc/connections/postgres-integration.md).

# Postgres Integration

### Objective <a href="#toc46444535" id="toc46444535"></a>

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 <a href="#toc46444536" id="toc46444536"></a>

* **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**

<figure><img src="/files/TuWViFId41jPXzyi2bXh" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/YXZYqtfeTiLijPM0cjtr" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/KgsOYae52W9wah7DFOSx" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/qe3qTapeRSI3rpc3BoDK" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/JfG1mpu8hF2Nn6LLlSnF" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/Ja66P5aTrkICpe2DEdzj" alt=""><figcaption></figcaption></figure>

### **Setup connection to PostgreSQL.** <a href="#hlk56341408" id="hlk56341408"></a>

* Login to the iX Hello portal at <https://bots.ixhello.com>
* Click on the Studio Mode link at the Top of the page:

<figure><img src="/files/PoJHq4fqOtWQmBPxWdHM" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/Ml3kbS3QAUEHwjyAOlOp" alt=""><figcaption></figcaption></figure>

From the dropdown list, select **PostgreSQL** and press **Next**

<figure><img src="/files/TRgyGjqW2ghztMmUDvmg" alt=""><figcaption></figcaption></figure>

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.

<figure><img src="/files/k1mMIe49hg6RaIhXHrvL" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/fXsHB1sP0cPHqjdYsVV8" alt=""><figcaption></figcaption></figure>

**Congratulations, you have successfully integrated PostgreSQL to iX Hello!**


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.ixhello.com/ixhc/connections/postgres-integration.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.