# 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
## **Prerequisites**
* 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.
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;*Please Note, the **Integration Name** will be used in creating tables for the integration and cannot be changed later.*
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;*You can also secure your authentication by SSH tunneling. Click* [*here*](https://daton-sarasanalytics.gitbook.io/daton/faqs/faqs/how-to-enable-ssh-tunneling-during-a-database-source-authentication) *to know how.*
5. Post selecting the Database, you will be prompted to choose schemas from the list. **Select** the desired Schemas and click on **'Next.'**
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.*
* *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.*
7. Select all the Columns you require for each table and **Submit** the integration. \
\
\&#xNAN;*Select 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.*
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**.
