Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

PostgreSQL

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Saras Pulse

    • Saras Daton

      • Saras IQ

        Need help with something?

        Talk to data expert

        PostgreSQL

        PostgreSQL ETL connector for data replication

        Snapshot

        Features Details
        Release Status Released
        Table Selection Yes
        Column Selection Yes
        Edit Integration Yes
        Replication Type Selection Yes
        Authentication Parameters Hostname
        Database Username
        Database Password
        Database Port
        Replication Type Full Replication
        Key Based Incremental
        Replication Key Date
        Table Primary/Unique Keys
        Suggested Replication Frequency 1 hr

        Integrate PostgreSQL with Daton

        1. Signin to Daton 
        2. Select PostgreSQL from the list of Integrations 
        3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later 
        4. Provide PostgreSQL database hostname, port, username, and password 
        5. Post successful authentication, you will be prompted to choose from the list of available database schemas
        6. Select required tables from the list for each database schema
        7. Then select required fields for each table. 
        8. Select replication field for each table. 'Select None' will lead to full table replication. Selection of any primary keys or dates will load data in incremental manner
        9. Submit the integration

        Workflow

        1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
        2. Users would be able to edit/pause/re-activate/delete integration anytime
        3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

        Was this article helpful?

        Yes
        No
        Give feedback about this article

        Related Articles

        • Essential Attributes and Supported Tables for Amazon DSP
        • Essential Attributes and Supported Tables
        • Google Ads: Essential Attributes and Schema Information
        • Pipeline Jobs

        Table of Contents

        Snapshot Integrate PostgreSQL with Daton Workflow

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Experts
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Follow Us

        Linkedin Youtube

        Company

        • Customers
        • Partner With Us
        • Contact Us

        Culture

        • About
        • People
        • Careers

        Offerings

        • Daton
        • For Brands
        • For Agencies

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA

        Follow Us

        Linkedin Youtube

        DISCLAIMER: Various trademarks are held by their respective owners

        © 2023 sarasanalytics.com

        Sitemap

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Sales
        DISCLAIMER: Trademarks are held by their respective owners
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Company

        • Customers
        • Partners
        • About
        • People
        • Careers
        • Contact Us

        Offerings

        • Daton
        • Solution for Brands
        • Solution for Agencies
        • Dashboards
        • Founder's Note
        • Status

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA
        • Sitemap

        © 2023 sarasanalytics.com

        Linkedin Youtube

        Knowledge Base Software powered by Helpjuice

        Expand