Changelog

We have updated the Harvest community integration. The changes to the integration include:

• Upgrading to Harvest API V2
• Many new tables added for replication
• Schema modifications to align with Harvest API V2
• People table was renamed to Users (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 2.0 version of the Harvest integration can be found here.

Stitch has a new Amplitude integration for extracting event and user data from your Ampltidue 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. Learn more in our documentation and as always, we’ll extract your historical data to your destination for free.

We have just released a new Xero integration for extracting your accounting data to your Stitch destination. With the new integration, Stitch will replicate your core Xero objects including bank transactions, contacts, invoices, journal entries, payments, and more. Learn more in our documentation.

Create a new integration today and get seven days of free historical data.

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. Learn more in our documentation.

Create a new integration today and get seven days of free historical data.

Stitch has a new Yotpo integration. Yotpo generates social reviews, ratings, and other user-generated content for eCommerce websites. You can choose from the following tables to replicate to your Stitch destination:

• emails
• product_reviews
• products
• reviews
• unsubscribers

Create a new integration today with seven days of free historical data. Learn more in our documentation.

Stitch’s latest 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 that are 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

Check out our documentation for a complete overview of the integration features.

We’ve just released a new, open source version of the Stitch Zendesk Integration, based on the Singer standard. Major changes include:

• Table and column-level selection – You now have more control over what data you extract from Zendesk. We’ll only replicate the tables and columns that you want.
• Extraction logs – Gain a deeper understanding of the progress your integration is making and get full visibility into any errors that occur.
• Improved notifications – We provide you with more detail when something goes wrong to help you troubleshoot an issue.
• Extract ticket descriptions – With the new column-level selection you can choose to replicate ticket descriptions when you want to analyze the text of your Zendesk tickets.

Learn more about the new Zendesk integration and these features in our documentation.

We’re following up our recent release of MySQL binlog support with support for Postgres Logical Replication alongside an updated Postgres integration. Just like binlog, logical replication allows for incremental replication of a table without a replication key, and will capture and persist deletes.

To take advantage of these new Postgres features, you’ll most likely need to add a new Postgres integration in your Stitch account. Read more about it in our docs.

Thanks to the contributions of the Singer community, we now have five new integrations available in Stitch for all customers to use. 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. Here’s the full list:

• Quick Base - a platform for developers to build, customize and connect scalable, secure cloud applications
• Bronto - an email marketing platform for ecommerce
• Listrak - a marketing platform for engaging shoppers across all channels
• SendGrid Core - a platform for delivering transactional and marketing emails
• FullStory - a tool that offers high-fidelity session playback

We’ve just released a new version of the Stitch Marketo integration. 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’s 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.

Stitch has a new GitHub integration that 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.

We’ve just released version 2.0 of the Stitch HubSpot Integration. Major changes include:

• Column-level selection – Just as we do with tables, we’ll only replicate the columns that you want
• 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.
• hubspot_contacts_by_company has been renamed to contacts_by_company and made available via table selection
• Removal of isDeleted fields from the deals and companies tables. The HubSpot API does not provide accurate values for this data and we have removed it to reduce confusion.
• Removal of Keywords table – 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
• Improved updates of list memberships

Learn more about the integration and these features in our HubSpot integration documentation.

We’ve just released a new, open-sourced version of the Stitch Zuora Integration, based on the Singer standard. Major changes include:

• Deleted records – When using the AQuA API, an additional column (deleted) will be added to objects that support deletions to indicate the record’s deletion status
• New tables and columns – We’ve expanded the list of available tables and included new fields for joining each object with related Zuora objects
• Column selection – Just like tables, we’ll only replicate the columns that you want
• Choose between REST or AQuA API – Choose the API that best fits your needs, based on how much data you have, how frequently you need it, or whether you want deleted objects

Learn more about the integration and these features in our Zuora integration documentation.

If you have binary logging enabled for your MySQL database, Stitch can now use it to help replicate your data. Log-based replication allows for incremental replication of a table without a replication key, and will capture and persist deletes.

It’s now available as a replication method on the Table Settings of MySQL integrations. Check it out!

Stitch customers now have some control over when Stitch extractions will start extracting data. Released today, this new feature lets users set an extraction to “anchor” the replication schedule to a specific time to ensure that Stitch is getting data predictably and when it’s most needed.

A quick example - setting a 6 hour replication with an anchor time of 12 PM means that Stitch will extract on this schedule:

• 12:00PM
• 06:00PM
• 12:00AM
• 06:00AM

Full details can be found in our docs. And coming soon for our Enterprise customers - cron scheduling for much finer scheduling control.

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.

Starting today, Amazon S3 is now available in open beta as a destination for your Stitch data. 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 information. Try it out today!

Stitch’s Bing Ads integration lets you replicate data from Microsoft’s search advertising platform to the destination of your choice. It’s Stitch-certified and available to all Stitch users.

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
• Replication of data in an append-only fashion with an _sdc_report_date field so that you can see report changes over time and know when data was retrieved from the Bing Ads API

Learn more about the new integration in our documentation.

Today we’re happy to announce that discounted annual plans are now available - signing up for a year of Stitch will net customers 2 months free!

You can switch to an annual plan at any time. Sign up today!

We’ve updated our Facebook integration to use the newest version of the Facebook Marketing API - version 2.11. We’ve also added the following new features:

• Configurable attribution window when creating or editing a Facebook integration. Choose between 1, 7 or 28 days so that Stitch replicates historical data in alignment with the attribution window of your Facebook Ads account.

• A brand new table called 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.

• Upgrade to 2.11 API. With this version, Facebook has deprecated video_15_sec_watched_actions and it is no longer available.

We’ve released a new place to have your data delivered - data.world! 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.

It’s available today - give it a try!

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? Get in touch.

A few months ago, we launched access to extraction logs for select integrations, and today we’re excited to announce additional transparency on the loading end of things. 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

These changes are available for all Stitch users!

Today we’re excited to announce the addition of community-supported integrations, built as Singer taps, to be run in Stitch. Thanks to the success of the Singer open source project and the contributions of the Singer community, we are 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.

The full list of Stitch Community integrations (and Certified integrations as well) can be found here.

We’ve released a new version of our Google AdWords integration. A few highlights of the new integration include:

• Utilizing the AdWords API to replicate the most popular AdWords reports to Stitch
• Configurable fields in each of your selected AdWords reports
• Connection 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
• Replicating report data in an append-only fashion 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. You can get started today by creating a new AdWords integration.

Detailed extraction logs are now available for select integrations in Stitch, including MySQL, Facebook and Hubspot. 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 (one day for the free plan)
• Visualize how often extraction runs, how long it takes, and when it errors
• View logs for extraction jobs currently in progress

We’ll be working over the coming weeks to bring these logs to the rest of our integrations - in the meantime here is the list of the currently supported integrations.

Aurora MySQL Autopilot Braintree Facebook Ads Freshdesk Gitlab Google CloudSQL Harvest Hubspot MariaDB MySQL Outbrain Referral SaaSquatch Salesforce (new integrations) Shippo Taboola Urban Airship

We’ve released a new version of our Salesforce integration, giving you more control over how and what Salesforce data is replicated to your warehouse. A few things we now let you do and that we’ve done:

• 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 objects
• Toggle between incremental or full replication for objects
• 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 new version in our documentation. You can get started by creating a new Salesforce integration today.

Stitch has open-sourced a new version of the Facebook integration, built from the ground up. The new integration supports field selection for increased control over your data. Check it out by adding a new Facebook integration in your account.

Make your customer journeys take flight with data from Autopilot - now generally available as a Stitch source.

We’re delighted to announce a new, open-sourced version of our HubSpot integration. Major improvements include:

• Table selection
• Improved data typing
• Improved primary keys
• New table: hubspot_contacts_by_company
• New table: 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.

Not happy with where your data is headed? Now you can do something about it. Stitch is happy to announce that customers can now switch between destination types in their Stitch account.

If you’ve been waiting to get Stitch hooked up to Snowflake, wait no longer! We’re happy to announce that as of today, Snowflake has entered open beta and is available for any customer to use.

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.

Stitch has added 3 new integrations to help you expand your analyses. Sync your time tracking data from Harvest, your Urban Airship lists and segments and Taboola campaign performance to your data warehouse today. These integrations are all built using the Singer open source spec, allowing you to contribute and collaborate on their future improvements.

Time marches on, as do versions. Today, we’re happy to announce support for the latest version of Mongo, version 3.4. Additionally, Stitch now supports connecting securely to Mongo instances using SSL.

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 data warehouse destination - a dual threat!

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:

• Hubspot
• Marketo
• Shippo
• Close.io
• Referral SaaSquatch
• Freshdesk
• Braintree
• GitLab
• Wootric
• Outbrain

Are you using Branch for deep linking in your mobile app? Now you can replicate event data from your Branch account to your warehouse and analyze app installs and engagement. Learn more.

Today we are excited to announce the launch of Stitch Webhooks; a configurable incoming webhook integration that replicates data from hundreds of webhook APIs directly to Stitch. Additionally, we’ve added 15 new integrations to Stitch, powered by webhooks, as great examples of what you can sync across different types of applications: AfterShip, Contentful, Customer.io, Delighted, Drip, Iterable, Mailjet, Mandrill, Particle.io, SendGrid, Sendwithus, SparkPost, FormKeep, Vero, and Zapier.

Ever wondered where your data was after Stitch pulled it from the source but hadn’t arrived in your data warehouse yet? When the next sync will start? How many rows you’ve loaded today? This information (and more) is now available - just click on any individual integration to experience this… experience.

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. Today, customers can now see and replicate views for database integrations - just pick a primary key and replication method. Enjoy!

Occasionally, Stitch encounters data that it can’t load into a data warehouse for a variety of reasons - dates that fall out of range, table names that are too long, etc. Stitch now persists these rejected records into a special table (_sdc_rejected) for each integration, and includes the reason for the rejection and as much of the data as it can fit.

When things go wrong, as they occasionally do, Stitch already 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.

Not sure how far back Stitch reaches into a SaaS integration? Need more historical data for your analysis? Made a change and need to go get all the data again? Now you can do it - Stitch users can now configure during setup how far back a SaaS integration will replicate, and can review, reset, and re-sync from that date at anytime. Check it out under Integration Settings.

If Redshift is not the right data warehouse for you, then we’ve got you covered. Our BigQuery and Postgres data warehouse integrations are now in open beta - and you can set them up in Stitch today! Both are now available during destination selection in the onboarding process.

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” for an individual table and you’ll see the new button.

Longing to get your data into Postgres instead of Amazon Redshift? Good news, everyone - Postgres as a destination for Stitch is now in closed beta! Sign up today if you are interested in the Postgres beta and we’ll add you to the waiting list.

Up until now, Stitch supported VARCHAR, NVARCHAR, and LONGVARCHAR. Today we’ve added support for the crazy uncle of the VARCHAR family, LONGNVARCHAR! Just a note - if you have existing database integrations that have this datatype, you’ll need to go in and specifically track it. Any new integrations will automatically track it.

Interested in Redshift but don’t want the hassle of maintaining an Amazon Web Services account? Exciting news - Stitch has partnered with Panoply.io to bring their managed data warehouse solution to our users - including a free tier with up to 10 million rows per month!

Salesforce objects with a lot of fields can lead to unnecessarily wide tables when all you care about are a few of the fields. Starting today you can select which fields to sync from your Salesforce objects, giving you more control to keep your warehouse clean and simple.

The Stitch Close.io integration is now available in beta for all customers to use. The new integration will sync all of your leads and activities to your warehouse, allowing you to analyze your Sales cycle and always be closing.

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.

Lots of integration related news today. We’ve opened up the public beta for our new Google Analytics integration. The new GA integration allows you to create custom datasets using GA’s metrics and dimensions. Also, our Segment, Recurly, Trello, Pardot, and Intercom integrations have come out of beta and are ready for some ETL’ing. Now get out there and start moving some data.

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 - for example, totaling invoices or balancing your books. Learn more about utilizing the NetSuite deletion log in our docs.

The Zendesk integration now includes a zendesk_group_memberships table containing information about the groups your Zendesk agents are members of. Fields in this table include the group membership ID (id), URL, name, deletion flag, created_at and updated_at dates.

Need to completely re-sync all incrementally replicated tables in a DB integration? Now you can(!) via the Integration Settings page on any MySQL, Postgres, SQL Server or Mongo integration. Take care though - the re-synced rows count towards your monthly caps.

Don’t like what you named your integration? You can now fix that. Integration names can be edited within the settings for each respective integration. This does not change the name of the schema in your data warehouse.

We added a changelog to stitchdata.com to make it even easier to learn about Stitch product updates. Very meta.

All Postgres fields of type JSONB and ARRAY may now be synced from integrations page. These fields will be converted to strings in Redshift.

Now 50% Redshiftier, along with these improvements: faster loading for high volume data streams, transactional upserts, and NO MORE VIEWS - data is materialized into tables directly in the target schema, and these tables are never dropped.