Integrations

POSTGRE SQL

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

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.

sign up
Swirls

Datagran x POSTGRESQL

Use Datagran x PostgreSQL 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. Follow the next steps to do so: For each database sources, we require a user with permissions to read the table where data is stored. These are the requirements:

  • 1. Host or IP address
  • 2. UsernamePassword
  • 3. Database name
  • 4. Table name

a. 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;

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; Use the query below:

STEP BY STEP

Head over to your Workspace > Project > Integrations. Click on PostgreSQL Integration.
A dashboard of data sources
Enter the information requested in the form below. Click next. Then select the table you wish to extract and click Finish.
A dashboard
Datagran logo
Made with LOVE in San Francisco
Product hunt badge

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

44 Montgomery St. 3rd Floor, San Francisco CA 94104