Connecting to Postgres

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 'Create project' 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.