Integrate Data

PostgreSQL Integration

Analyze all your web, mobile, and other data sources. Act and predict from a single place.

Y Combinator startups, SMB’s and F500 companies have grown with us:

Why PostgreSQL?

PostgreSQL is a powerful, open source object-relational database system that extends SQL language combined with many features that safely stores and scales the most complicated data workloads. PostgreSQL comes with many features aimed to help developers build applications, administrators to protect data integrity, build fault-tolerant environments, and help you manage your data no matter how big or small the dataset. In addition to being free and open source, PostgreSQL is highly extensible. Learn more at aws.postgresql.org

Datagran x PostgreSQL

Use Datagran x Postgre integration to bring your structured data for:
Processing/Centralizing, Analyzing, Getting Predictions, Launching Optimized Campaigns, and much more, in one single place.

Getting Started

Before setup, a user with read-only access to your database must be created.

To setup a user with permissions to read the table where data is stored, follow these requirements:
1. Host or IP address  
2.
Username and Password  
3.
Database name   
4.
Table name

b. If the database contains different schemas, grant usage on schema GRANT USAGE ON SCHEMA public to username; Grant access to specific table GRANT SELECT ON table_name TO username; Watch the step by step process below:

a. Now, follow these steps to set up a read-only user:

  • Create a read-only user in PostgreSQL  CREATE USER username WITH PASSWORD 'secret'.
  • Grant connect access to the database  GRANT CONNECT ON DATA BASE database_name TO username;

3' 01"

Any questions? Need some help?
We have someone who can help you

Talk to a product specialist  ›
+ 1 856 -369 - DATA
156 2nd St, San Francisco, CA 94105
support@datagran.io

Other Links

Investors

For any request related with your personal information, please contact us here:
legal@datagran.ioTwitterInstagramLinkedInFacebookYoutube