Product and documentation updates from the team at Stitch.
Stay up-to-date by subscribing to our RSS feed.
-
- QuickBooks integration: New version (v1)
-
A new version (v1) of our QuickBooks integration is now available!
We’ve worked hard to ensure this new integration is the best way to extract data from QuickBooks to your Stitch destination. The new integration, based on the Singer standard, includes many new features such as:
- Removal of
quickbooks_
prefixes on table names - User-facing Extraction Logs
- Table and field selection
- Enhanced scheduling options
- Run and stop Extraction on demand functionality
- Availability via the Stitch Connect API
- Enhanced schema validation
Get started today by creating a new QuickBooks integration or learn more in the updated documentation.
Tags: - Removal of
-
- Availability of European Data Center
-
We’re proud to announce the availability of an AWS European Data Center for Stitch. Enjoy the benefits of Stitch while ensuring your extracted data never leaves the European Union. Signup to get started or see our documentation for more details.
Tags:
-
- Trello integration: New version (v1)
-
A new version (v1) of our Trello integration is now available!
We’ve worked hard to ensure this new integration is the best way to extract data from Trello to your Stitch destination. The new integration, based on the Singer standard, includes many new features such as:
- Removal of
trello_
prefixes on table names - Native OAuth support
- Support for custom fields for the
boards
andcards
tables - User-facing Extraction Logs
- Updated API secret authentication
- The
export
table now uses Append-only loading behavior - Configurable attribution windows for the
export
,funnels
, andrevenue
tables - Table and field selection
- Enhanced scheduling options
- Run and stop Extraction on demand functionality
- Availability via the Stitch Connect API
- Enhanced schema validation
Get started today by creating a new Trello integration or learn more in the updated documentation.
Tags: - Removal of
-
- Square integration: New version (v1)
-
A new version (v1) of our integration is now available!
We’ve worked hard to ensure this new integration is the best way to extract data from Square to your Stitch destination. The new integration, based on the Singer standard, includes many new features such as:
- Removal of
square_
prefixes on table names - Addition of the customers table
- Several renamed tables:
square_inventory
is nowinventories
square_location
is nowlocations
- Several record types are now replicated through top-level tables:
fee
data is now replicated through thetaxes
tabletimecard
data is now replicated through theshifts
table
- Removal of the
square_pages
table due to its deprecation in the Square API - User-facing Extraction Logs
- Table and field selection
- Enhanced scheduling options
- Run and stop Extraction on demand functionality
- Availability via the Stitch Connect API
- Enhanced schema validation
Get started today by creating a new Square integration or learn more in the updated documentation.
Tags: - Removal of
-
- Mixpanel integration: New version (v1)
-
A new version (v1) of our Mixpanel integration is now available!
We’ve worked hard to ensure this new integration is the best way to extract data from Mixpanel to your Stitch destination. The new integration, based on the Singer standard, includes many new features such as:
- Removal of
mixpanel_
prefixes on table names - New tables, including:
- User-facing Extraction Logs
- Updated API secret authentication
- The
export
table now uses Append-only loading behavior - Configurable attribution windows for the
export
,funnels
, andrevenue
tables - Table and field selection
- Enhanced scheduling options
- Run and stop Extraction on demand functionality
- Availability via the Stitch Connect API
- Enhanced schema validation
Get started today by creating a new Mixpanel integration or learn more in the updated documentation.
Tags: - Removal of
-
- AdRoll integration: New version (v1)
-
A new version (v1) of our AdRoll integration is now available!
We’ve worked hard to ensure this new integration is the best way to extract data from AdRoll to your Stitch destination. The new integration, based on the Singer standard, includes many new features such as:
- Removal of
adroll_
prefixes on table names - User-facing Extraction Logs
- Table and field selection
- Enhanced scheduling options
- Run and stop Extraction on demand functionality
- Availability via the Stitch Connect API
- Enhanced schema validation
Get started today by creating a new AdRoll integration or learn more in the updated documentation.
Tags: - Removal of
-
- Intercom integration: New version (v1)
-
A new version (v1) of our Intercom integration is now available!
We’ve worked hard to ensure this new integration is the best way to extract data from Intercom to your Stitch destination. The new integration, based on the Singer standard, includes many new features such as:
- Use of Intercom API version 2.0
- Updated OAuth flow for easier authentication
- New tables, including:
- contacts (formerly (
users
) - contact_attributes
- company_attributes
- teams
- contacts (formerly (
- Additional field support for the conversations table, including:
conversation_ratings
sla_applied
statistics
- Enhanced extraction approaches for the
contacts
andcompanies
tables - User-facing Extraction Logs
- Table and field selection
- Enhanced scheduling options
- Run and stop Extraction on demand functionality
- Availability via the Stitch Connect API
- Enhanced schema validation
Get started today by creating a new Intercom integration or learn more in the updated documentation.
Tags:
-
- Integrations leaving beta
-
The following integrations have left beta and are now generally available. Get started with these integrations today!
-
Workday RaaS (Enterprise only)
-
- New integrations in open beta
-
Stitch is pleased to announce the release of three new integrations into open beta and available to all customers:
-
AdRoll: The new AdRoll integration utilizes the Singer framework which affords several quality of life enhancements such as column and table selection and full Stitch Connect API support.
-
Intercom: The new Intercom integration also takes advantage of the Singer framework. Additionally, it utilizes version 2 of the Intercom API to provide additional tables to be extracted and enhanced scaling functionality.
-
Zoom: The new Zoom Communications integration now allows the extraction of meeting, webinar and report data.
All three of these integrations are available to all customers in open beta and can be added to your account through the integrations page.
Tags: -
-
- New integrations in open beta
-
Stitch is pleased to announce the release of several new integrations into open beta:
In addition to providing more tables, these integrations now include table and column selection, Extraction Logs, Loading Reports and full Connect API compatibility!
Tags:
-
- Pardot integration: New version (v1)
-
A new version (v1) of our Pardot integration is now available!
We’ve worked hard to ensure this new integration is the best way to extract data from Pardot to your Stitch destination. The new integration, based on the Singer standard, includes many new features such as:
- Removal of
pardot
prefixes from table names - New tables, including:
- User-facing Extraction Logs
- Table and field selection
- Enhanced scheduling options
- Run and stop Extraction on demand functionality
- Availability via the Stitch Connect API
- Enhanced schema validation
Get started today by creating a new Pardot integration or learn more in the updated documentation.
Tags: - Removal of
-
- Databricks Delta Lake destination in open beta
-
A new destination is now in open beta, available to all customers: Databricks Delta.
Developed by Databricks, Delta Lake is an open-source storage layer that leverages the “lakehouse” paradigm. This allows you to implement similar data structures and data management features to those of a data warehouse, directly on the kind of low cost storage used for data lakes.
Check out the docs for more information.
Tags:
-
- Google BigQuery destination in open beta
-
We’ve built a new Google BigQuery destination from the ground up to address feedback from our customers and take advantage of new features on the platform, including the ability to upsert data.
Some notable improvements include:
-
The ability to choose between append only and upsert loading behavior
-
Authentication using your own Google Service Account
It’s available now - check it out!
Tags: -
-
- MongoDB integration: New version (v1)
-
A new version (v1) of our MongoDB integration is now available!
We’ve worked hard to ensure this new integration is the best way to extract data from MongoDB to your Stitch destination. The new integration, based on the Singer standard, includes many new features such as:
- User-facing Extraction Logs
- Field selection/exclusion using Projection Queries
- Support for logical replication via OpLog and Full Table Replication
- Enhanced scheduling options
- Run and stop Extraction on demand functionality
- Availability via the Stitch Connect API
Get started today by creating a new MongoDB integration or learn more in the updated documentation.
Tags:
-
- Facebook Ads (v1) API upgrade to v4.0
-
The Facebook Ads integration now replicates data using version 4.0 of the Facebook Marketing API. For more details, view the Facebook API changelog.
Tags:
-
- New integration: Deputy
-
Deputy is a cloud-based workforce management and scheduling platform designed to help companies organize, track, and manage their teams. Our new Deputy integration enables you to extract all of your Deputy resources from a Deputy account.
Get started by creating a new Deputy integration or learning more in our documentation.
Tags:
-
- JIRA (v1) improvement: Added support for inactive users
-
The JIRA integration can now replicate inactive users into the users table.
To determine the status of a user, use the
active
field. For example: The following query will only return active users:Tags:SELECT * FROM jira.users WHERE active = TRUE
-
- Opt out of error notification emails
-
You can now opt out of system notification emails, freeing up inbox space and keeping your team on track. We’ll still let you know in-app if we run into any issues replicating data and via email for any billing information.
Check out the docs for more info.
Tags:
-
- Recurly integration: New version (v1)
-
A new version (v1) of our Recurly integration is now available!
We’ve worked hard to ensure this new integration is the best way to extract data from Recurly to your Stitch destination. The new integration, based on the Singer standard, includes many new features such as:
- Removal of
recurly_
prefixes from table names - New tables, including:
- User-facing Extraction Logs
- Table and field selection
- Enhanced scheduling options
- Run and stop Extraction on demand functionality
- Availability via the Stitch Connect API
- Enhanced schema validation
Get started today by creating a new Recurly integration or learn more in the updated documentation.
Tags: - Removal of
-
- API access and management features for Enterprise
-
Take programmatic control over your Stitch account using the [Connect API](https://www.stitchdata.com/docs/developers/stitch-connect/api Now, you can manage your API keys right in your Stitch account.
This feature is available for our Enterprise customers or you can try it out during a 14-day free trial. Check out the docs.
Tags:
-
- New integration: Help Scout
-
Help Scout offers a help desk invisible to customers, that helps companies deliver outstanding customer support. Our new Stitch Help Scout integration enables you to extract conversations, threads, customers, mailboxes, users, and more from a Help Scout account.
Get started by creating a new Help Scout integration or learning more in our documentation.
Tags:
-
- New integration: MailChimp
-
MailChimp is a marketing automation platform and an email marketing service. Our new MailChimp integration enables you to extract automations, campaigns, lists, members, email activities, and more from a MailChimp account.
Get started by creating a new MailChimp integration or learning more in our documentation.
Tags:
-
- Post-load web hooks released for Enterprise customers
-
Want to be notified when data is loaded into your Stitch destination? With our new notification feature, you can!
Post-load webhooks send a webhook to a configurable address each time data is loaded into your destination. This new feature enables you to prompt other systems and processes to act on the data loaded by Stitch.
It’s available for our Enterprise customers, and you can try it out during a 14-day free trial. Learn more in our docs.
Tags:
-
- Microsoft SQL Server integration: New version (v1)
-
A new version (v1) of our Microsoft SQL Server integration is now available!
We’ve worked hard to ensure this new integration is the best way to extract data from Microsoft SQL Server databases to your Stitch destination. The new integration, based on the Singer standard, includes many new features such as:
- Logical Replication support via SQL Server Change Tracking
- User-facing Extraction Logs
- Enhanced scheduling options
- Run and stop Extraction on demand functionality
- Availability via the Stitch Connect API
Get started today by creating a new Microsoft SQL Server integration or learn more in the updated documentation.
Tags:
-
- New integration: LivePerson
-
LivePerson provides tools for online messaging, marketing, and analytics. The new Stitch LivePerson integration enables you to extract agent activity, groups, statuses, enagements, messages, users, and more from a LivePerson account.
Get started by creating a new LivePerson integration or learning more in our documentation.
Tags:
-
- New integration: Asana
-
Asana is a web and mobile application designed to help teams organize, track, and manage their work. The Stitch Asana integration will ETL Asana data to your destination, giving you access to raw project data, without the headache of writing and maintaining ETL scripts. Our new Stitch Asana integration enables you to extract projects, tags, tasks, users, workspaces from an Asana account.
Get started by creating a new Asana integration or learning more in our documentation.
Tags:
-
- New integration: Intacct
-
Intacct is an accounting and financial management software for the digital era. Our new Intacct integration enables you to extract core objects via the Intacct Data Delivery Service.
Get started by creating a new Intacct integration or learning more in our documentation.
Tags:
-
- Notification extensions for Enterprise
-
Enterprise clients can now save time by integrating Stitch monitoring and notification with the system they use to monitor the rest of their infrastructure. For example:
- Integrate with external monitoring systems like PagerDuty or Datadog
- Post updates to Slack
- Trigger other apps using Zapier
Learn more about notification extensibility here.
Tags:
-
- Advanced (cron) scheduling for Enterprise
-
Enterprise users can now specify granular start times for extraction jobs via cron scheduling. You can use this new feature to manage destination usage and Stitch row volumes.
This feature is available for our Enterprise customers and you can try it out during a 14-day free trial. Learn more about cron scheduling by reading the documentation.
Tags:
-
- Facebook Ads (v1) API upgrade to v3.3
-
The Facebook Ads integration now replicates data using version 3.3 of the Facebook Marketing API.
Tags:
-
- NetSuite integration: New version (v1)
-
A new version (v1) of our NetSuite integration is now available!
We’ve worked hard to ensure this new integration is the best way to extract data from NetSuite to your Stitch destination. The new integration, based on the Singer standard, includes many new features such as:
- Removal of
netsuite_
prefixes from table names - token based authentication
- Optimizations to API concurrency during discovery of tables/fields
- Utilization of an updated WSDL for a more complete set of tables/fields
- Field selection
Get started today by creating a new NetSuite integration or learn more in the updated documentation.
Tags: - Removal of
-
- Start and Stop Extractions on demand
-
We’ve renamed the Extraction Logs page to simply Extractions.
We’ve also added new buttons to Run Extraction Now and Stop Extraction for those times when you need a little more control over when Stitch extracts data from your data sources.
Tags:
-
- JIRA integration: New version (v1)
-
A new version (v1) of our JIRA integration is now available!
We’ve worked hard to ensure this new integration is the best way to extract data from JIRA to your Stitch destination. The new integration, based on the Singer standard, includes many new features such as:
- Removal of
jira_
prefixes from table names - New tables, including:
- issues, changelog, and transitions are now top-level tables
- roles (formerly
jira_project_roles
) - worklogs
- JIRA Cloud accounts now use an API token instead of user/password authentication
- User-facing Extraction Logs
- Table and field selection
- Run and stop Extraction on demand functionality
- Enhanced schema validation
Get started today by creating a new JIRA integration or learn more in the updated documentation.
Tags: - Removal of
-
- Amazon Redshift (v2) destination transaction optimization
-
We have split DDL statements like
Tags:ALTER table
commands into their own transaction in Amazon Redshift destinations to minimize the length of time that tables are locked.
-
- Microsoft Azure SQL Data Warehouse destination leaving open beta
-
Our Microsoft Azure Synapse Analytics destination has left open beta and is now generally available! Check out the press release or the docs for more info.
Tags:
-
- New integration: Responsys
-
Responsys enables marketing teams to manage and orchestrate all interactions with their customers across email, mobile, social, display, and the web. Stitch’s new Responsys integration extracts event data feeds, lists, audiences, and more from your configured Responsys Connect exports.
Get started by creating a new Responsys integration or learning more in our documentation.
Tags:
-
- New integration: Typeform
-
Typeform can help you build conversational forms, surveys, quizzes, landing pages, and more. The new Stitch Typeform integration extracts questions, landings and answers for the forms you care about the most. Choose the granularity you need by selecting between an hourly or daily breakdown of your data.
Get started by creating a new Typeform integration or learning more in our documentation.
Tags:
-
- New integration: Front
-
Front lets you manage all of your communication channels — email, social media, chat, SMS — in one place, and helps your team collaborate around every message. With the new Stitch integration, you can extract team member statistics related to conversations, messages, reaction times and more. Choose the granularity you need by selecting between an hourly or daily breakdown of your data.
Get started by creating a new Front integration or learning more in our documentation.
Tags:
-
- Stripe integration: New version (v1)
-
A new version (v) of our Stripe integration is now available!
We’ve worked hard to ensure this new integration is the best way to extract data from Stripe to your Stitch destination. The new integration, based on the Singer standard, includes many new features such as:
- Removal of
stripe_
prefixes from table names - New and improved tables, including:
- invoice_line_items
- subscription_items
- subscription_line_items
- The
transfer_transactions
table has been replaced by payouts
- User-facing Extraction Logs
- Table and field selection
- Availability via the Stitch Connect API
Get started today by creating a new Stripe integration or learn more in the updated documentation.
Tags: - Removal of
-
- Shopify integration: New version (v1)
-
A new version (v1) of our Shopify integration is now available!
We’ve worked hard to ensure this new integration is the best way to extract data from Shopify to your Stitch destination. The new integration, based on the Singer standard, includes many new features such as:
- A few table changes and improvements:
- The collects and order_refunds tables now use Key-based Incremental Replication
- We’ve renamed
checkouts
to abandoned_checkouts to clarify the table’s available data - Product and customer metadata is now available! Track the products, customers, and metafields tables to replicate this data
- Optimized methods for retrieving Shopify data
- Optimized use of Shopify API quota for extraction
- User-facing Extraction Logs
- Table and field selection
- Availability via the Stitch Connect API
Get started today by creating a new Shopify integration or learn more in the updated documentation.
Tags: - A few table changes and improvements:
-
- Google BigQuery (v1) destinations: Additional region support
-
Google BigQuery has begun adding additional region support (beyond the US and EU) for their users, and we’ve just made these new regions available in Stitch for Google BigQuery (1) destinations. Stitch customers can now use Stitch with Google BigQuery instances in Tokyo, London, Singapore and Sydney.
Tags:
-
- Google BigQuery (v1) destinations: Partitioned table support
-
Stitch now supports loading to Google BigQuery partitioned tables and ingestion-time partitioned tables with and without clustering. We’ve added instructions to our docs for converting existing tables into partitioned and clustered tables.
Tags:
-
- Microsoft Azure SQL Data Warehouse (v1) destination now in open beta!
-
If you’ve been waiting to get Stitch hooked up to Microsoft Azure Synapse Analytics, good news! As of today, this destination is available for any customer to use. Learn more in the new docs.
Tags:
-
- Google BigQuery (v1) destinations: NUMERIC data type support
-
We’ve added support for the NUMERIC data type in Google BigQuery destinations. Numeric data will be loaded into
Tags:NUMERIC
columns going forward, rather than columns with the floating point data type.
-
- Facebook Ads (v1) integrations: API upgrade to v3.2
-
We have updated the Facebook Ads integration to use the latest version of the Facebook Marketing API - version 3.2.
As part of this update, Facebook has deprecated many values for
Tags:cost_per_action_type
to simplify reporting and support reporting based on their new eight standard events. Additionally, thetotal_action_value
field has been deprecated and removed from allads_insights
tables.
-
- Pipedrive (v1) integration: Removed goals table
-
As per an update to the Pipedrive API, the
Tags:goals
table has been removed from the Stitch integration. See more about the available Pipedrive data in our documentation.
-
- Bing Ads integration: New version (v2)
-
A new version (v2) of our Bing Ads integration is now available! This version takes advantage of the latest Bing Ads API, version 12.
Here’s a high-level look at the updates to our integration:
-
Support for multi-user credentials: The new integration allow for extracting data where you use one Microsoft account and manage accounts across different customers.
-
Column restrictions: Bing now prevents the extraction of reports with invalid field combinations. Stitch will automatically show these exclusions within the field selection interface when setting up your reports. Refer to Bing’s documentation for a full list of column restrictions.
-
Schema updates: The following changes have been made to table schemas:
- All report tables:
RENAMED ATTRIBUTES Bing Ads v1 Bing Ads v2 GregorianDate TimePeriod Search query SearchQuery CountryOrRegion Country Device type DeviceType Status CampaignStatus AudienceTargetSetting TargetingSetting NodeId AdGroupCriterionId FinalAppURL FinalAppUrl FinalURL FinalUrl FinalMobileURL FinalMobileUrl - AdGroundPerformanceReport, CampaignPerformanceReport, and KeywordPerformanceReport tables:
RENAMED ATTRIBUTES Bing Ads v1 Bing Ads v2 HistoricQualityScore HistoricalQualityScore HistoricExpectedCtr HistoricalExpectedCtr HistoricAdRelevance HistoricalAdRelevance HistoricLandingPageExperience HistoricalLandingPageExperience - KeyWordPerformanceReport:
RENAMED ATTRIBUTES Bing Ads v1 Bing Ads v2 SidebarBid FirstPageBid - Accounts:
RENAMED ATTRIBUTES Bing Ads v1 Bing Ads v2 CurrencyType CurrencyCode REMOVED ATTRIBUTES AccountType CountryCode - AdGroups:
RENAMED ATTRIBUTES Bing Ads v1 Bing Ads v2 SearchBid CpcBid NativeBidAdjustment AudienceAdsBigAdjustment REMOVED ATTRIBUTES RemarketingTargetingSetting PricingModel AdDistribution ContentBid - Campaigns:
RENAMED ATTRIBUTES Bing Ads v1 Bing Ads v2 NativeBidAdjustment AudienceAdsBidAdjustment
- All report tables:
-
-
- New integration: Campaign Monitor
-
Stitch’s new Campaign Monitor integration will extract your lists, campaigns, and campaign activity to power all of your email marketing analyses. Create a Campaign Monitor integration today and load your historical data for free.
Get started by creating a new Campaign Monitor integration or learning more in our documentation.
Tags:
-
- New integration: Harvest Forecast
-
Harvest Forecast is a fast and simple way to schedule your team across projects. With Stitch’s new integration, you can extract core object such as assignments, clients, milestones, projects and people to your Stitch destination. Combine your project data with your other sources by adding a new integration today. Learn more in our documentation.
Tags:
-
- New integration: Close.io
-
A new Close.io integration is now available! This integration replicates your activities, leads, tasks, users and the raw event log from your Close.io account. Create a Close.io integration today and empower your sales team to make better data driven decisions. Learn more in our documentation.
Tags:
-
- Harvest integration: New version (v2)
-
A new version (v2) of our Harvest integration is now available!
Changes in this version include:
- Upgrading to V2 of the Harvest API
- Many new tables
- Schema modifications to align with the Harvest API
- The
people
table was renamed tousers
, as per new Harvest API endpoints
Full details can be found on the pull request against the open sourced integration here. Stitch docs for the version 2 of the Harvest integration can be found here.
Tags:
-
- New integration: Amplitude
-
A new Amplitude integration is now available! This integration extracts event and user data from your Amplitude projects. Amplitude is an analytics service for modern product teams to understand user behavior, ship the right features fast, and drive business outcomes. Our integration enables you to extract raw data from the Amplitude Query product and combine it with all the data in your Stitch destination.
Get started by creating a new Amplitude integration or learning more in our documentation.
Tags:
-
- New integration: Xero
-
A new Xero integration is now available! With the new integration, Stitch will replicate your core Xero objects including bank transactions, contacts, invoices, journal entries, payments, and more to your Stitch destination.
Get started by creating a new Xero integration or learning more in our documentation.
Tags:
-
- New integration: Google (DoubleClick) Campaign Manager
-
Stitch has a new integration with Google Campaign Manager (formerly DoubleClick Campaign Manager). After you select Campaign Manager reports, Stitch will run them and replicate the results to your Stitch destination.
Get started by creating a new Campaign Manager integration or learning more in our documentation.
Tags:
-
- New integration: Yotpo
-
A new Yotpo integration is now available! Yotpo generates social reviews, ratings, and other user-generated content for eCommerce websites.
Get started by creating a new Yotpo integration or learning more in our documentation.
Tags:
-
- Google AdWords (v1) integrations: API upgrade to v201806
-
The Google AdWords integration has been updated to use v201806 of the AdWords API, from v201802.
Notable changes include:
-
Ad Groups: The
AdGroupType
enum valueSHOPPING_UNIVERSAL_ADS
was renamed toSHOPPING_GOAL_OPTIMIZED_ADS
. -
Ad Group Performance Report: The
AdGroupType
field will now return a value of“Shopping - Goal-optimized”
where it previously returned“Shopping - Universal”
, and the corresponding enum value changed fromSHOPPING_UNIVERSAL_ADS
toSHOPPING_GOAL_OPTIMIZED_ADS
.
-
-
- New integration: Amazon S3 CSV
-
A new Amazon S3 CSV integration is now available!
This integration can connect to your S3 bucket and replicate CSV files to your Stitch destination. Some highlights of this new integration include:
- Replication of data from CSV files stored in your S3 buckets
- Support for incremental updates based on new or modified CSV files
- Column selection for choosing which columns you want to extract from your CSV files
- Automatic inference of data types and the ability to explicitly specify datetime fields
Get started by creating a new Amazon S3 CSV integration or learning more in our documentation.
Tags:
-
- Zendesk integration: New version (v1)
-
A new version (v1) of our Zendesk Support integration is now available!
We’ve worked hard to ensure this new integration is the best way to extract data from Zendesk Support to your Stitch destination. The new integration, based on the Singer standard, includes many new features such as:
- User-facing Extraction Logs
- Table and field selection
- Run and stop Extraction on demand functionality
- Availability via the Stitch Connect API
- Enhanced schema validation
Get started today by creating a new Zendesk Support integration or learn more in the updated documentation.
Tags:
-
- PostgreSQL integration: New version (v1)
-
A new version (v1) of our PostgreSQL integration is now available!
We’ve worked hard to ensure this new integration is the best way to extract data from PostgreSQL to your Stitch destination. The new integration, based on the Singer standard, includes many new features such as:
- Logical replication support, which allows you to replicate data from database binary logs, including hard deletes, without the use of a Replication Key
- User-facing Extraction Logs
- Table and field selection
- Enhanced scheduling options
- Run and stop Extraction on demand functionality
- Availability via the Stitch Connect API
- Enhanced schema validation
Get started today by creating a new PostgreSQL integration or learn more in the updated documentation.
Tags:
-
- New community integrations available
-
Thanks to the contributions of the Singer community, Stitch has five new integrations available for all customers to use:
-
Bronto: An email marketing platform for ecommerce
-
FullStory: A tool that offers high-fidelity session playback
-
Listrak: A marketing platform for engaging shoppers across all channels
-
Quick Base: A platform for developers to build, customize and connect scalable, secure cloud applications
-
SendGrid Core: A platform for delivering transactional and marketing emails
All of these integrations are built on the Singer open source project and take advantage of Stitch’s secure and scalable infrastructure.
Get started by adding a new integration today or learning more in our documentation.
Tags: -
-
- Marketo integration: New version (v2)
-
A new version (v2) of our Marketo integration is now available! Major changes include:
- Activity selection – Each Marketo activity type is now its own table, allowing you to replicate just the ones you care about the most.
- Replication of campaigns and programs – These objects are now available for replication to your destination.
- Column selection – Just as with tables, we’ll only replicate the columns that you want.
- Improved efficiency – The integration now uses Marketo Bulk API, which allows us to more efficiently replicate large amounts of data. Review our documentation for more details.
Learn more about the integration and these features in our Marketo integration documentation.
Tags:
-
- Amazon S3 (v1) destination leaving open beta
-
Our Amazon S3 destination has left open beta and is now generally available! Check it out today to get your source data delivered to your S3 bucket in either JSON or CSV. Check out the docs for more info.
Tags:
-
- New integration: GitHub
-
A new GitHub integration is now available!
This integration lets you extract data from any GitHub repository. You can choose from the following tables to replicate to your destination:
assignees
collaborators
commits
issues
pull_requests
reviews
stargazers
Create a new integration today with seven days of free historical data. Learn more in our documentation.
Tags:
-
- Zuora integration: New version (v1)
-
A new version (v1) of our Zuora integration is now available!
We’ve worked hard to ensure this new integration is the best way to extract data from Zuora to your Stitch destination. The new integration, based on the Singer standard, includes many new features such as:
- Removal of
zuora_
prefixes from table names - Expanded table and field availability
- Choice of Zuora API, allowing you to choose the API that best fits your needs
- Replication of deleted records when using the AQuA API
- Table and field selection
- Enhanced schema validation
Get started today by creating a new Zuora integration or learn more in the updated documentation.
Tags: - Removal of
-
- HubSpot integration: New version (v2)
-
A new version (v2) of our HubSpot integration is now available! Major changes include:
- Column-level selection
- More comprehensive data typing on custom properties
- Inclusion of all form submissions for
contacts
– Older versions only replicated the newest form submissions. Now you can extract a complete picture of your contact form submissions. - Improved updates of the
list_memberships
table - Several schema changes:
hubspot_contacts_by_company
has been renamed tocontacts_by_company
- The
isDeleted
fields have been removed from thedeals
andcompanies
tables. The HubSpot API does not provide accurate values for this data, so we’ve removed it to prevent confusion and potential discrepancies. - The
keywords
table has been removed. HubSpot has deprecated the keywords feature of their product and API. Note: HubSpot has deprecated their Keywords tool as of June 1. - New counters added to
campaigns
, including:deferred
,unsubscribed
,statuschange
,bounce
,mta_dropped
,suppressed
Learn more about the integration and these features in our HubSpot integration documentation.
Tags:
-
- MySQL (v1) integrations: Binlog replication support
-
MySQL integrations can now use binlog replication to perform incremental replication in Stitch!
If you have binary logging enabled for your MySQL database, Stitch can now use it to help replicate your data. Log-based Incremental Replication allows for incremental replication of a table without a Replication Key and will capture and persist hard deletes.
This feature is now available as a Replication Method on the Table Settings of MySQL integrations. Check out the docs for more info.
Tags:
-
- Free historical data loads for all new integrations
-
All new integrations will replicate seven days of unlimited data without impacting your monthly quota. Get started by creating a new integration or learn more on our blog.
Tags:
-
- Time-based replication scheduling is now available!
-
Stitch customers now have some control over when extractions begin. This new feature allows users to “anchor” extraction start times to a specific time, ensuring Stitch is predictably replicating data when it’s most needed.
For example: Setting a six (6) hour replication with an anchor time of 12:00 PM would create this schedule:
- 12:00PM
- 06:00PM
- 12:00AM
- 06:00AM
Check out the docs for full details.
Tags:
-
- Amazon S3 (v1) destination now in open beta
-
Amazon S3 is now available in open beta as a Stitch destination. Highlights include support for both JSON and CSV formats and the ability to customize the S3 Object Keys to control how your data is stored.
Check out the docs for more info.
Tags:
-
- New integration: Bing Ads
-
A new Bing Ads integration is now available!
Stitch’s Bing Ads integration lets you replicate data from Microsoft’s search advertising platform to the Stitch destination of your choice.
A few highlights from the integration include:
- Replication from eight of the most popular Bing Ads reports
- Configurable fields in each of your selected reports
- Connection to multiple ads accounts in each Stitch integration
- [Append-Only loading behavior](https://www.stitchdata.com/docs/replication/loading/understanding-loading-behavior, enabling you to see report changes over time
- A new
_sdc_report_date
field, allowing you to see when data was retrieved from Bing Ads
Get started by creating a new Bing Ads integration or learning more in our documentation.
Tags:
-
- Facebook Ads (v1) integrations: API upgrade to v2.11
-
We’ve updated our Facebook Ads integration to use the newest version of the Facebook Marketing API - version 2.11.
In addition, we’ve made the following improvements:
-
Configurable attribution window when creating or editing a Facebook Ads integration. Choose between
1
,7
or28
days so that Stitch replicates historical data in alignment with the attribution window of your Facebook Ads account. -
A new table named
ads_insights_region
. View your data by the region (such as state or province) where people live or were located when they saw your ads, depending on how you set your location targeting. -
Removed the
video_15_sec_watched_actions
attribute from relevant tables. Facebook deprecated this attribute in the 2.11 version of their API.
-
-
- New destination: data.world
-
A new data.world destination is now available!
data.world helps you host and share your data, collaborate with your team, and capture context and conclusions as you work. We’ve partnered with them to allow you to replicate all your sources into your data.world account.
Check out the docs for more info.
Tags:
-
- Introducing Stitch Connect
-
We’ve just released Stitch Connect, a toolkit that enables developers to integrate a data pipeline with their own platforms behind the scenes as a seamless part of their infrastructure.
Stitch Connect comprises a JavaScript user interface and an API that lets developers programmatically create and access Stitch client accounts and configure source and destination connections.
Interested in seeing how it could work with your application? Check out the docs or get in touch.
Tags:
-
- Google AdWords (v1) integrations: API upgrade to v2.11
-
We’ve updated our Google AdWords integration to use the newest Adwords API - version v201802.
Additionally, we’ve made the following chanegs:
-
In the
ads
table, thepolicyTopicEvidences
object in thepolicySummary.policyTopicEntries
field contains anevidenceText
field. This field (evidenceText
) has been renamed toevidenceTextList
and is now a list. -
In the
ad_performance_report
table, theImageAdUrl
field now returns the entire URL string -
In various reports:
- The
BidType
field has been removed - The
EnhancedCpvEnabled
field has been removed from all reports. This field was used for experiments that are no longer active.
- The
See the AdWords API release notes for additional details.
Tags: -
-
- Loading Reports are now available!
-
Loading Reports are now available!
A few months ago, we launched access to Extraction Logs for select integrations. Today, we’re releasing additional transparency for replication, this time on the loading end of things.
All Stitch users can now see:
- A breakdown of row counts by tables (and subtables) for each integration
- A timeline of loads for each table
- Select integrations (MySQL, Facebook, Salesforce and HubSpot to name a few) have latest data point and extraction time info per table
Check out the docs for more info.
Tags:
-
- Facebook Ads (v15-10-2015) integration: API upgrade to v2.9
-
We’ve updated the integration to use a new version of the Facebook API. This update also provides access to a new table (
Tags:facebook_ads_insights_platform_and_device
), which contains fields allowing you to compare insights between platforms such as Facebok, Instagram, and Messenger, and positions such as feeds, instant articles, and stories.
-
- Introducing Stitch Community integrations
-
Introducing: Stitch Community integrations!
Just like other Singer taps, these integrations are able to be run in Stitch. Thanks to the success of the inger open source project and the contributions from the Singer community, we’re able to run these integrations on the Stitch infrastructure while being supported by the community rather than the Stitch team.
Like Stitch Certified integrations (built and maintained by the Stitch team), Stitch Community integrations offer a number of benefits:
- Running at scale on a reliable infrastructure
- Secure credential management
- Setup and configuration via the Stitch interface
- Configurable scheduling
- Automated notifications when something goes wrong
- Log exploration interface
- Access to all of the Stitch-supported destinations
The key difference is that Stitch provides commercial support for Certified integrations, but not for Community integrations. Commercial support is a guarantee that the Stitch team will fix bugs and adapt to new versions of third-party APIs.
For a full list of Stitch integrations - including both Certified and Community - refer to the docs.
Tags:
-
- Google AdWords integration: New version (v1)
-
A new version (v1) of our Google AdWords integration is now available!
A few highlights include:
- Utilizing the AdWords API to replicate the most popular Google AdWords reports to Stitch
- Configurable fields in each of your selected Google AdWords reports
- Connect multiple individual or MCC AdWords accounts in each Stitch integration
- Using a 30-day conversion/lookback window to update data over the past 30 days
- Loading report data using Append-Only loading with an
_sdc_report_date
field so that users know when data was retrieved from the AdWords API
Learn more about the new version in our documentation.
Tags:
-
- Salesforce integration: New version (v1)
-
A new version (v1) of our Salesforce integration is now available! Major changes include:
- Choose between Salesforce Bulk or REST API
- Configure how much of your Salesforce API quota Stitch can use
- Connect to Salesforce Sandbox accounts
- Choose whether Stitch automatically replicates new fields
- Reset the Replication Key for individual Salesforce tables in Stitch
- Toggle between Incremental or ull Table Replication for tables
- Access the latest objects and fields from the newest version of the Salesforce API
- Removed
sf_
prefix for tables for all newly created integrations
Learn more about the integration and these features in our Salesforce integration documentation.
Tags:
-
- Extraction logs now available!
-
Detailed Extraction Logs are now available for select integrations in Stitch. This new feature presents detailed information about the extraction process in these integrations, and lets you:
- Inspect, copy, and download extraction log files up to 50MB in size
- View historical logs over the past seven days
- Visualize how often extraction runs, how long it takes, and when it errors
- View logs for extraction jobs currently in progress
This feature is available for the following integrations:
-
Salesforce: (v1 only)
We’ll be working over the coming weeks to bring these logs to the rest of our integrations. Check out the docs for more info on this new feature.
Tags:
-
- Google BigQuery (v1) destination leaving open beta
-
Our Google BigQuery destination has left open beta and is now generally available! Check out the the docs for more info.
Tags:
-
- Facebook Ads integration: New version (v1)
-
A new (open-sourced!) version (v1) of our Facebook Ads integration is now available! This version, built from the ground up, supports field selection for increased control over what data you replicate through Stitch.
Learn more about the integration in our Facebook Ads integration documentation.
Tags:
-
- New integration: Autopilot
-
A new Autopilot integration is now available! Make your customer journeys take flight with data from Autopilot - now generally available as a Stitch source.
Get started by creating a new Autopilot integration or learning more in our documentation.
Tags:
-
- HubSpot integration: New version (v1)
-
A new (open-sourced!) version (v1) of our HubSpot integration is now available!
Major improvements include:
- Table selection
- Improved data typing
- Improved Primary Keys
- New tables:
hubspot_contacts_by_company
engagements
Open sourcing our integrations means more transparency into and flexibility around integration features. If you’d like to contribute to the HubSpot integration, you can check out the code here.
Learn more about the integration and these features in our HubSpot integration documentation.
Tags:
-
- Snowflake (v1) destination leaving open beta
-
Our Snowflake destination has left open beta and is now generally available! Snowflake is a SQL data warehouse built from the ground up for the cloud, designed with a patented new architecture to handle today’s and tomorrow’s data and analytics.
Check out the the docs for more info.
Tags:
-
- Replication scheduling change for non-database integrations
-
Non-database integrations now schedule replication by waiting the configured interval from the last time they were scheduled. This means that integrations with a daily schedule will run at the same time every day, and those with an hourly schedule will run at the same number of minutes past every hour. With the change, all integrations now use this scheduling logic.
Refer to the docs for more info and examples.
Tags:
-
- Change your destination!
-
Not happy with where your data is headed? Now you can do something about it!
Customers can now change destination types right in their account. Check out the docs for more info.
Tags:
-
- Snowflake (v1) destination now in closed beta!
-
Been waiting for Stitch to support Snowflake? Good news - Snowflake as a destination has just entered closed beta and testing has already begun! If you’re interested in getting on the list, add your email address here and we’ll let you know as we add more testers.
Tags:
-
- PostgreSQL (v1) destination leaving open beta
-
Our Amazon Aurora PostgreSQL destination has left open beta and is now generally available! Check out the the docs for more info.
Tags:
-
- Google BigQuery (v1) destination: Data type incompatibilities fix
-
We’ve improved the way Stitch loads data into Google BigQuery destinations. This update, already in production, fixes data type incompatibilities that were preventing certain tables from loading data into Google BigQuery datasets.
Tags:
-
- New and improved Stitch Docs
-
Stitch is excited to relaunch a redesigned version of our extensive documentation, including a brand new Getting Started guide and a guide on picking the right destination for you.
Tags:
-
- Google Cloud SQL PostgreSQL Support
-
We’re excited to report that Stitch supports the recently announced PostgreSQL flavor of the the Google CloudSQL service. It’s available as both an input integration AND a destination - a dual threat!
Tags:
-
- Support for Singer Taps - 10 new integrations!
-
Stitch now has built-in support for Singer Taps, the data extraction component of the the just launched simple, composable, open source ETL Singer project. This exciting new standard will make getting data out of any source and into Stitch (or elsewhere) simpler and more straightforward.
To learn more about Singer, check out the launch blog post.
By supporting this standard, Stitch now supports these integrations:
Tags:
-
- Google Analytics (v14-09-2016) integrations: New default Replication Frequency
-
The default Replication Frequency for Google Analytics integrations is now 6 hours. Want to replicate your data at a faster rate? Learn more in our docs.
Tags:
-
- New integration: Branch
-
Are you using Branch for deep linking in your mobile app? Now you can replicate event data from your Branch account to your destination and analyze app installs and engagement.
Get started by creating a new Branch integration or learning more in our documentation.
Tags:
-
- Stitch Webhooks and 14 new integrations
-
Introducing: Stitch Webhooks!
Stitch Webhooks is a configurable incoming webhook integration that replicates data from hundreds of webhook APIs directly to Stitch.
Additionally, we’ve added 14 new integrations to Stitch, powered by webhooks, as great examples of what you can replicate across different types of applications:
-
- Enhanced integration replication stats
-
Ever wondered where your data was after Stitch pulled it from the source but hadn’t arrived in your destination yet?
When the next replication job will start?
How many rows you’ve loaded today?
This information (and more) is now available in Stitch: Just click on any individual integration to experience this… experience. Check out the docs for more info.
Tags:
-
- Support for replicating database views
-
With the new year fast approaching, the Stitch engineers wanted to slip in a last update or two to the product before the ball drops. Customers can now see and replicate views for database integrations in Stitch - just pick a Primary Key and Replication Method. Enjoy!
Tags:
-
- Logging for rejected records
-
Occasionally, Stitch encounters data that it can’t load into a destination for a variety of reasons: Dates that fall out of range, table names that are too long, etc.
Stitch now logs these records into a special table (
_sdc_rejected
) for each integration. Each rejected record includes the reason for the rejection and as much data from the original record as can fit.Learn more in the docs.
Tags:
-
- In-app notifications now available
-
When things go wrong, as they occasionally do, Stitch sends an email notification about this issue. Now, those notifications are available inside the Stitch interface as well. Just click on the Notifications tab at the top of the page to see your active notifications.
Tags:
-
- Google BigQuery (v1) and PostgreSQL (v1) destinations now in open beta!
-
If Amazon Redshift isn’t the right destination for you, then we’ve got you covered. Our Google BigQuery and PostgreSQL destinations are now in open beta - and you can set them up in Stitch today! Both are available during destination selection in the onboarding process.
To learn more about how Stitch loads data into these destinations, check out the docs for Google BigQuery and PostgreSQL destinations.
Tags:
-
- Re-using schema names from deleted integrations
-
Delete an integration, and still attached to the schema name that went with it? Now you can re-use schema names from deleted integrations when you set up new ones.
Tags:
-
- Reset Replication Keys for individual tables in database integrations
-
Hot off the heels of support for resetting the Replication Keys for an entire database integration, Stitch now offers the ability to do it on a per table basis. Head down to the Table Settings in a database integration for an individual table and you’ll see the new button.
Tags:
-
- PostgreSQL destination (v1) in closed beta
-
Longing to get your data into Amazon Aurora PostgreSQL instead of Amazon Redshift?
Good news, everyone!
Amazon Aurora PostgreSQL as a Stitch destination is now in closed beta! Sign up today if you are interested in the beta and we’ll add you to the waiting list. In the mean time, learn more about this destination in the docs.
Tags:
-
- LONGNVARCHAR data type support
-
Up until now, Stitch supported
VARCHAR
,NVARCHAR
, andLONGVARCHAR
. Today we’ve added support for the crazy uncle of theVARCHAR
family,LONGNVARCHAR
!Just a note: If you have existing database integrations that have this data type, you’ll need to go in and specifically track it. Any new integrations will automatically track this data type.
Tags:
-
- New destination: Panoply.io
-
A new Panoply destination is now available!
Interested in Amazon Redshift but don’t want the hassle of maintaining an Amazon Web Services account? Exciting news - Stitch has partnered with Panoply to bring their managed data warehouse solution to our users - including a free tier with up to 10 million rows per month!
Get started by creating a new Panoply destination or learning more in our documentation.
Tags:
-
- Salesforce (v15-10-2015) integrations: Field selection support
-
Do objects in your Salesforce have a lot of fields? Do you only care about a few of them? Don’t you wish you could only track what you want?
Well, now you can! Starting today, you can select which fields to replicate from your Salesforce objects, giving you more control to keep your destination clean and simple. Learn more in the docs.
Tags:
-
- Close.io integration now in open beta
-
A new Close.io is now available!
The new integration will replicate all of your leads and activities to your warehouse, allowing you to analyze your sales cycle and always be closing.
Get started by creating a new Close.io integration or learning more in our documentation.
Tags:
-
- Google BigQuery (v1) destination in closed beta
-
Excited about Google BigQuery? We’ve got some big news for you!
Our Google BigQuery destination is now in closed beta. Sign up if you’re interested in joining the beta to start sending your data to Google BigQuery. In the mean time, learn more about this destination in the docs.
Tags:
-
- New integration bonanza!
-
Lots of integration related news today. Ready? Here we go:
-
Google Analytics: We’ve opened up the beta for our new Google Analytics integration. This new integration allows you to create custom datasets using Google Analytics’s metrics and dimensions.
-
Intercom: Intercom is leaving beta
-
Pardot: Pardot is leaving beta
-
Recurly: Recurly is leaving beta
-
Segment: Segment is leaving beta
-
Trello: Trello is leaving beta
Get out there and start moving some data.
Tags: -
-
- MongoDB (v11-01-2016) integrations: Replication Keys modification support
-
Ever select the wrong Replication Key for a integration when setting up Incremental Replication? If so, you’ll know that it’s a headache to change it.
Now, you can easily change it to the correct field within the Stitch app. Note that doing so will force a full re-replication of the table, to ensure all data is replicated using the correct Replication Key.
Tags:
-
- Zendesk (v15-10-2015) integrations: New group membership table
-
The Zendesk Support integration now includes a
zendesk_group_memberships
table, which contains information about the groups your Zendesk Support agents are members of. Fields in this table include:- Group membership ID (
id
) - URL
- Name
- Deletion flag
created_at
updated_at
- Group membership ID (
-
- NetSuite (v10-15-2015) integrations: Deleted record support
-
The NetSuite integration now includes a table called
netsuite_deleted
which contains a row for every deleted record that supports deletes. Accounting for deleted records is especially important if you’re performing any sort of aggregate function, such as totaling invoices or balancing your books.Learn more about utilizing the NetSuite deletion log in our [docs](https://www.stitchdata.com/docs/integrations/saas/netsuite-suitetalk/v10-15-2015#using-netsuite-deleted.
Tags:
-
- Reset Replication Keys for database integrations
-
Need to completely re-replicate all incrementally replicated tables in a database integration? Now you can(!) via the Integration Settings page on any MySQL, PostgreSQL, Microsoft SQL Server, or MongoDB integration. Take care though - the re-replicated rows count towards your monthly caps.
Tags:
-
- Change an integration's display name
-
Don’t like what you named your integration? Now you can change it!
Integration names can be edited on the Settings page for each respective integration. Note: Changing an integration’s name won’t change the name of the schema in your destination.
Learn more in the docs.
Tags:
-
- Amazon Redshift destination: New version (v2)
-
Now 50% Redshiftier, along with these improvements:
- Faster loading for high volume data streams
- Transactional upserts
- NO MORE VIEWS! Data is materialized into tables directly in the target schema, and these tables are never dropped
Learn more in the docs.
Tags: