> For the complete documentation index, see [llms.txt](https://daton-sarasanalytics.gitbook.io/daton/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/databases/gcp-mysql/how-to-integrate-gcp-mysql-with-daton.md).

# How to Integrate GCP MySQL with Daton

### Prerequisites

Before we get started, make sure you have:

* A GCP MySQL and a Daton account
* GCP MySQL Host Name
* GCP MySQL Port Number
* GCP MySQL User Name
* GCP MySQL User Password
* GCP MySQL Database Name

### Integrate your GCP MySQL Database with Daton

* Log in to your [Daton account](https://daton.sarasanalytics.com/u/integrations-list) and search for GCP MySQL in the list of Connectors, then click **Configure**.
* Enter the following details and click **Authenticate**: 

  * Integration Name
    * Optionally, add a description to identify the integration.
  * Replication Frequency 
  * Replication Start Date

  <figure><img src="/files/6YspWMdXMwRnoBaCiOGA" alt=""><figcaption></figcaption></figure>

  **Note** that the Integration Name will be used to create the integration tables and cannot be modified later.
* Provide the following GCP MySQL credentials and click **Next.**&#x20;

  * GCP MySQL Host Name
  * GCP MySQL Port Number
  * GCP MySQL User Name
  * GCP MySQL User Password
  * GCP MySQL Database Name

  <figure><img src="/files/qMcBNhYx5YAsguqMh3RT" alt=""><figcaption></figcaption></figure>

  You can also secure your authentication by SSH tunneling. You can find this option at the bottom of this page.

  <figure><img src="/files/Mb2rsGyxDRuaE1Jc4ncv" alt="" width="375"><figcaption></figcaption></figure>

  For further information, refer to the FAQs section on ["How to Enable SSH Tunneling during a Database Source Authentication?"](/daton/faqs/faqs/how-to-enable-ssh-tunneling-during-a-database-source-authentication.md)
* Post Database Authentication, you will be prompted to choose schemas from the list. **Select** the desired Schemas and click **Next.** &#x20;

  <figure><img src="/files/2vzHO8jGRtPC1glg4xBA" alt=""><figcaption></figcaption></figure>
* **Select** all the Tables as per requirement and **Configure** the schema that you wish to create in the destination before clicking the **Next** button.&#x20;

  <figure><img src="/files/XxRJGhGMRrqJ3VxrqAVg" alt=""><figcaption></figcaption></figure>

  **Note**:&#x20;

  * You will have to check at least one Table from each of the previously selected Schemas to proceed further.&#x20;
    * You can also 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.
    * Select all the Columns you require for each table and **Submit** the integration.&#x20;

  <figure><img src="/files/zJhtOP6mwIZOV0nzrwbq" alt=""><figcaption></figcaption></figure>

  It's recommended to select a replication field for each of the tables. Selecting **'None'** will lead to full table replication. Learn more about [Replication Fields](/daton/platform/features/data/data-replication-in-daton/replication-fields.md) here.

  <figure><img src="/files/xgbWCEtg7VDWUXyxE51j" alt="" width="375"><figcaption></figcaption></figure>

  \
  **Note** that you will be prompted to select the destination for your Database.
* Select the destination for your store or shop and click **Confirm**. An integration successful message will be displayed.

## Important Note

* Integrations would begin in the Pending state and change to the Active state once the first job successfully loaded data into the configured warehouse.&#x20;
* Users can check job status and process logs from the integration details page by clicking on the integration name in the active list.&#x20;
* Users can Re-Authenticate, Edit, Clone, Pause, or Delete the integration at any moment by clicking on settings. You can also adjust the frequency and history of the integration.&#x20;
* On the Sources page, click Integration to access each table in your integration. The page also shows the state of each table, the last replicated time, and the Reload access buttons.&#x20;