November 2018link
Customer triggered table re-syncslink
You can now trigger re-syncs of individual tables from your Fivetran dashboard:
The re-sync button appears when you hover your cursor over the row that contains the table name.
This feature is available for the following connectors:
- DynamoDB
- MongoDB
- MySQL
- NetSuite SuiteAnalytics
- Oracle
- PostgreSQL
- Salesforce
- SQL Server
- Zuora
TLS certificate verification changeslink
You are no longer able to configure self-signed certificates for destination connectors. We plan to release new UI tools in the coming weeks to empower security teams to register and pin certificate authorities with Fivetran.
New connectorslink
Google Analytics 360link
Google Analytics 360 provides the tools and support that enterprise teams need to get actionable insights from their data.
Read our Google Analytics 360 connector documentation.
Leverlink
Lever is a modern recruiting software that streamlines the hiring process and simplifies the applicant tracking system.
Read our Lever connector documentation.
ServiceNowlink
ServiceNow is a cloud platform that provides service management software as a service.
Read our ServiceNow connector documentation.
Schema changeslink
Greenhouselink
We have added a new column, name
, to the JOB
table.
We have added two new columns, start
and end
, to the SCHEDULED_INTERVIEW
table.
Iterablelink
We have replaced the locale_name
column with locale
in the following tables:
EMAIL_TEMPLATE_HISTORY
EVENT_EXTENSION
PUSH_TEMPLATE_HISTORY
SMS_TEMPLATE_HISTORY
Microsoft Advertisinglink
We no longer use brand
as the primary key for the following tables since it can have a null
value in the Bing Ads API response:
PRODUCT_DIMENSION_PERFORMANCE_HOURLY_REPORT
PRODUCT_DIMENSION_PERFORMANCE_DAILY_REPORT
PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_HOURLY_REPORT
PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_DAILY_REPORT
This change affects version 1 and version 2 of the Bing Ads API.
Salesforce Marketing Cloudlink
We have added a new column, version
, to the JOURNEY
table.
ServiceNowlink
We have removed the suffix _HISTORY
from all table names.
Taboolalink
We have designated _fivetran_id
as the only primary key in all REPORT
tables to account for null values in other fields.
Zendesk Supportlink
We have dropped the deleted
column from the GROUP
table.
Improvementslink
AWS CloudWatchlink
You can now have a space in your log group name without causing problems in your Fivetran dashboard.
Help Scoutlink
We have increased the Help Scout API rate limit, allowing us to easily retry our API connections when failures occur.
Intercomlink
We have released a new version of the Intercom connector, now with an improved schema. You can find additional information in our Intercom documentation.
Thanks to leveraging Intercom webhooks, we now support the delete
function in the following tables:
USER_HISTORY
LEAD_HISTORY
ADMIN
TEAM
SEGMENT_HISTORY
TAG
Jiralink
We have added support for OAuth, as Jira is deprecating basic authentication with password.
Microsoft Advertisinglink
We have released version 2 of the Microsoft Advertising connector, which allows you to fetch HOURLY
reports.
MySQLlink
We have identified and fixed an extremely rare bug that can cause data to be missed during binary log replication. The bug meant that, in some cases, our system believed that all data had been successfully synced, when the binary log replication process had actually stopped prematurely.
NetSuite SuiteAnalyticslink
We have fixed the incremental update of child tables. All child tables of child tables will also be updated recursively. For example, if the TRANSACTIONS
table is updated, then its child table TRANSACTION_LINES
will be updated, along with TRANSACTION_LINES
's own child tables BIN_NUMBER
and BIN_NUMBER_COUNTS
.
ServiceNowlink
The ServiceNow connector can now sync tables which do not have sys_updated_on
or sys_created_on
columns.
Taboolalink
We have improved the Taboola connector's capacity to support very large data files.
Webhookslink
We have added GZIP support for Webhook API requests.