Kantata
Kantata is an online project management software. Besides project management, it has time tracking, resource planning, collaboration, finance etc. functions.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | ACCOUNT_MEMBERSHIP, ASSIGNMENT, EXPENSE, ESTIMATE, ESTIMATE_SCENARIO, ESTIMATE_SCENARIO_RESOURCE, ROLE, SKILL, SKILL_MEMBERSHIP, TIME_ENTRY, WORKSPACE, WORKSPACE_GROUP, WORKWEEK, and WORKWEEK_MEMBERSHIP tables. |
| History mode | check | RATE_CARD_HISTORY and RATE_CARD_SET_HISTORY tables |
| Custom data | check | STORY, WORKSPACE, and WORKSPACE_GROUP tables |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API |
Setup guide
Follow our step-by-step Kantata setup guide to connect Kantata with your destination using Fivetran connectors.
Sync overview
To capture deleted records, Fivetran can use the Subscribed Events mechanism for the following tables:
TIME_ENTRYASSIGNMENTWORKSPACEWORKSPACE_ALLOCATIONEXPENSESKILLSKILL_MEMBERSHIPROLEACCOUNT_MEMBERSHIPESTIMATEESTIMATE_SCENARIOESTIMATE_SCENARIO_RESOURCEUSERWORKWEEK_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 information
This schema applies to all Kantata connectors.
To zoom, open the ERD in a new window.