Release Notes

August 2024

We have renamed our Mavenlink connector to Kantata. This name change applies to the Fivetran dashboard and our documentation.

June 2024

We have added a new table, STATUS_REPORT, for syncing Kantata status report data. For more information, see Kantata's developer docs.

We are gradually rolling out this change to all customers.

May 2024

We have added a new table, ACCOUNT_LOCATION. We are gradually rolling out this change to all customers.

April 2024

We have added a new column, primary_workspace_group_id, to the WORKSPACE table.

March 2024

You can now exclude tables from the sync. On your connector details page, go to the Schema tab and deselect the tables you want to exclude from the sync.

IMPORTANT: You can exclude any table except the USER table.

October 2023

We now re-import the USER and WORKSPACE_ALLOCATION tables once a week to ensure data integrity.

August 2023

We have added the following new columns to the WORKWEEK_MEMBERSHIP and WORKWEEK tables:

created_at
updated_at

We now incrementally sync the following tables:

ACCOUNT_MEMBERSHIP
ESTIMATE
ESTIMATE_SCENARIO
RATE_CARD_HISTORY
RATE_CARD_ROLE_HISTORY
RATE_CARD_SET_HISTORY
RATE_CARD_VERSION_HISTORY
ROLE
TIMESHEET_SUBMISSION
USER
WORKWEEK
WORKWEEK_MEMBERSHIP

May 2023

We have added the following new tables:

SKILL
SKILL_CATEGORY
SKILL_MEMBERSHIP

We are gradually rolling out this change to all existing connectors.

March 2023

We now support Subscribed Events to capture deletes in a more efficient way. For more information, see our Kantata setup guide. We are gradually rolling out this change to all existing connectors.

February 2023

We have added a new table, BILLABLE_UTILIZATION. For more information, see Kantata's Billable Utilizations documentation. We are gradually rolling out this change to all existing connectors.

June 2022

We now re-sync the following tables to capture deleted records:

WORKSPACE_ALLOCATION and EXPENSE - once a day
STORY_ALLOCATION_DAY table - once a week

May 2022

We now re-sync the WORKSPACE table once a day to detect deleted records.

August 2020

We have added a new table, TIME_OFF_ENTRY.

May 2020

You can now configure your Kantata connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.

September 2019

We have added two new tables, FIXED_FEE_ITEMS and INVOICE_FIXED_FEE_ITEMS.

March 2019

We have added two new tables, RATE_CARD_VERSION_HISTORY and RATE_CARD_ROLE_HISTORY.

February 2019

We now re-sync the ASSIGNMENT table daily to detect deleted records.

We have deprecated the RATE_CARD table and will remove the table after March 20, 2019.

We have added the RATE_CARD_HISTORY table to replace RATE_CARD and RATE_CARD_SET_HISTORY tables.

August 2018

We have added the manager_id column to the ACCOUNT_MEMBERSHIP table.

Kantata does not track deletes for the TIME_ENTRIES table, but Fivetran has a way to identify your deleted time entries. We re-sync the entire TIME_ENTRIES table every day, so our system can infer that any record that wasn’t updated with the re-sync must have been deleted. Each deleted record will be marked as true in the _fivetran_deleted column of this table.

June 2018

We have added the following new tables:

HOLIDAY
PARTICIPATION
HOLIDAY_CALENDAR
HOLIDAY_CALENDAR_ASSOCIATIONS
HOLIDAY_CALENDAR_MEMBSHIP
WORKSPACE_ALLOCATION
WORKSPACE_RESOURCE
WORKWEEK
WORKWEEK_MEMBERSHIP

We have added new columns in the following tables:

TABLE	NEW COLUMN(S)
ESTIMATE	updated_at
ESTIMATE_SCENARIO	created_at, updated_at
ESTIMATE_SCENARIO_RESOURCE	created_at, updated_at
RATE_CARD	created_at, updated_at
STORY_ALLOCATION_DAY	created_at
STORY_STATE_CHANGE	updated_at

May 2018

Kantata returns choice ID data for custom field types single and multi. We now fetch the choice value instead of the choice ID.

Kantata's custom field value type currency contains both cents and currency code data (for example, a currency value of [12,USD] = 12 cents USD). We have split currency data into two columns, <custom_field_name>_amount_in_cents and <custom_field_name>_currency_code.

April 2018

We have added support for logs for the following connectors:

Braintree
Apple App Store (formerly iTunes Connect)
Kantata