website logo
⌘K
Getting Started 🚀
What is DataLakeHouse.io?
Our Business-Value Focus
Learn the Basic Concepts
Connectors
Operations Applications
Asana
Aloha POS
Baremetrics
Beans Route
BILL
Bloom Growth
Bullhorn
Calendly
Ceridian Dayforce
ClinicalTrials.gov
ConnectWise
DBT Cloud
DBT Cloud Log Stream
Facebook Ads
Food Delivery Service Connector
Google Analytics 4
Google Play
Harvest
Hubspot
Jira
MailChimp
McLeod Transportation
Microsoft Teams
NetSuite (Oracle NetSuite)
NetSuite SuiteAnalytics
Optimum HRIS
QuickBooks Online
Salesforce
Salesloft
Shift4 Payments
Shopify
Square
Square Marketplace
Stripe
Toast
TriNet
Verizon Wireless Business
Workday HCM
Xero
Zendesk Sell
Zoom
Databases
Files & Object Storage
SQL Data Query
SSH Tunnel Setup for Hosted Database Systems
SQL Playground Editor
SQL Transformations
DBT Cloud Transformations
Terraform: Reverse Terraforming
Sync Bridge (Data Pipelines)
Create a Sync Bridge
Manually Run a Sync Bridge
Deleting a Sync Bridge
Historical Re-sync
Analytics
Access Analytics
Snowflake Usage Analytics
Data Catalog
Create the Catalog
Populate the Catalog
Access the Catalog
Data Warehouse Clouds
❄️Snowflake
Open Source DW Models
Alerts & Notifications
Slack Notifications
Logs & Monitoring
Security
Callback Links
Service Level Agreement (SLA)
Release Notes
July 2023
June 2023
May 2023
April 2023
Q3 2022
Q4 2022
Community Overview
Contributor Agreements
Code Contribution Guide
About
Customer Support
License
Viewpoint
Credit Consumption Breakdown
Docs powered by
Archbee
website logo
Connectors
Operations Applications

Beans Route

8min

Beans Route is one of the first delivery, dispatch, and routing management systems to feature timesheets and scheduling. The platform increases driver's stops per hour with routing, optimization, and precise apartment directions, and enables users to manage any size delivery team.

Pre-Requisites

  • Access to your Beans Route Dispatch Manager and API Manager (typically an Owner or Administrator of your Beans Route account)

Configuring your Beans Route API

In your Beans Route account, access the dispatch manager

  1. Navigate to the Settings > API Console from the dropdown menu in the page header menu of the web page portal
    Document image
    
  2. Click on the Create New Key button
  3. In the Create New Key popup window, set the following values for the options available:
    • Check the Web option checkbox for the Platform option
    • Enter DataLakeHouse.io for the value in the Key Name field
    • Select the Everything including unverified data option in the other dropdown menu
    • Click on Create Key to save and create the new API key
    • Document image
      
    • Document image
      
  4. After creating the new key you will be able to retrieve the API key value. If it is not shown please refresh this API Key page, and the key should show in the listing on the page. Click the eye icon to reveal the key value.
    • NOTE: the API Key is the cryptic looking string value. If there is any word such as "Basic " in front of it, please ignore, and now copy the API Key and save it in a safe place so that you can provide it to either DataLakeHouse.io support or your customer success team for onboarding or for the self-service step when you create your Beans Route connection in DataLakeHouse.io.

Create a Beans Route Source Connection in DLH.io

DataLakeHouse.io securely connects to your account instance by securely using your API key on your behalf, using TLS AES-256 encryption, and only accesses read-only functionality.

Using the source connector form please complete the following basic steps:

  1. Enter a Name or Alias for this connection, in the Name/Alias field, that is unique from other connectors.
  2. Enter in the Target Schema Prefix field, a name that will be unique in your data cloud destination where you wish to land the data.
  3. Enter in the API Key field, the value from your API Keys area of your account.
    • Do NOT enter the "Basic " prefix for the API Key. Only enter the long cryptic looking string of characters which is your actual API Key
    • Document image
      
  4. After the successful connection click on the Create a Sync Bridge option to point to your target destination in order to begin the synchronization/replication of data.

Instructions Video



Data Replication Details

This section provides information on how data is replicated, at what frequency and which replication/synchronization details are worth noting from DLH.io.

Replication Frequency Configurations

Details

Default Replication Frequency

24 Hours

Minimum Frequency

1 Hour (lower on Business Critical plan)

Maximum Frequency

24 Hours

Custom Frequency

1-24 Hours

Replication Definitions

The following types of replication happen between this source and your target destination cloud data warehouse of choice when a Sync Bridge runs:

  • Historical Data Load (also First Time Sync)
    • Occurs during the first/initial data sync of the sync bridge pipeline and any time you need to or are requested to conduct a historical re-sync process for your data.
    • Here, DLH.io ingests all available data for the objects/tables you've selected or are available to you from the source based on your authentication access on that source.
    • This can take a relative elongated time to retrieve all data from the source and replicated to the target, as the name suggest it is retrieval all data, so if the source contains large amounts of data even in our parallel processing capability a customer could expect more than an hour for large data system. If there are any concerns that a historical load or first time sync has not completed within a reasonable amount of time please contact DLH.io Support.
  • Incremental (aka Deltas) Data Load
    • After a first time synchronization/replication or a historical data load, all subsequent processes of replicating the data for a Sync Bridge (source to target) are referred to as delta or incremental loads
    • Here, DLH.io captures the latest/newest records and/or events and any changes/updates to existing records and/or events in the source connector based on the frequency set in the Sync Bridge.


Issue Handling

If any issues occur with the authorization simply return to the sources page in DataLakeHouse.io, edit the source details and click the Save & Test or Authorize Your Account or Re-Authorize Account button to confirm connectivity. If any issues persist please contact our support team via the DataLakeHouse.io Support Portal.





Updated 16 Jul 2023
Did this page help you?
PREVIOUS
Baremetrics
NEXT
BILL
Docs powered by
Archbee
TABLE OF CONTENTS
Pre-Requisites
Configuring your Beans Route API
Create a Beans Route Source Connection in DLH.io
Instructions Video
Data Replication Details
Replication Definitions
Issue Handling
Docs powered by
Archbee