www.stitchdata.com
Open in
urlscan Pro
2a05:d014:275:cb01:190c:7f02:2b97:3b21
Public Scan
Submitted URL: http://url4131.stitchdata.com/ls/click?upn=psxohvjA7njxs-2FpV72YnvKllnCHr0LgGRxJ-2F-2BfA49WkaSAA2OdoH-2FX3d-2BfSp-2FK4aa376bgL...
Effective URL: https://www.stitchdata.com/docs/troubleshooting/integrations
Submission: On May 25 via manual from IL — Scanned from DE
Effective URL: https://www.stitchdata.com/docs/troubleshooting/integrations
Submission: On May 25 via manual from IL — Scanned from DE
Form analysis 1 forms found in the DOM
<form>
<input class="st-default-search-input st-search-set-focus" type="text" value="" placeholder="Search this site" aria-label="Search this site" id="st-overlay-search-input" autocomplete="off" autocorrect="off" autocapitalize="off">
</form>Text Content
Stitch Docs
* stitchdata.com
* Contribute
* Changelog
* Sign up
*
All Systems Operational
* Getting started
* Basic concepts & system overview
* Select a data pipeline region
* Set up your Stitch data pipeline
* Understand your Stitch row usage
* Connect other data sources
* All Getting started
* Account management
* Manage your account
* Change your email and password
* Manage your email notifications
* Update company details
* Identify your data pipeline region
* Manage your API keys
* Manage Stitch partner access
* Manage Single Sign-on (SSO)
* Cancel your account
* Manage your team
* Team member basics
* Team member roles & permissions
* Add a team member
* Add a team member to multiple accounts
* Deactivate a team member
* Manage Single Sign-on (SSO)
* Notifications
* Urgency levels
* Categories
* In-app
* Email
* Reference
* Manage your email notifications
* Notification extensions
* Post-load notifications
* HIPAA-compliance
* Billing
* Understand your usage
* Basics
* Integrations
* Historical data loads
* Row counts
* Choose and change plans
* Payment details and invoices
* Cancel your account
* Unlimited plans
* All Account management
* Security
* Environment
* Data access policies
* Access control
* Stitch account access
* Connectivity
* Connection permissions
* Compliance
* Encryption
* Processing and retention
* Processing
* Data pipeline regions
* Retention
* Protocols and recommendations
* Issue reporting and handling
* All Security
* Destinations
* Overview
* Amazon Redshift
* Amazon S3
* Databricks Delta Lake
* data world
* Google BigQuery
* Google BigQuery v2
* Microsoft Azure Synapse Analytics
* Microsoft SQL Server
* MySQL
* Panoply
* PostgreSQL
* Snowflake
* Guides
* Choosing a destination
* Destination and integration compatibility
* Change destinations
* Integrations
* SaaS
* Overview
* 3PL Central
* ActiveCampaign
* AdRoll
* Amplitude
* AppsFlyer
* Asana
* Autopilot
* BigCommerce
* Braintree
* Bronto
* Campaign Manager
* Campaign Monitor
* Chargebee
* Chargify
* Close.io
* Club Speed
* Codat
* COVID-19 Public Data
* Crossbeam
* Darksky
* Deputy
* Desk
* Doorbell.io
* eBay
* Eloqua
* Facebook Ads
* Freshdesk
* Front
* FullStory
* GitHub
* GitLab
* Google Ads
* Google Ads (AdWords)
* Google Analytics
* Google Analytics (AdWords)
* Google Analytics 360
* Google ECommerce
* Google Search Console
* Google Sheets
* Harvest
* Harvest Forecast
* Heap
* Help Scout
* HubSpot
* iLEVEL
* Impact
* Intacct
* Intercom
* Invoiced
* JIRA
* Klaviyo
* Kustomer
* Lever
* LinkedIn Ads
* Listrak
* LivePerson
* Looker
* LookML
* MailChimp
* Mailshake
* Mambu
* Marketo
* Microsoft Advertising
* Microsoft Teams
* Mixpanel
* NetSuite
* NetSuite Suite Analytics
* Onfleet
* Outbrain
* Outreach
* Pardot
* Pendo
* Pepperjam
* Pipedrive
* Quick Base
* QuickBooks
* ReCharge
* Recurly
* Referral SaaSquatch
* Revinate
* RingCentral
* SaaSOptics
* Salesforce
* Salesforce Marketing Cloud
* Selligent
* SendGrid Core
* ShipHero
* Shippo
* Shopify
* Slack
* Square
* Stripe
* SurveyMonkey
* Taboola
* Toggl
* Trello
* Twitter Ads
* Typeform
* UJET
* Urban Airship
* UserVoice
* Wootric
* Workday RaaS
* Xero
* Yotpo
* Zendesk Chat
* Zendesk Support
* Zoom
* Zuora
* Databases
* Overview
* Amazon Aurora MySQL RDS
* Amazon Aurora PostgreSQL RDS
* Amazon DynamoDB
* Amazon Microsoft SQL Server RDS
* Amazon MySQL RDS
* Amazon Oracle RDS
* Amazon PostgreSQL RDS
* Amazon S3 CSV
* Google CloudSQL MySQL
* Google CloudSQL PostgreSQL
* Heroku
* Magento
* MariaDB
* Microsoft Azure MySQL
* Microsoft Azure SQL Database
* Microsoft SQL Server
* MongoDB
* MongoDB Atlas
* MySQL
* Oracle
* PostgreSQL
* Responsys
* SFTP
* Webhooks
* Overview
* AfterShip
* Branch
* Contentful
* Customer.io
* Delighted
* Drip
* FormKeep
* Incoming Webhooks
* Iterable
* Mailjet
* Mandrill
* Particle.io
* Segment
* SendGrid
* SendWithUs
* SparkPost
* Vero
* Zapier
* All integrations
* Connect other data sources
* Extracting data
* Selecting data
* Selecting tables and columns
* Replicating new and additional columns
* Database views
* Historical SaaS data
* Supported data types
* Replication scheduling
* Overview
* Replication Frequency
* Anchor Scheduling
* Advanced Scheduling using Cron
* Replication Methods
* Overview
* Log-based Incremental
* Key-based Incremental
* Full Table
* Replication Keys
* Database Replication Keys
* MongoDB Replication Keys
* Resetting Replication Keys
* Deleted record handling
* Deletion methods
* Log-based Incremental
* Key-based Incremental
* Full Table
* Monitoring progress
* Progress summary
* Extraction Logs
* Loading Reports
* Loading data
* Understanding loading behavior
* Understanding schema structure
* Overview
* Terminology
* Schema names
* Schema composition
* Table schemas
* System tables and columns
* Handling nested data structures
* Google BigQuery destinations
* Non-BigQuery destinations
* Loading behavior references
* Amazon Redshift
* Google BigQuery
* Google BigQuery v2
* Microsoft SQL Server
* Panoply
* PostgreSQL
* Snowflake
* All guides
* Monitoring loading
* Guides
* Understanding loading behavior
* Querying append-only tables
* Resolving record rejections
* References
* Loading behavior types
* Reserved keywords
* System tables and columns
* Analysis tools
* Analytics
* SQL editors
* Data science
* Troubleshooting
* Account and billing
* Destinations
* Integrations
* Replication
* Data discrepancies
* Error notifications
* All Troubleshooting
* --------------------------------------------------------------------------------
* Developers
* --------------------------------------------------------------------------------
* Changelog
DOCS > TROUBLESHOOTING > TROUBLESHOOTING INTEGRATION ISSUES
--------------------------------------------------------------------------------
Get started with a free trial today
Start my trial
Already have an account? Sign in
TROUBLESHOOTING INTEGRATION ISSUES
Having trouble connecting your database or SaaS integration? Investigating a
data discrepancy? Here you’ll find resources for some of the most common causes
of connection troubles and data discrepancies related to integrations.
--------------------------------------------------------------------------------
COMMON INTEGRATION ISSUES
Known Third-Party Issues Occasionally, some integrations used by Stitch may
encounter bugs or other issues. Whenever we’ve identified a third-party issue -
meaning on the integration provider’s end - we’ll post an update here.
Re-authorizing Integrations If you see a message that asks you to re-authorize
an integration, it means that Stitch’s permissions to that service have been
revoked.
Third-Party Integration Downtime From time to time, some of the applications and
databases we integrate with may experience downtime. During these outages,
Stitch may be unable to successfully connect to your data source and replicate
your data.
--------------------------------------------------------------------------------
DATABASE INTEGRATION ISSUES
Database Integration Connection Errors Resolve errors related to connecting to a
database integration.
Database Integration Extraction Error Reference Extraction errors for database
integrations and how to resolve them.
Database Integration Table Name Collisons In database integrations, if the names
of multiple tables canonicalize to the same name - even if they’re from
different source databases or schemas - name collisions and data discrepancies
can occur. This applies to any database integration available in Stitch.
Missing Mongo Data Due to Fields with Multiple Data Types Missing some Mongo
data? The root cause may be multiple data types in the Replication Key or
Primary Key (_id) fields.
Mongo Fields Missing from Replication Key Menu If you don’t see all the fields
you expect to in the Replication Key field for you Mongo integration, the root
cause may be insufficient permissions or a lack of field indexing.
MySQL TINYINT(1)/boolean Columns Stored as BIT If you’ve noticed that some MySQL
TINYINT(1) columns are displaying as BIT in Stitch, it’s usually due to how the
MySQL driver converts this data type.
PostgreSQL Read Replicas and Slow Replication If you connected a PostgreSQL read
replica as a database integration and are experiencing extremely slow
replication, the root cause may be the database’s standby settings.
Unable to Load Tables Due to Source Database Access Level Mitigate issues with
tables displaying in the Tables to Replicate tab by limiting the authorizing
database user’s access to source tables.
--------------------------------------------------------------------------------
SAAS INTEGRATION ISSUES
Common SaaS Integration Extraction Error Reference Extraction errors applicable
to all SaaS integrations and how to resolve them.
Google Sheets Extraction Error Reference Extraction errors for Google Sheets
integrations and how to resolve them.
Intercom Extraction Error Reference Extraction errors for Intercom integrations
and how to resolve them.
Missing Segment Data & Selective Integration Snippets If you’ve noticed some
missing data from your Segment integration, the culprit might be the selective
integration snippet on your website.
NetSuite Extraction Error Reference Extraction errors for NetSuite integrations
and how to resolve them.
Pardot Extraction Error Reference Extraction errors for Pardot integrations and
how to resolve them.
SaaS Integration Connection Errors If Stitch is unable to connect to one of your
SaaS integrations, the issue may be a security setting on the integration
provider’s side.
Salesforce Extraction Error Reference Extraction errors for Salesforce
integrations and how to resolve them.
Salesforce Replication & Selecting Too Many Columns If a single Salesforce
object has a large number of columns set to replicate, issues with replication
may arise.
Stale Salesforce Data & Formula Fields If you’ve noticed some out-of-date
Salesforce data in your data warehouse, the root cause may be a formula field.
©2022 Stitch. All rights reserved. Site last generated: May 23, 2022
Close
suggested results