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
New connectorslink
Google Analytics 360link
Google Analytics 360 provides the tools and support that enterprise teams need to get actionable insights from their data.
Link to Google Analytics 360 Documentation
Leverlink
Lever is a modern recruiting software that streamlines the hiring process and simplifies the applicant tracking system.
ServiceNowlink
ServiceNow is a cloud platform that provides service management software as a service.
Link to ServiceNow Documentation
Schema changeslink
Facebook Ad Accountlink
We have removed the FAILED_DELIVERY_CHECKS
table from the Facebook Ad Account connector due to data retrieval problems and lack of analytical utility.
Iterablelink
We have replaced the locale_name
field with locale
in the following tables:
EMAIL_TEMPLATE_HISTORY
EVENT_EXTENSION
PUSH_TEMPLATE_HISTORY
SMS_TEMPLATE_HISTORY
Microsoft Advertisinglink
Because the brand
field can have a null
value in the Bing Ads API response, it is no longer the primary key in the following tables:
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 field, 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.
Zendesklink
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.
Greenhouselink
- The
JOB
table now includes the fieldname
. - The
SCHEDULED_INTERVIEW
table now includes the fieldsstart
andend
.
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 Bing Ads 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.
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.
Webhooks/Eventslink
We have added GZIP support for Webhook API requests.