New connectorslink
Azure Service Buslink
Azure Service Bus is a cloud messaging service.
Read our Azure Service Bus connector documentation.
Schema changeslink
Adjustlink
We have added the following new tables:
SK_EVENTSK_INSTALLSK_QUALIFIER
We only sync the records whose sk timestamp is on or after June 28, 2022, to these tables.
Criteolink
We have added a new report, PLACEMENT_REPORT.
Zendesk Supportlink
We have added a new column, html_body, to the TICKET_COMMENT table.
Improvementslink
App reporting modellink
Fivetran has created a dbt Core*-compatible app reporting model that aggregates data from our most popular app platform connectors into a unified table. This pre-built model allows you to compare your app activity by device, country, OS version, traffic source, and subscription levels.
The ad reporting model supports the Apple App Store and Google Play connectors.
Learn more in our app reporting model documentation.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
Apple App Storelink
We have released pre-built, dbt Core*-compatible data models for Apple App Store. Find the models in Fivetran’s dbt hub. Learn more about our dbt Core integration in our Transformations for dbt Core documentation.
*dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
Coupalink
We now support the OAuth 2.0 authentication. If you are using the API Key authentication, you need to migrate to OAuth 2.0 before December 1, 2022. You can migrate to OAuth 2.0 by editing the connection parameters and providing the Client ID and Client Secret instead of the API Key. See our Coupa Setup Guide for details about how to obtain them.
GitHublink
We have added a new table, BRANCH_COMMIT_RELATION, that stores branch and commits relations.
We are gradually rolling out this feature to all existing connectors. Once this feature is available, you will see the BRANCH_COMMIT_RELATION table on the Schema tab. To fetch data for all existing branches and commits, re-sync your connector.
Google Playlink
We have released pre-built, dbt Core*-compatible data models for Google Play. Find the models in Fivetran’s dbt hub. Learn more about our dbt Core integration in our Transformations for dbt Core documentation.
*dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
Google Search Consolelink
We now sync the query column instead of the keyword column in the following reports:
- KEYWORD_SITE_REPORT_BY_PAGE
- KEYWORD_SITE_REPORT_BY_SITE
- KEYWORD_PAGE_REPORT
This change only applies to connectors created after August 11, 2022.
History mode in betalink
Fivetran history mode is now in beta for the following connectors:
Learn more in our history mode documentation.
Kustomerlink
The following tables now support History Mode for connectors created on or after August 01, 2022:
CONVERSATION_HISTORYCONVERSATION_CHANNEL_HISTORYCONVERSATION_TAG_HISTORYCONVERSATION_SUGGESTED_TAG_HISTORYCONVERSATION_ASSIGNED_TEAM_HISTORYCONVERSATION_ASSIGNED_USER_HISTORY
MongoDBlink
Our MongoDB Replica Set connector now supports the following:
- Connection tags with SRV hosts. For example,
mongodb+srv://server.example.com/?readPreference=secondary&readPreferenceTags=nodeType:ANALYTICS. - Connection strings. For example,
mongodb://mongodb0.example.com:27017,mongodb1.example.com:27017,mongodb2.example.com:27017/?replicaSet=myRepl&readPreference=secondary.
For more information, see our setup instructions. We are gradually rolling out this feature to all existing connectors. If you’d like to enable this feature on your connector, contact our support team.
We have added a new database setup test to our MongoDB Replica Set connector. Now, we verify if we can access your MongoDB change streams or oplog.
NetSuite SuiteAnalyticslink
We have added support for CLOB data type. We now convert the data to STRING data type in your destination tables. We are gradually rolling out this feature to all existing connectors.
Our dbt-Core* compatible data models for NetSuite SuiteAnalytics now support the NetSuite2.com data source. Find the models in Fivetran’s dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
Salesforce Marketing Cloudlink
We have decreased the priority fetch period from 14 to 5 days for all the priority-first sync tables to improve sync speeds and reduce the duration of the first forward sync. For more information, see our priority-first sync documentation.
REST API Improvementslink
Additional icon URLslink
We have added new icons field to the Retrieve source metadata and Retrieve connector configuration metadata endpoint responses. This field contains a list of additional icon URLs in different formats (for example, .svg or .png) for the connector.
Webhooks retry algorithmlink
We have changed the retry algorithm for sending webhooks. We now use an exponential backoff strategy - we wait 6 minutes before the first retry, 21 minutes before the second retry, and so on. Learn more in our Retries documentation.