# Setup Manual

#### This section includes:

* [Stepwise Instructions to Integrate GCP PostgreSQL with Daton](#stepwise-instructions-to-integrate-shopify-with-daton)
* [Workflow](#workflow)

## Stepwise Instructions to Integrate GCP PostgreSQL with Daton <a href="#stepwise-instructions-to-integrate-shopify-with-daton" id="stepwise-instructions-to-integrate-shopify-with-daton"></a>

## **Prerequisites** <a href="#prerequisites" id="prerequisites"></a>

* PostgreSQL
* Database name, Hostname and Password
* Port Number (usually `5432`)

### Integrate your GCP PostgreSQL Database with Daton

1. [Sign in](https://daton.sarasanalytics.com/login) to your existing Daton account.&#x20;
2. Search for GCP PostgreSQL in the list of Connectors and click on the **'Configure'** button.
3.  Provide the necessary **Integration Name**, **Replication Frequency**, and **Replication Start Date** data and click the **'Authenticate'** button.\
    \
    &#xNAN;_&#x50;lease Note, the **Integration Name** will be used in creating tables for the integration and cannot be changed later._&#x20;

    <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FBz3PD2lb29NgNi7aAHFT%2FGCP%20PostgreSQL1.png?alt=media&#x26;token=0a6b5ab9-756f-436d-a90e-db1b83715596" alt=""><figcaption></figcaption></figure>
4.  **Select** your GCP PostgreSQL Database Schema(s) data to be replicated. For the same, provide your PostgreSQL **'Database Host Name,' 'Port Number,' 'Database User Name,' 'Database User Password'** and the **'Database Name'** and click on **'Next.'** \
    \
    &#xNAN;_&#x59;ou can also secure your authentication by SSH tunneling. Click_ [_here_](../../../../faqs/faqs/how-to-enable-ssh-tunneling-during-a-database-source-authentication) _to know how._

    <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FdO2e4yinHYYoI2HO5gGi%2FGCP%20PostgreSQL2.png?alt=media&#x26;token=7db3c8d1-27a2-412b-88c6-781508b41696" alt=""><figcaption></figcaption></figure>
5.  Post selecting the Database, you will be prompted to choose schemas from the list. **Select** the desired Schemas and click on **'Next.'**&#x20;

    <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FIyiaqMeI3dOhiWl3E5RM%2FGCP%20PostgreSQL3.png?alt=media&#x26;token=700dca4b-20bd-4f4a-8187-cb32ba6f9c67" alt=""><figcaption></figcaption></figure>
6. Now **Select** all the Tables as per requirement and **Configure** the schema that you wish to create in the destination before clicking the '**Next'** button. \
   \
   &#xNAN;_**Note:**_
   * _You will have to check at least one Table from each of the previously selected Schemas to proceed further._&#x20;
   *   _Now you can customize the replication frequency and replication start date of each desired table separately. You may find this functionality under the **advanced settings** of every selected table._

       <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FfyvoYM0RdYBlG3wi1gQ8%2FGCP%20PostgreSQL4.png?alt=media&#x26;token=9c748bed-1a7a-42ac-a1f9-95b5b9d7c0d9" alt=""><figcaption></figcaption></figure>

       <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FFSQegcjQF2p2tYclQu8b%2Fimage.png?alt=media&#x26;token=afdc2cde-18db-4928-9ae8-0a4e1de81c8c" alt=""><figcaption></figcaption></figure>


7.  Select all the Columns you require for each table and **Submit** the integration. \
    \
    &#xNAN;_&#x53;elect the replication field for each table. Selecting **'None'** will lead to full table replication. Selection of any primary keys or dates will load data in an incremental manner._

    <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FHGvlTX6vvqhwUsQWCEbg%2FGCP%20PostgreSQL5.png?alt=media&#x26;token=eaee779e-af98-40b0-a20b-47c55a3754fe" alt=""><figcaption></figcaption></figure>

    <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FBYZp2SZzFqCLLqDjYAQN%2Fimage.png?alt=media&#x26;token=bc8fe545-cc3c-46aa-a672-0b18b8453ae8" alt=""><figcaption></figcaption></figure>
8.  Once submitted, you will be prompted to select the destination. Select your favorite destination and click on **'Confirm.'**

    \
    You will now receive a popup saying **'Integration Successful.'**

    Congrats! Your Database has been integrated with Daton.

## Workflow

1. Integrations would be in the **Pending state** _initially_ and will be moved to the **Active state** _as soon as the first job loads_ data successfully into the configured warehouse.
2. Users can **view** _job status and process logs_ from the integration details page by clicking on the integration name from the active list.
3. Users can **Re-Authenticate, Edit, Clone, Pause** or **Delete** the integration at any given time by clicking on the settings\
   You can also edit the integration to **change frequency** and **history**.
4. Each table in your integration can be accessed by clicking on the integration on the 'Sources' page. Here you may find the **status of each table,** the **last replicated time,** and **Reload access buttons**.

<table data-view="cards"><thead><tr><th align="center"></th><th data-hidden data-type="content-ref"></th></tr></thead><tbody><tr><td align="center"><mark style="color:blue;"><strong>Contact Us</strong></mark></td><td><a href="mailto:support@sarasanalytics.com">mailto:support@sarasanalytics.com</a></td></tr><tr><td align="center"><mark style="color:blue;"><strong>Menu</strong></mark></td><td><a href=""></a></td></tr><tr><td align="center"><mark style="color:blue;"><strong>Back to Top</strong></mark></td><td><a href="setup-manual">setup-manual</a></td></tr></tbody></table>
