Pre-requisites

Before starting, ensure you have 

• An active Daton and Bubble Agency account. 
• Bubble API token.

Task 1: Generate API Token and Enable API Settings

Generate API Token

1. Navigate to your Bubble application dashboard, locate the Settings option in the main menu, and navigate to API.
2.  Scroll down and click the button that says Generate a new API token.
3. Bubble.io will automatically generate a unique and secure 32-character string. This string is your API token. Note it down or copy it to your clipboard for future use.

Enable API Settings

1. After token generation, go to your API settings.
2. Ensure that the following options are enabled by checking the boxes:
   1. Workflow API and backend workflows
   2. Data API
      • Under Data API, you will find a list of Data Types corresponding to your Bubble App domain. 
      • Check the boxes next to the specific Data Types you want Daton to fetch and load.

This ensures that your API token is created and configured to allow Daton access to your Bubble application's specified workflows and data types.

Task 2: Get the Bubble App Domain Name and Table Names

Get the Bubble App Domain Name

1. On your Bubble app dashboard, navigate Settings.
2. In the Settings section, click on the Domain/Email tab.
3. On the Domain/Email tab, you will find your Bubble app's Domain name. Note down the Domain name or copy it to your clipboard for future use.

By following these steps, you can easily locate and retrieve your Bubble app's Domain URL from the Settings section of your app dashboard.

Get the Bubble App Table Names

1. On your Bubble app dashboard, navigate Data.
2. In the Data section, you will find a list of Data Types. The names of these Data Types will be the table names that you will provide in Daton for data extraction.

Task 3: Integrate Daton with Bubble 

1. Log in to your Daton account and search for Bubble in the list of Connectors, then click Configure.
2. Enter or select the following details and click Authenticate: 
   • Integration Name. Note that the Integration Name will be used to create the integration tables and cannot be modified later.
   • Optionally, add a description to identify the integration.
   • Replication Frequency 
   • Replication Start Date
   • Optionally, expand the Advanced Configuration Options section and, based on your requirements, modify the options to control the loading behavior of Daton.
3. Provide the following in the required fields to authenticate the integration. Then click Authenticate.
   • Bubble API Token 
   • Bubble Domain URL: The Domain URL should be in the format, https://example.com (Refer to Task 2 for steps to get the Domain Name)
   • Table Names

     Note:  

     - The Table Name field is the determining factor for table data in the destination schema. 

     - At least one Table Name should be provided as it is a mandatory field.

     - The first Table Name provided must be accurate to avoid Authentication failure.

     - A maximum of 5 reports can be allocated in a single integration.

     - Tables in the destination will be named as Report_1, Report_2, and so forth. 

      
4. After successful authentication, you will be prompted to choose from the list of the reports provided in the 3rd step.
   • Select the reports you want to replicate and click Next. Based on your requirement, select specific options for each selected table.
   • Note that you will be prompted to select the destination for your account.
5. Select the destination for extracting Bubble data for replication and click Confirm. An integration successful message will be displayed.
    

Important Note

• The tables would show a ‘Scheduled’ status and change to the 'Success' status 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 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.