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 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

• 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. 
  • GCP MySQL Host Name
  • GCP MySQL Port Number
  • GCP MySQL User Name
  • GCP MySQL User Password
  • GCP MySQL Database Name

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

For further information, refer to the FAQs section on "How to Enable SSH Tunneling during a Database Source Authentication?"

• Post Database Authentication, you will be prompted to choose schemas from the list. Select the desired Schemas and click Next. 

• Select all the Tables as per requirement and Configure the schema that you wish to create in the destination before clicking the Next button.
  Note:

   

   
  
• 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 here.

• 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.
• Users can check job status and process logs from the integration details page by clicking on the integration name in the active list.
• 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. 
• 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.