PostgreSQL

PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads.

Electrik.AI exports data from your marketing data source to a database destination of your choice. It is important to note that Electrik.AI itself is not a destination. A destination is required to export data from various marketing data sources using Electrik.AI

Create PostgreSQL connection in Electrik.AI

Step 1: Ensure you have following prerequisites to create a PostgreSQL Connection in Electrik.AI

  1. Database Connection Details such as Host, Port, DB Name, DB User, DB Password.
  2. Configure your firewall (if any) to allow access from our IP addresses.
  • 35.223.21.196
  • 35.223.76.77
  • 35.188.97.12
  • 34.74.190.66
  • 35.185.113.93
  • 34.73.203.5

Step 2: Signup for your Electrik.AI account

Step 3: Sign-in into your Electrik.AI account

Step 4: Select IO in Electrik.AI dashboard

App Dashboard-Electrik.AI

Step 5: Select the Connections Icon in the left most panel and Click on “Add” button the top.

Add Connections-Electrik.ai

Step 6: Click on “PostgreSQL” icon to create a Google Cloud Storage connection.

New postgreSQL connection-Electrik.ai

Step 7: Enter PostgreSQL database connection details, and click on “Save”.

PostgreSQL connection details-Electrik.ai

Step 8: Congratulations you have successfully created a PostgreSQL database connection in Electrik.AI

Successfully Created a PostgreSQL Database-Electrik.AI