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, ESTIMATE, EXPENSE, 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 |
Supported deployment models
We support the SaaS Deployment model for the connector.
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 connection 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.
To capture new records and deletes, we update the PARTICIPATION table entries for workspaces that have changes.
Schema information
This schema applies to all Kantata connections.
Explore Kantata schema ERD