PostgreSQL

Introduction

PostgreSQL also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with Atomicity, Consistency, Isolation, Durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users.

Read more about its features and how to get started with the popular platform here.

Step By Step Guide

Step 1: Click on Data Warehouses tab in the left side bar navigation to reach the Data Warehouses Module as shown below.
Step 2: Click on Add New to add an additional Data Warehouse to your account.
Step 3: Select PostgreSQL from the Storage Type drop down options.
Step 4: Enter the details about your PostgreSQL in the form and click on Save to add the warehouse. An explanation of each of the fields in the form has been given below.

Field	Description
Data Warehouse Name	*Required* Provide a name for your warehouse. It needs to be unique across your account. This can be accessed from the Warehouses Tab.
Host Name	*Required* Provide a host name for your warehouse. PostgreSQL hostname defines the location where your PostgreSQL database is hosted. You need to specify the PostgreSQL hostname so that DataChannel knows where to connect.
Username	*Required* Provide a username which will be used to create the tables and load data. This user needs to have all rights on the database, datawarehouse(only usage), and the schema you intend to use. In case you are creating a dedicated schema for the data from DataChannel (which is recommended,then this user can be the schema owner.
Password	*Required* Provide the password for the username entered above.
Port	*Required* Provide the port number.
DB Schema	*Required* Provide the database schema where DataChannel should push the data. It is recommended to create a new schema for DataChannel in your database.
DB Name	*Required* Provide the name of the database you have created in your PostgreSQL instance.

Field

Description

Data Warehouse Name

Required

Provide a name for your warehouse. It needs to be unique across your account. This can be accessed from the Warehouses Tab.

Host Name

Required

Provide a host name for your warehouse. PostgreSQL hostname defines the location where your PostgreSQL database is hosted. You need to specify the PostgreSQL hostname so that DataChannel knows where to connect.

Username

Required

Provide a username which will be used to create the tables and load data. This user needs to have all rights on the database, datawarehouse(only usage), and the schema you intend to use. In case you are creating a dedicated schema for the data from DataChannel (which is recommended,then this user can be the schema owner.

Password

Required

Provide the password for the username entered above.

Port

Required

Provide the port number.

DB Schema

Required

Provide the database schema where DataChannel should push the data. It is recommended to create a new schema for DataChannel in your database.

DB Name

Required

Provide the name of the database you have created in your PostgreSQL instance.

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.