Connecting to Postgres

Note

This documentation is prior to May 2022.

Postgres allows you to store large and sophisticated data safely. It helps developers to build the most complex applications, run administrative tasks and create integral environments.

Postgres is used as the primary data store or data warehouse for many web, mobile, geospatial, and analytics applications.

There are three options to connect to Postgres:

• Creating a Project
• Edit an existing project connection
• Export data from the Export >Run recipe button

Connecting to Postgres when creating a new project

1. Click Enrich. The Enrich page is displayed.
2. Click  in the upper-right hand corner.  The Create a new project window is displayed.
   
3. Type in a new project name. The project name needs to be unique.
4. Select a use case from the drop-down. 
5. Click Create project. The Upload a dataset window appears.
    
6. Select Postgres. The following screen is displayed for a new database connection creation:
   
7. All the fields are mandatory. Choose a connection name.
8. Type in the Host.
9. Type in the Port number.
10. Type in the Database name.
11. Type in the User name.
12. Type in the Password.
13. Type in the Temp Schema.
14. Click Create. A message is displayed that the connection was successfully created. If the test connection failed, then you are unable to create a connection.

Connecting to Postgres when editing a dataset

1. Click Enrich. The Enrich page is displayed.
2. Create or search for a project.
3. Click .
   
4. The Change data and edit dataset window is displayed.  Click Continue.
5.  Select Postgres. The following screen is displayed for a new database connection creation:
   
6. All the fields are mandatory. Choose a connection name.
7. Type in the Host.
8. Type in the Port number.
9. Type in the Database name.
10. Type in the User name.
11. Type in the Password.
12. Type in the Temp Schema.
13. Click Create. A message is displayed that the connection was successfully created. If the test connection failed, then you are unable to create a connection.

Exporting data

1. Click Enrich. The Enrich page is displayed.
2. Create, search or edit a project.
3. Click the Export >Run Recipe.
   
4. The Schedule Recipe Run window is displayed.
   
5. Select the input connection (optional).
6. Select the output connection.