Fivetran Product Update - September 2023

[ciara-rafferty]

Every month we send out a newsletter highlighting our most popular product updates and connector releases. Below you'll find the full product update, which includes additional content that didn't make the email. Drop a comment to let us know what you're most excited about adding or testing!

New Releases

1-minute syncs available for all connectors 

Elevate your data integration experience with our new 1-minute sync option, enabling real-time, low-latency data movement across all standard connectors where the API limit allows. This sync option is available for customers on the Enterprise plan and up.

Developer efficiency improvements

Optimize your devops workflow with the Fivetran API via our Terraform provider, Webhooks API, or Tranformations API. 

• Webhooks API: Now supports more events, including edit_connector, which allows you to follow the connector state through its whole life cycle.
• Terraform provider: Easily customize the schema and reduce the time it takes for a new connector to be supported in Terraform with OpenAI automation.
• Transformations API: Now in beta, orchestrate your transformation models via the Transformations API.

You can learn about each release, the impact and what is to come next in this blog post.

Redshift as a Source is now available in Private Preview

One of Fivetran's most popular destinations is now available as a data source. During the open Private Preview, only tables with Primary Keys are supported.

Write dbt™ data models more efficiently with our Visual Studio Code extension

Our  Wizard for dbt Core™ now supports BigQuery and Snowflake. Use auto-complete, query preview, error highlighting, and more functionalities to more efficiently write your business-critical dbt data models. Download it for free.

Analytics-ready tables for Marketo, Iterable, Klaviyo, and Mixpanel

We added Quickstart data models for four of our most popular SaaS data sources: Marketo, Iterable, Klaviyo, and Mixpanel. With a few clicks you can transform your raw data into analytics-ready tables. Head to the Transformations tab in your dashboard and add a Quickstart data model to optimize your workflows and accelerate your time to insight.

Faster time to insights with new data models

Our new data models for SAP, Twilio, and Qualtrics make it easier to turn your data into the analytics-ready tables you need to drive your business forward.

New Connectors

Connectors in GA

• Databases: Cosmos DB
• Finance & Operations: Oracle Fusion Cloud Applications, Microsoft Dynamics 365 Finance
• Sales:Talkdesk

Connectors in beta

Add any of these connectors in beta today by following the link to your Fivetran dashboard.

• Databases: Firebase, Elasticsearch, Db2 for i
• Destinations: AWS S3 + Iceberg, Confluent Kafka, Delta Lake on Azure
• Destinations as Sources: Google BigQuery, Snowflake
• Finance & Operations: FinancialForce
• Marketing: Google Analytics 4 Export, Google Search Ads 360
• Sales: Amazon Selling Partner
• Other: AWS MSK (Kafka)

Connectors in private preview

Email beta@fivetran.com or comment below for access to any of the following connectors. Remember that all Private Preview connectors are free to use while they’re in this release phase.

• Databases: SAP ERP on HANA
• Destinations as Sources: Redshift (tables with PKs only)
• Finance & Operations: Workday Financial Management, Microsoft Dynamics 365 Business Central, AWS Cost explorer, Azure Devops
• Marketing: Yahoo DSP, Sprout Social, Spotify Ads, Customer.io
• Sales & Commerce: Adobe Commerce, Commercetools

Lite Connectors

Lite connectors have an accelerated development cycle built for specific use cases. Learn more about lite connectors  in the docs and see all available lite connectors in the connector directory. Some of our latest include: Appfigures, FullStory, FreshBooks and Churnkey.