Edit on GitHub
Mavenlink link
Mavenlink is an online project management software. Besides project management, it has time tracking, resource planning, collaboration, finance etc. functions.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | We infer deletes through regular re-syncs from the ACCOUNT_MEMBERSHIP , ASSIGNMENT , EXPENSE , ESTIMATE , ESTIMATE_SCENARIO , ESTIMATE_SCENARIO_RESOURCE , ROLE , SKILL , SKILL_MEMBERSHIP , TIME_ENTRY , WORKSPACE , WORKSPACE_GROUP , WORKWEEK , and WORKWEEK_MEMBERSHIP tables. |
Custom data | check | STORY , WORKSPACE , and WORKSPACE_GROUP tables |
Data blocking | check | Column level |
Column hashing | check | |
Re-sync | check | Connector level |
History | check | RATE_CARD_HISTORY and RATE_CARD_SET_HISTORY tables |
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking |
Setup guidelink
Follow our step-by-step Mavenlink setup guide to connect Mavenlink with your destination using Fivetran connectors.
Sync overviewlink
To capture deleted records, Fivetran can use the Subscribed Events mechanism for the following tables:
TIME_ENTRY
ASSIGNMENT
WORKSPACE
WORKSPACE_ALLOCATION
EXPENSE
SKILL
SKILL_MEMBERSHIP
ROLE
ACCOUNT_MEMBERSHIP
ESTIMATE
ESTIMATE_SCENARIO
ESTIMATE_SCENARIO_RESOURCE
USER
WORKWEEK_MEMBERSHIP
The Subscribed Events mechanism is more efficient for tracking deleted records than table re-syncs. However, this mechanism has the following limitations:
- you must enable the Recent History add-on
- if, for some reason, the connector has not been synced for 6 days, then we are forced to re-sync tables for the first time because Subscribed Events are stored for a limited time.
Schema informationlink
This schema applies to all Mavenlink connectors.
To zoom, open the ERD in a new window.