Beans Route
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.
- Access to your Beans Route Dispatch Manager and API Manager (typically an Owner or Administrator of your Beans Route account)
In your Beans Route account, access the dispatch manager
- Navigate to the Settings > API Console from the dropdown menu in the page header menu of the web page portal
- Click on the Create New Key button
- 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
- 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.
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:
- Enter a Name or Alias for this connection, in the Name/Alias field, that is unique from other connectors.
- 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.
- 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
- 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.
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 |
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.
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.
